MAXDOP, Parallelism and the Cloud
Parallelism and MAXDOP The pros and cons of parallelism have always been with us in SQL Server and I blogged about this a couple of years ago. This is...
2019-04-18 (first published: 2019-04-03)
2,236 reads
Matthew McGiffen DBA
Finding “Orphaned” database files – script
When you drop a database from a SQL Server instance the underlying files are usually removed. This doesn’t happen however if you set the database to be offline first,...
2019-03-27
53 reads
Checking Progress of the Creation of your Azure Resources
When I’ve created resources in Azure it’s usually taken from a few minutes and up to quarter of an hour...
2019-02-26
840 reads
Using the Sequence Object to Generate Reference Numbers
The SEQUENCE object was added to T-SQL in SQL Server 2012. It’s reasonably well known to DBAs, but less so...
2019-03-12 (first published: 2019-02-20)
4,258 reads
There’s got to be a better way
For T-SQL Tuesday #111, Andy Leonard asks “What is your why? Why do you do what you do?”
Like Andy, I...
2019-02-12
666 reads
“SSPI handshake failed” \ “The login is from an untrusted domain” errors
I’ve recently encountered an issue that was difficult to resolve and I didn’t find the particular cause that was troubling...
2019-02-28 (first published: 2019-02-12)
2,960 reads
Some differences with SQL Server when running on AWS RDS
If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then...
2018-12-12
878 reads
Extended Events Made Easy – Sorting, Grouping and Aggregation
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace...
2018-10-29 (first published: 2018-10-16)
2,128 reads
T-SQL Tuesday 107 – Viral Demo
For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by...
2018-10-19 (first published: 2018-10-09)
1,873 reads
Checking for Membership of a Specific Active Directory Group
As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...
2018-10-15 (first published: 2018-10-02)
2,323 reads
Blogs
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers