How wait statistics are generated
In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a...
2014-03-06
696 reads
Blog Posts
Omaha SQL Server Users Group Session
Photo from @sqlrus
Tonight I was lucky enough to be able to present to my home SQL Server Users Group in...
2014-03-06
576 reads
The weakest link in database security
The weakest link in database security is the same as for most all IT security: people.
Because the weakest link is...
2014-03-06
958 reads
Virtual Lab – Adapter Setup
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-03-06
1,072 reads
A Community Challenge
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
Among other...
2014-03-05
620 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
739 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
777 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
507 reads
SQL Server Data Encryption Options
SQL Server Data Encryption Types
Businesses today have a greater need than ever to protect their data from security breaches. Data...
2014-03-05
3,266 reads
SQLSaturday #318 in Orlando on September 27, 2014
Number 8! Our eight annual SQLSaturday in Orlando is coming up on September 27th (note, it’s technically our tenth, but...
2014-03-05
657 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