Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

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

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

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

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

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

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…

Read more