Webinar Today at 3pm
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
392 reads
Blog Posts
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
322 reads
You Broke My Tail Light
That’s the first thing I heard when I answered the phone recently. I was working on an change I needed...
2014-03-13
740 reads
A summary of the SQL Server security #datachat is live
Recently I posted about participating in a #datachat about SQL Server security. As it turned out, we didn’t talk about...
2014-03-12
642 reads
Dell Webinar: 10 Ways To Abuse T-SQL
I’m a bit late getting this posted, so to the two of you waiting to see it, I apologize. Back...
2014-03-12 (first published: 2014-03-02)
1,943 reads
Fun in DateTime Calculations
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there...
2014-03-12 (first published: 2014-03-02)
4,596 reads
Schema & Renaming Fun
I wrote the SQLServerCentral question of the day that is live today called Schema & Renaming Fun. Mildly interesting, but looking...
2014-03-12
468 reads
Setting Up Tabular Models on Windows Azure
In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were...
2014-03-12
2,765 reads
Smart Moves with SQL Server VMs – VM Proximity
Today I am starting a new series of short posts designed to help SQL Server administrators with virtualized SQL Servers...
2014-03-12
779 reads
Why Did My Job Fail Anyway?
One of my biggest pet peeves when I check a new SQL Server for a client is the fact that...
2014-03-12
1,067 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