-
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…
-
Enable CLR on SQL Server
Learn how to enable .NET CLR on SQL Server.
-
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.