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
Rudy Rodarte’s slides and code from SQL Saturday 309 are up. Download the new hotness. Continue reading SQL Saturday 309 Slides are up
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.
Learn how to enable .NET CLR on SQL Server. Continue reading Enable CLR on SQL Server
Earlier this year, I wrote about Remote Desktop not returning to fullscreen after minimization in Windows 7. The solution is to use Control-Alt-Break to bring the remote desktop window to full screen. And life was grand. I noticed some comments that people had Laptops where their keyboard did not have a Break key.
Continue reading “Remote Desktop won’t go back to Full Screen Part 2”
Download my slides and source code from my SQL Saturday 97 presentation. Continue reading SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY