Azure SQL Database Online Columnstore Unicorn and Rainbow Theory
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
187 reads
Blog Posts
Copy Data From On-Premise SQL Server To Azure Database Using Azure Data Factory
Let’s take a break from our SQL Server 2017 Reporting Services Basics Series and jump to Azure Data Factory (v2)....
2019-02-21
1,910 reads
How To Check How Far Behind Your SQL Server Log Shipping Secondary Is
Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...
2019-02-21 (first published: 2019-01-31)
2,763 reads
Memory grants 7: DISTINCT (Distinct Sort)
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
407 reads
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes...
2019-02-21 (first published: 2019-02-01)
2,482 reads
Webinar: Migrating SQL Server Integration Services to the Cloud
I will be doing a webinar for MSSQLTips.com about migrating your on-premises SSIS solutions to the Azure cloud. Specifically, the Azure-SSIS integration runtime environment in Azure Data Facture. The...
2019-02-21
22 reads
Azure Key Vault Logging
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
238 reads
How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
2019-02-20 (first published: 2019-01-31)
6,316 reads
Index maintenance freebies
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
2019-02-20 (first published: 2019-01-30)
2,432 reads
Odd Behavior With LOB/Overflow Data
In writing some sample demos around LOB and Row-Overflow data I found a couple of oddities in the way reads...
2019-02-20
172 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers