Skip to content
Rudy Rodarte . comRudy Rodarte . com

Rudy Rodarte . com

Follow Rudy as he programs, travels and designs.

  • Home
  • SQL Server
  • DTS & SSIS
  • ActiveX
  • Windows
  • About

Browsing Tag

SQL Server

SQL BlogsAugust 9, 2016by Rudy1 min63,807

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

SQL BlogsSeptember 30, 2014by Rudy3 min1,872

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 BlogsSeptember 24, 2014by Rudy1 min2,811

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 BlogsJuly 10, 2015by Rudy1 min3,120

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 min2,277
SQL CLR Prodecure

Enable CLR on SQL Server

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

SQL BlogsOctober 5, 2011by Rudy1 min1,748
SQLSaturday97

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 min2,147

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

Posts navigation

  • 1
  • 2
  • 3
  • 4
  • ...
  • 7
Powered by Passion Blogger WordPress Theme by appscreo.