Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3
I ran across a bug in SSMS 2016 CTP 2 back in August. If you try to right click and...
2015-12-16
445 reads
Scripting out multiple scripts from the Object Explorer Details window.
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...
2015-12-16
596 reads
Indexing Strategy
What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...
2015-12-28 (first published: 2015-12-16)
3,545 reads
When Should You Use Identity as a Clustered Index Key?
A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be...
2015-12-28 (first published: 2015-12-16)
3,828 reads
Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment...
2015-12-24 (first published: 2015-12-16)
2,374 reads
Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance. This one works well for local servers. If you...
2015-12-15
25 reads
Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance.
This one...
2015-12-22 (first published: 2015-12-15)
1,795 reads
Giving Thanks Around the Holidays
In the West, the holiday season summons different memories and plans for different people. The thought of gorging on a...
2015-12-25 (first published: 2015-12-15)
1,022 reads
Temporary Post Used For Theme Detection (dff6a50a-5239-4df1-af43-b1e60d02dde4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (621301ab-a053-48fc-a7ec-01dc1d5fe152 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2015-12-15
811 reads
Benefits from Data Lifecycle Management
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,749 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