SQLBlogNess

1.21 - SQL Profiler Trace Duration Units

Always have to look this up so it must be useful: Beginning with SQL Server 2005, the server reports the duration of an event in microsec...
1.20 - SQL 2012 linked server query and loading a result set into an object

I recently upgraded an environment into a SQL 2012 environment from SQL 2008. Today one of the devs could not run a distributed query to one...
1.01 - Map Postcodes in SQL Server Reporting Services

Another fantastic link to a subject that I have needed to look at this week. Sometimes things all fall into place at the right time. This ...
1.05 - Bulk Insert Row Terminators Gotcha

I recently stumbled across this issue when a dev asked me to have a look at a file that he was attempting to import. Basically, the bulk imp...
1.19 - Running a 32bit SSIS Package in a 64bit SQL Environment with the SQL Agent

I have always seen lots of issues with this whenever I have been performing these tasks and I have now found a method that ensures that it w...
1.18 - SQL Aliases to Named Instances

This can be a tricky issue to resolve and there is not too much about it that I have found. However, there is a nice article here ( setting-...
1.00 - What a way to start up a blog with a great reference such as this - Kendal Van Dyke: Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

I have taken a quick look over this and it looks like a game changer in my world. This could be a real time saver! I will be testing this as...
1.22 - Identifying A Database From The Data File

A few times in the past I have had to deal with trying to identify a detached data file and try to work back as to what database the files b...
1.11 - SSIS 2012 - Package Configurations Menu Option Missing

Useful Tip if you are developing BI in Visual Studio 2012 - http://dataqueen.unlimitedviz.com/2012/01/ssis-2012-package-configurations-menu...
1.09 - API CURSORS and linked servers - Grrrrr!!

Like I always say; Every day is a school day. A normally well performing system today suddenly started using 99% utilisation constantly. Af...