Creating logins and users in Azure Database
Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
2019-04-11
18 reads
Creating logins and users in Azure Database
Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
2019-04-11
40,882 reads
Can SQL Ids be used on an instance with Windows Authentication only?
tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not ... Continue reading
2019-04-24 (first published: 2019-04-11)
457 reads
Storytelling Without Data?
There are many great resources out there for data visualization. Some of my favorite data viz people are Storytelling With Data (b|t), Alberto Cairo (b|t), and Andy Kirk (b|t)....
2019-04-23 (first published: 2019-04-11)
509 reads
Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
158 reads
Testing as another user–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is one of those things I do...
2019-04-24 (first published: 2019-04-10)
356 reads
Using a home-grown Azure Blob Storage solution for SQL Server backups
I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...
2019-04-10
33 reads
SSIS and Data Quality Webcast
On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for...
2019-04-10
30 reads
Database Recovery Monitoring with XE
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
2019-04-10
16 reads
Database Recovery Monitoring with XE
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
2019-04-22 (first published: 2019-04-10)
632 reads
Blogs
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...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Forums
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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