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 Category
SQL Blogs
SQL and SQL Server database topics. Includes design, issue resolution and tips.
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 – … Continue reading Training Links
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
SQL Saturday 309 Slides are up
Rudy Rodarte’s slides and code from SQL Saturday 309 are up. Download the new hotness. Continue reading SQL Saturday 309 Slides are up
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