TempDB Configuration Best Practices
1. Do not change collation of TempDB from the SQL Server instance collation.
2. Do not change the TempDB database owner...
2014-11-24
5,492 reads
Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !
The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-11-24
740 reads
Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !
The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support...
2014-11-24
973 reads
Putting sp_ at the beginning of your stored procedure.
Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So...
2014-11-24
1,099 reads
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...
2014-11-28 (first published: 2014-11-24)
6,802 reads
SQLSaturday Speaking & Sharing
Recently, I caught a blog link on LinkedIn, of one SQL
Server professional talking about his experience speaking at a SQLSaturday,...
2014-11-24
890 reads
Clustered Columnstore Indexes – part 44 (“Monitoring with Extended Events”)
Continuation from the previous 43 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the monitoring aspects of the Columnstore Indexes,...
2014-11-23
408 reads
NJSSUG SSIS Performance Tuning
On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning. ...
2014-11-21
417 reads
Reblog: November 14 to November 20
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-11-21
840 reads
SQLSaturday Austin
I was pleased to get the email yesterday confirming that I was selected to speak at SQLSaturday #362 on January...
2014-11-21
609 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