Linked Servers and Stats
Linked Servers
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and...
2017-10-17
1,510 reads
Automating Everything with PowerShell – Getting Started #tsql2sday
I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...
2017-10-17
910 reads
Bug with STATISTICS TIME?
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
524 reads
Quick SQL Prompt Updates in a Pattern
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2017-10-17
1,154 reads
Microsoft Ignite Big Data Presentations
There were so many good presentations at Microsoft Ignite, all of which can be viewed on-demand. I wanted to list...
2017-10-17
1,485 reads
Monitoring SQL Server database status changes using T-SQL and PowerShell scripts
Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number...
2017-10-17
916 reads
Performing in-database predictions in SQL Server 2016 & 2017
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and...
2017-10-17
2,059 reads
How to Make SQL Server Act Like A Human By Using WAITFOR
Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance. You take pride in knowing how to add indexes and...
2017-10-17
211 reads
How to Make SQL Server Act Like A Human By Using WAITFOR
Photo by Fischer Twins on Unsplash
You probably tune your queries for maximum performance. You take pride in knowing how to add indexes and refactor code in order to squeeze out every last...
2017-10-17
24 reads
All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters
As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist...
2017-10-31 (first published: 2017-10-16)
2,645 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers