Server Roles and Azure Active Directory in an Azure SQL Database
This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login...
2017-11-29
618 reads
Checking SQL Configuration with Pester & Dbatools
I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...
2017-12-13 (first published: 2017-11-29)
1,856 reads
Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2
Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is...
2017-11-29
738 reads
Introduction to Extended Events
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...
2017-11-29
941 reads
How to Help with dbatools Comment-based Help
I wrote a post over on the dbatools website about how to get involved with improving comment-based help
Working on the CBH is a great way to get started with...
2017-11-29
7 reads
AlwaysON Reporting Solution with SSRS
We will be going over the implementation of automatic failover setup for reporting services using availability groups. The report server databases...
2017-11-28
5,390 reads
PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates
One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...
2017-11-28
280 reads
Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,259 reads
I have a new Passion
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
365 reads
My Favorite SSMS Shortcut (After Copy/Paste)
Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...
2017-11-28
246 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