Subscribe to this blog
Archives: June 2010
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in professional sports, but there have been a lot of big moves lately that reminds me of the fury of trades you see right before the deadline in sports. And… Read more
1 comments, 530 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 29 June 2010
Error 25602 When Creating an Extended Events Session: a Security Risk
Error 25602 When Creating an Extended Events Session: a Security Risk
I came across an interesting issue recently when helping someone troubleshoot error 25602 that he was receiving when starting an Extended Events session. I found the cause of the error to be quite alarming. To make matters worse,… Read more
2 comments, 705 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 23 June 2010
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a discussion group today about how to get a list of tables that have had data modifications (updates, deletes, or inserts) in the last 24 hours. A few suggestions… Read more
8 comments, 516 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 18 June 2010
Building HTML Emails With SQL Server and XML
Building HTML Emails With SQL Server and XML
I’ve written a lot of custom reports in my days that output data as an HTML string and then sends it via email. It makes for an easy to read, colorful report, and PM’s and business folks love easy to read, colorful… Read more
13 comments, 13,299 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 June 2010
SQL Saturday #43 in the Books
SQL Saturday #43 in the Books
Another great SQL Saturday is in the books!! I had submitted 2 sessions, but there were so many submissions, most people were only selected for 1. I repeated my session on SQL Profiler/Trace that I did last year. This year I added a… Read more
2 comments, 204 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 June 2010
Interesting Case of SSIS Failures
Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved performance. Yes, improved performance caused the package to fail almost every run. We migrated the application to newer, better hardware resulting in overall improved performance of all ETL activities.… Read more
0 comments, 335 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 June 2010
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
This blog entry is participating in T-SQL Tuesday #007, hosted this month by Jorge "@SQLChicken" Segarra (Blog|Twitter). You are invited to visit his blog to join the party and read more blogs participating in…
5 comments, 1,162 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 8 June 2010