Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
148 reads
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
373 reads
Working with Data in Always Encrypted
In this post we’re going to create some encrypted columns in a table in a test database and look at...
2017-06-06
11,124 reads
var Microsoft_Data_Platform_MVP = “Yip.”;
The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...
2017-06-06
660 reads
SQL Server 2016 What's New With TSQL
DROP IF EXISTS
This allows us to drop objects without first having to check if they exist. It works on pretty...
2017-06-06
56 reads
Be Aware of CARTESIAN PRODUCT When Using Join Keys in SQL
I got a massive satisfaction last week when I was able to bring down the execution time of a sql...
2017-06-06
4,253 reads
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
584 reads
SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
277 reads
VSTS– Hosted Agent is the Default for Releases
In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...
2017-06-05
613 reads
Database Fundamentals #1: Install SQL Server
To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...
2017-06-05
538 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
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
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
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers