Checking the Health of your CLR
Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great...
2018-01-16
29 reads
Checking the Health of your CLR
The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that...
2018-01-16
1,027 reads
How To Split Table Partitions Automatically
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
983 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it’s not likely to erupt any...
2018-01-16
1,179 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it's not likely to erupt any time soon, the park is constantly monitored for geological...
2018-01-16
20 reads
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day
Chrissy has written about dbachecks the new up and coming...
2018-01-15
342 reads
SQL Server on Linux Series: Expanding LVM Drives
Next in our SQL Server on Linux series is one important question. On Windows, if you’re about to run out...
2018-01-29 (first published: 2018-01-15)
1,191 reads
Query Shortcuts in SSMS (Day 15)
There are several shortcuts that can be assigned to run a stored procedure. Known as Query Shortcuts, these can be...
2018-01-15
330 reads
Dissecting SQL Server, The Internal Structure of a Row
I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages. But what do...
2018-01-26 (first published: 2018-01-15)
2,008 reads
Reading GDPR
In case you’re interested, the GDPR law is actually not bad to read. You might be affected by this, so...
2018-01-15
475 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