SSIS packages are handy. They can do all sorts of things and the developers here use them a lot. One very useful feature is that you can set up connection objects in your package so it can connect to any of your servers to do what it needs to do. This is also one of […]
Like many people who work in IT departments, my company gives me two accounts to their network. One is a “regular” user account – one with the standard permissions every employee gets. The other is one I can use to do my IT work – it has administrator privileges to many systems, including all our […]
I installed my first SQL 2012 server recently and came across an interesting issue I thought I’d share. When you connect to a SQL 2012 server using SSMS from SQL 2008 R2 and view the database options page, you do not see options for the database compatibility level. Here is a look at the compatibility […]
I’m not a font junkie. I typically don’t care too much about what font programs use and the only thing I notice is if the font is serif or sans serif. Although I did publish a music fanzine many years ago called Fruitbasket Upset with a friend of mine and played around with different fonts […]
I’ve written in the past about some of the ways you can configure SQL Server Management Studio to help you make your life a bit easier. I’ve discovered two more little tricks I thought I’d pass along. Every DBA has a handful or more of T-SQL scripts they use on a regular basis to make […]