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...
2010-06-29
2,139 reads
SQL Server Soldier :: News from the frontlines of the database wars
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...
2010-06-23
3,611 reads
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...
2010-06-18
1,954 reads
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...
2010-06-15
62,769 reads
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...
2010-06-12
914 reads
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...
2010-06-10
1,071 reads
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...
2010-06-08
4,933 reads
Taking A Medical Approach to Performance Troubleshooting
Taking a Medical Approach to Performance Troubleshooting
I find it difficult sometimes to explain to someone how to have a take...
2010-05-31
2,658 reads
Are you a DBA? You might Be!
Are you a DBA? You might Be!
On Twitter, people do a lot more than gossip and post messages about mundane,...
2010-05-29
2,519 reads
Study Tips for the SQL MCM Exams
Study Tips for the SQL MCM Exams
I met the new rotation of the SQL Server Certified Master program on Friday....
2010-05-16
2,167 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers