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!
SQL Saturday 408 – Event Wrap Up
I'm back in Austin from SQL Saturday 408 in Houston, TX and back at work. The event was a great success and I liked everything from top to bottom. You can get the slides from all the sessions, including mine at the event page.
Training Links
At work, we are approved for 2 training classes per year. Here is a list of SQL Server training classes that I’ve found, aside the the popular ones everyone knows about: Global Knowledge Quick Start – 2014 Quick Start – 2012 Solid Q Benchmark Learning I do not get paid for these links. I am...
Dev Connections 2014 Wrap Up
Read Rudy's thoughts on Dev Connections 2014, including the food, the facility and the instructors.
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.
SQL Saturday 309 – Event Wrap Up
I'm back in Austin from SQL Saturday 309 and back at work. The event was a great success and I liked everything from top to bottom. You can get the slides from all the sessions, including mine at the SQL Saturday 309 event page.
SQL Saturday 309 Slides are up
Rudy Rodarte's slides and code from SQL Saturday 309 are up. Download the new hotness.
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 a string in a VARCHAR field, but the result only appears once. What I really...
Remote Desktop won’t go back to Full Screen Part 2
Learn how to use AutoHotKey to resize your remote desktop sessions back to full screen after minimization in Windows. Never deal with scroll bars in RDP again!
SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Download my slides and source code from my SQL Saturday 97 presentation.
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
