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,851 reads
StrateSQL
Lost in Translation – Deprecated System Tables – sysservers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
2,435 reads
Lost in Translation – Deprecated System Tables – sysreferences
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-28
1,330 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
734 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
807 reads
Last Weeks Top 10 “Reading” Links #8
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
629 reads
Reblog: November 16 to November 22
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-23
644 reads
Lost in Translation – Deprecated System Tables – sysobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,555 reads
Lost in Translation – Deprecated System Tables – sysperfinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,328 reads
Lost in Translation – Deprecated System Tables – syspermissions
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,102 reads
Blogs
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
repeat results without loops, MSSQL2005 Express
hello everybody, new here and this is my first question I have a table...
how to write this query?
Hi everyone I am a bit stuck on how to write this query. Below...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers