Making the case for CamelCase naming
Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...
2016-10-17 (first published: 2016-10-10)
3,867 reads
Migrating Database Collation - The Red Gate Way
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
356 reads
Mastering Index – Nonclustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Nonclustered Index. Take...
2016-10-10
473 reads
Azure SQL Database – TDE
I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...
2016-10-10
453 reads
PASS Speaker Idol 2016 – Todd Kleinhans
I am grateful and thankful I got selected to speak again at Speaker Idol. It has been a crazy and...
2016-10-09
364 reads
SQL Server 2016 Query Store - Gentle Introduction - 1
Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give...
2016-10-09
553 reads
Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
145 reads
Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
3,867 reads
Step by Step: WHERE, GROUP BY, and HAVING
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...
2016-10-07
624 reads
Back for a Day
I hope everyone is well in Florida, but the hurricane caused a postponement of SQL Saturday Orlando. Fortunately I caught...
2016-10-07
427 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers