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 to perform operations in a more optimal way in...
2015-09-24
9 reads
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
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
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...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers