SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...
2015-09-24
1,610 reads
Database Mirroring Isn’t Going Anywhere
AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in...
2015-09-24
1,331 reads
Dynamic SQL & Quotename
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
920 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...
2015-09-23
873 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...
2015-09-23
48 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...
2015-09-23
72 reads
Freecon – Oct 27 in Seattle
It is well known that there is a wealth of information within Extended Events. One can tap plenty of information about performance issues, errors, or general interest type stuff...
2015-09-23
20 reads
Freecon – Oct 27 in Seattle
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training,...
2015-09-23
812 reads
Inside an SSDT Deployment Contributor
In my deployment filter I have been asked a couple of times to allow columns that exist on a table...
2015-09-23
1,001 reads
Inside an SSDT Deployment Contributor
In my deployment filter I have been asked a couple of times to allow columns that exist on a table...
2015-09-23
40 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
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
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