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
113 reads
SSC Editorial: A Visit to Microsoft
A Visit to Microsoft was posted back in August and I just re-read it. Here’s a quote that might interest you:
As...
2016-10-10
395 reads
Statistics Are Vital For Query Performance
This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...
2016-10-19 (first published: 2016-10-10)
2,091 reads
Columnstore Indexes – part 87 (“Indexed Views”)
Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...
2016-10-10
508 reads
Special Discount for PASS Summit Precon
I’m very honored to be speaking at the PASS Global Summitagain this year in Seattle during the week of October...
2016-10-14 (first published: 2016-10-10)
759 reads
Monday Night Networking at Summit 2016
It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.
For those of...
2016-10-10
549 reads
Power BI Custom Visuals Class (Module 20 – Word Cloud)
In this module you will learn how to use the Word Cloud Power BI Custom Visual. The Word Cloud is...
2016-10-18 (first published: 2016-10-10)
1,838 reads
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,869 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
357 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
479 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers