Sign up for Game Night
This year PASS is hosting Game Night as an official event, providing the room and support. Kevin Hill (b | t)...
2017-09-25
410 reads
Talking about Migrating to Azure SQL Database at #MSIgnite this week
This week I will have two talks on migrating existing database to Azure SQL Databases at Microsoft Ignite. If you are there and curious about migrating your existing databases...
2017-09-25
4 reads
Talking about Migrating to Azure SQL Database at #MSIgnite this week
Speaking on Migrating to Azure SQL Database at Ignite 2017
This week I will have two talks on migrating existing database...
2017-09-25
368 reads
Power BI Custom Visuals Class (Module 70 – Custom Calendar By Akvelon)
In this module you will learn how to use the Custom Calendar by Akvelon. The Custom Calendar by Akvelon is...
2017-10-03 (first published: 2017-09-25)
2,116 reads
Database Fundamentals #12: Adding Data with SSMS GUI
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
497 reads
Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.
As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...
2017-09-25
171 reads
Saving and restoring session options settings
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations....
2017-09-25
491 reads
Azure SQL Database Active Geo Replication Changes
Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...
2017-09-25
534 reads
SQL Grouping on Sums (with testing)
I ran across a post recently that I thought was an interesting T-SQL problem. The user wanted to group values...
2017-09-25
484 reads
Box-and-whisker plot and data patterns with R and T-SQL
R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been...
2017-10-03 (first published: 2017-09-25)
2,660 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
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