-
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.
-
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
-
Find your SQL Server Profiler Template Path
Learn where SQL Server Profiler saves your Templates.
-
Display a Page Count in SSRS
Learn how to add a date printed and a page count in the footer of your SSRS report. Even if you have errors with Globals!OverallTotalPages.