fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,240 reads
Blog Posts
Lost in Translation – Deprecated System Tables – sysforeignkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-19 (first published: 2012-10-16)
1,767 reads
MDX #19 – There is more to do to concatenate row values into column
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,452 reads
Reblog: October 12 to October 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-19
519 reads
SQL Server 2008 Diagnostic Information Queries (Oct 2012)
Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-19
1,704 reads
This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
932 reads
this is what I do when I install SQL. How about you?
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
875 reads
Awarded – Microsoft Community Contributor Award 2012
Today, I’ve received an email from Microsoft stating that I’ve been awarded Microsoft Community Contributor. This is the first time...
2012-10-18
1,684 reads
DBA Study Guide
http://www.flickr.com/photos/caledonia09/4999119065/
Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds. For the most part we are looking...
2012-10-18
2,428 reads
Important Alerts for SQL Server
One of the things that I think is extremely important for DBAs and really anyone that has to administer a...
2012-10-18
2,423 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers