ProgrammingSeptember 24, 2014by Rudy1 min344

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

SQL BlogsJuly 10, 2015by Rudy1 min761

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.

SQL BlogsFebruary 15, 2012by Rudy1 min368

Enable CLR on SQL Server

Learn how to enable .NET CLR on SQL Server. Continue reading Enable CLR on SQL Server

SQL BlogsOctober 13, 2011by Rudy1 min1,247

Remote Desktop won’t go back to Full Screen Part 2

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”

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY

Download my slides and source code from my SQL Saturday 97 presentation. Continue reading SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY

SQL BlogsAugust 23, 2011by Rudy1 min485

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 Continue reading Incorrect Syntax Near go revisited