Randomized color report? So help my CODE!
Writing a Reporting Services report can be challenging, making you use the most of its features so that even the simplest tasks may require wider range of capabilities. One of those is using .NET code (VB.NET) in the report. This post outlines… Read more
SQL Server has some handy features: one of those features is dbmail, which I tend to use less until I’ve been asked to create a reports to be distributed on a daily basis. These reports can’t use any external tools (such as Reporting Services) and no attachments are allowed. The… Read more
Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward, but this time was different.
The mirroring should have been scripted, so it could be embedded in an application’s installation and deployed worldwide. As in any other sensitive infrastructure solution,… Read more
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to have no pattern of any kind, there were no long blocking queries, the packages’ sessions were SUSPENDED until they timed out, and the sessions were not blocked at any… Read more