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,490 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
739 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
971 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,098 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,801 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
889 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
416 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
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers