Randomized Colors in Report
Randomized color report? So help my CODE!
Writing a Reporting Services report can be challenging, making you use the most of...
2014-07-01
1,314 reads
Generating Email Reports using XML
SQL Server has some handy features: one of those features is dbmail, which I tend to use less until I’ve...
2014-06-19
432 reads
Mind the Gap
Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...
2014-03-04
581 reads
Memory Timeouts
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...
2013-12-30
1,158 reads
Blogs
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your...
Daily Coping 29 Nov 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Help with SQL Query
Hello SQL experts, Please see attached file for table detail. I have a temp...
Get Summary Data for Last 52 weeks by Week
I have a table which stores shipment data by date. We have a need...
Ask SSC