Finding the SSRS Log File
Discover how to find and examine the SQL Server Reporting Services log file.
T-SQL Tuesday July 2018 – Working with Dates
This snippet is so nice, I’m posting it again! I’ve utilized the script below at least once a week, for either reports, or working with large data sets. Rather than reinventing the wheel, I’m posting my code here and to GitHub for everyone to see. The script expects two date parameters, a start date and...
Generate fresh data for WideWorldImporters
See how to use built in stored procedures to grow the WorldWideImporters SQL Server database with new, current data.
Loop over dates in SQL Server
I’ve written the script below at least once a month, for either reports, or working with large data sets. Rather than reinventing the wheel, I’m posting my code here and to GitHub for everyone to see. The script expects two date parameters, a start date and an overall end date. The script will then assign...
Stored Procedure Results in an SSIS Message Box
I was recently asked if it is possible to display the results of a query / stored procedure in an SSIS Message box. The answer is Yes, with a bit of C#.
Recover the missing Report Data tab in SSRS
Learn how to recover the Report Data tab in SQL Server Reporting Services (SSRS)
SQL Saturday 550 – San Antonio – Sessions I’m Attending
I was lucky to be picked to present at SQL Saturday 550 in San Antonio this year! But, not only do I love presenting, I also love attending as many sessions as I can. Here are the sessions I am looking forward to: Log SQL Server Activity on a Budget – Rudy Rodarte – Level:...
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!
Dev Connections 2014 Wrap Up
Read Rudy's thoughts on Dev Connections 2014, including the food, the facility and the instructors.
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.
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...
