Steps to Recover Deleted Records from SQL Server Database Tables
In case you forgot to take backup of current database in SQL Server and deleted few records from SQL Server...
2019-01-23
1,434 reads
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-01-23
1,670 reads
Why You Shouldn't Use SELECT * In Production Systems (EVER!)
OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...
2019-02-11 (first published: 2019-01-23)
6,875 reads
17 months of podcasting – recap
Before I publish the next episode of “Ask SQL Family” podcast, I would like to stop and look back for...
2019-01-23
164 reads
SQL Power Doc to Discover, Diagnose and Document SQL Server
This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose, installation, processing and output. Automation seems to be an increasing...
2019-01-22
116 reads
SQL Power Doc to Discover, Diagnose and Document SQL Server
This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose,...
2019-01-22
344 reads
Critiquing Grant Fritchey: Circa 2008
For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of...
2019-01-22
163 reads
Starting a Proof of Concept with SQL Change Automation
One of the ways that you can more easily perform database development tasks is with SQL Change Automation (SCA). This...
2019-02-01 (first published: 2019-01-22)
2,053 reads
Memory Grants part 5: Query hints
Proceed with caution, if you’re thinking of using query hints. This post will specifically cover min_grant_percent and max_grant_percent.
My opinion on...
2019-02-11 (first published: 2019-01-22)
10,383 reads
Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,218 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