SQL Server Data Tools: A spork of sorts (part one)

Prior to SQL Server 2012 the Business Intelligence (BI) toolset was made up of just Business Intelligence Development Studio (BIDS). Easy to install as it was part of the SQL Server installation media. Now with database development tools you had to go the route of getting a license for Visual... [Read More]

SQL Server Prerequisites .NET Framework

As of SQL Server 2012 the .NET Framework prerequisite of .NET 3.5 SP1 is no longer installed for you by the SQL Server installer if it is found to be missing from the server. Now with Window Server 2008 R2 SP1 or higher this is simply enabling the feature within... [Read More]

The treasures of the SQL Server Error Log

I am fairly active on Database Administrators QA site on StackExchange.com.  On average, most questions you find folks asking are about troubleshooting some error they are getting running code or some application is returning. I have noticed one of the most common comments we end up adding to a question... [Read More]

CTRL plus ALT plus what?

Depending on how far back you go in the technology field you all remember having to use CTRL+ALT+DELETE to change your password for your domain account. [Read More]

SQL Server Activity Monitor Script

You ever wonder what goes in the background of Activity Monitor? Me neither, I just used it every so often when I wanted a quick peek at what was going on for a server. Microsoft has actually made changes to Activity Monitor in SQL Server 2012 Service Pack 1 that... [Read More]