Performance on readable replicas in Availability Groups
I apologize in advance if I mess up the terminology.
I’ve worked with a moderate read workload on a readable replica...
2019-02-08
778 reads
SQL Server Database Experimentation Assistant - How to Run a Capture
DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...
2019-02-08
37 reads
Migrating From Hipchat To Slack
Last Minute Migration?
If you are about to perform a last minute migration here's a couple tips as you jump ship from Hipchat and move to Slack. Hipchat is sunsetting...
2019-02-07
14 reads
How To Use Power BI Embedded For Your Customers
Recently I had a need to build a Power BI report for a client. This client has a multi-tenant database and their own custom web app. They want to...
2019-02-07
23 reads
How To Use Power BI Embedded For Your Customers
Recently I had a need to build a Power BI report for a client. This client has a multi-tenant database...
2019-02-07
863 reads
ALTER TABLE Fails on Replicated Tables With Isolation Level SERIALIZABLE or READ UNCOMMITTED on SQL2012 and Earlier
It’s 4am in the morning and my phone starts ringing.
A blury eyed, me picks it up to hear the voice...
2019-02-07
340 reads
Dynamic Data Masking in the execution plan
I think Dynamic Data Masking is pretty cool. The idea is basically to provide a mask for certain users when...
2019-02-07
822 reads
How Many Data Gateways Does My Azure BI Architecture Need?
It’s not always obvious when you need a data gateway in Azure, and not all gateways are labeled as such....
2019-02-07
882 reads
SQL Server Database Experimentation Assistant - How to Run a Capture
DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...
2019-02-07
12 reads
Versions of Stored Procedures
I never knew this, but stored procedures have versions.
I was browsing the CREATE PROCEDURE doc page, and stumbled upon this...
2019-02-06
1,055 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers