Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
16 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
19 reads
Leveling Up Your TSQL
I thought I’d use this post to round up some of my other posts into a list of often overlooked/unknown...
2019-01-22
277 reads
One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this week it was just my oldest, going on 15....
2019-01-21
16 reads
One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...
2019-01-21
216 reads
Call for Speakers – SQLSaturday Jacksonville 2019
SQLSaturday Jacksonville 2019 is scheduled for May 4, 2019. The call for speakers closes on March 5.
2019-01-21
191 reads
Call for Speakers – SQLSaturday Tampa 2019
SQLSaturday Tampa just went live and the call for speakers is open through February 23, 2019. I’ll be attending, hope to see you there!
2019-01-21
16 reads
Call for Speakers – SQLSaturday Tampa 2019
SQLSaturday Tampa just went live and the call for speakers is open through February 23, 2019. I’ll be attending, hope...
2019-01-21
188 reads
MSSQLTips.com Rookie of the year 2018
You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...
2019-01-21
19 reads
CLR Strict Security in SQL 2017
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
31 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