SQL Server Thumbnail Metrics – OS Memory
I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to...
2012-12-07 (first published: 2012-11-29)
3,000 reads
Reasons not to upgrade to SQL Server 2012
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right...
2012-11-29
2,848 reads
Lost in Translation – Deprecated System Tables – sysremotelogins
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
1,856 reads
Interview questions for SQL Server Performance Tuning Specialists
If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.
I have...
2012-11-29
10,160 reads
HDInsight: Trying again
And I thought this would be so easy.
Latest attempt. I just did an uninstall of HDInsight. Then I found all...
2012-11-29
1,933 reads
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the...
2012-11-29
1,548 reads
Chicago: The Travels of a SQL Server Consultant
As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server...
2012-11-29
2,128 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,474 reads
NY SQL Server User Group Meeting - Bill Pearson
Thursday, November 29, 2012, brings us the November
meeting of the NY SQL
Server User Group, with BI expert, SQL MVP and...
2012-11-28
1,827 reads
Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
738 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