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
970 reads
Blog Posts
Last Weeks Top “Reading” Links #110
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-24
895 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,097 reads
SOA and message based integration - the challenge of bulk data changes
I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been...
2014-11-24 (first published: 2014-11-19)
6,377 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
883 reads
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 from sa. 3. Do not drop the TempDB...
2014-11-24
19 reads
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,484 reads
Using T-SQL to populate a Central Management Server
We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the...
2014-11-24 (first published: 2014-11-17)
7,000 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
406 reads
Friday Followup For November 21, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-11-21
454 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers