Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting...
2017-04-25 (first published: 2017-04-19)
3,320 reads
SQL Doc by RedGate
I recently was on a call where a technical unit indicated they did not receive any form of documentation around...
2017-04-24 (first published: 2017-04-19)
1,327 reads
SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among other things, I had do implement logic in the...
2017-04-19
48 reads
SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
12,680 reads
SQL Security Email Course
Today I am very excited to announce that I have (finally!) launched my email course covering the basics of SQL...
2017-04-19
361 reads
VirtualBox SQL FCI – Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared...
2017-04-19
45 reads
VirtualBox SQL FCI - Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
2,821 reads
PASS BA Marathon – Spring Edition Q&A
The PASS BA Marathon Spring Edition was quite a success. A lot of people tuned in (over 400), the webinar...
2017-04-19
756 reads
SQL Server 2016 enhancements – Truncate Table and Table Partitioning
The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate...
2017-04-24 (first published: 2017-04-19)
2,362 reads
When should I add an index?
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...
2017-04-21 (first published: 2017-04-19)
2,954 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
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....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers