View SSIS Variables via Message Box
You can use a VB or C# message box to view the current value of a variable. No more guessing! Continue reading View SSIS Variables via Message Box
Browsing Tag
SQL Server
Dev Connections 2014 Wrap Up
Read Rudy’s thoughts on Dev Connections 2014, including the food, the facility and the instructors. Continue reading Dev Connections 2014 Wrap Up
SQL Nexus Install
SQL Nexus is a powerful tool for analyzing SQL Server trace files generated by PSSDiag. However, the install process takes a bit of work. Follow along to get SQL Nexus working on your local machine. Continue reading SQL Nexus Install
Find and count words in a string via SQL.
For all the power of SQL Server, some things a still missing. In Microsoft Word or Notepad++, when you search for a word in a document, you get the count of appearances, too. But in SQL, you can search for … Continue reading Find and count words in a string via SQL.
Enable CLR on SQL Server
Learn how to enable .NET CLR on SQL Server. Continue reading Enable CLR on SQL Server
SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Download my slides and source code from my SQL Saturday 97 presentation. Continue reading SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Incorrect Syntax Near go revisited
Incorrect Syntax near go. We’ve all gotten this error before, but why does this happen? Watch a video explaining why you cannot use GO inside of sp_executesql Continue reading Incorrect Syntax Near go revisited