SQL Server 2019 is here
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I presented this year at...
2019-11-06
3 reads
Blog Posts
Volunteers
This week is the PASS Summit and it has me thinking about all of the amazing work done in our ... Continue reading
2019-11-06
6 reads
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
114 reads
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
2 reads
Event-driven architecture (EDA) with Azure Data Factory - Triggers made easy
(2019-Oct-27) Creation or deletion files in your Azure Storage account may initiate data ingestion process and will support your event-driven data platform architecture. Image by Lars_Nissen_Photoart from PixabayMicrosoft recently introduced an...
2019-11-05 (first published: 2019-10-28)
802 reads
Every Execution Plan Is An Estimated Plan
I consider myself to be the most responsible for making such a huge deal about the differences between what is labeled as an Estimated Plan and an Actual Plan....
2019-11-05 (first published: 2019-10-22)
513 reads
MS Ignite Day#1 Recap
What an amazing first day at Microsoft Ignite that all started at about 6:30 this morning when I got in line to be one of the first 3000...
2019-11-05
91 reads
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-05
9 reads
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-05
33 reads
Smart Tlog Bkp
another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the...
2019-11-05
19 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers