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,239 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
841 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,276 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,961 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
885 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
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers