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
514 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,150 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,483 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
912 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,041 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
203 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
16 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,633 reads
Power BI Custom Visuals Class (Module 73 – Heat Streams)
In this module you will learn how to use the Heat Streams Custom Visual. The Heat Streams visual allows you...
2017-10-16
836 reads
Speaking at IT/Dev Connections 2017 – San Francisco!
I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my second year at IT/Dev Connections, real content for IT...
2017-10-16
3 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers