SQL and Skiing – SQL Saturday #183
This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a...
2013-01-30
1,498 reads
Performance Impact from Page Splits
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,968 reads
Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,907 reads
SSIS 6 Million Rows in 30 Seconds using standard laptop
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,778 reads
SQL Server – Attach Database with MDF file only
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,753 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 5: The Neural Network Algorithm
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,988 reads
Are You Signed Up for 24 Hours of PASS–Business Analytics?
If you have not signed up for the 24 Hours of PASS-Business Analytics you should be. This is a great...
2013-01-29
1,374 reads
Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,766 reads
Determining Filegroup for a Table
Have you ever needed to figure out which filegroup your tables are located within? If you had to do this,...
2013-02-06 (first published: 2013-01-29)
4,786 reads
Cultural Anthropology and Business Intelligence–A Tribute to Dr. Thomas C. Correll
A tribute is an expression of gratitude or praise. Last year I started a series about individuals who have impacted...
2013-01-29
1,638 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