What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The...
2017-11-18
1,419 reads
One Line of Code Is All It Takes
This tweet showed up in the dbatools Slack channel Friday afternoon.
Just did my first Pull Request to "contribute" to @psdbatools. Granted, the code change was a single line of...
2017-11-18
10 reads
One More Trip and Down for the Count
The last month has been a rough one for me, with lots of travel. I was on trips for 4...
2017-11-17
1,010 reads
New Session: Data Types Do Matter
I started speaking on a semi-regular basis this year after many years of trepidation. You can read about my first...
2017-11-17
312 reads
Geek Sync Recording: Taking Control of Your SQL Server Sprawl
Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:
Take...
2017-11-17
449 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
45 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
337 reads
Training Day in London: Building Better SSIS Packages
I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference...
2017-11-17
367 reads
SOS - Save Our Souls or SQL Operations Manager
On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry!...
2017-11-17
635 reads
Friday Reading 2017-11-17
Fun week, lots of stuff to organise and prepare for! Whilst I’ve had some downtime I’ve been reading…
Write your first...
2017-11-17
304 reads
Blogs
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...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
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