Miscellaneous Notes On System Architecture and Design
When I first joined the programming team at my previous job in an aerospace company, the first observation I made...
2019-02-01 (first published: 2019-01-18)
2,120 reads
Memory Grants part 3: How much memory can one query get?
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,946 reads
Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
301 reads
Data Warehousing Tip #5 – Use surrogate keys
My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables.
Surrogate keys are keys...
2019-02-07 (first published: 2019-01-18)
3,081 reads
Error : DBCC could not obtain a lock on this object because the lock request timeout period was exceeded
DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period...
2019-01-18
1,353 reads
Cool Stuff in Snowflake – Part 3: SPLIT and FLATTEN
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-01-17
91 reads
3 Key Points from My Upcoming Talk, “DevOps: What, Who, Why, and How?”
Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders. The...
2019-01-17
23 reads
When the query plan hash is deceptive
When you’re querying the plan cache, you need to know the four primary objects: the query hash, query plan hash,...
2019-01-17
773 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance - unless they fail. What if the job failed because something was changed in...
2019-01-17
222 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...
2019-01-17
1,012 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers