Inserted and Deleted are One Table?
Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...
2012-10-17
2,445 reads
Querying database usage
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,555 reads
Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis
I haven’t seen this many fake ID’s since I was in college.
Back on April 26, Grant Fritchey (of execution...
2012-10-24 (first published: 2012-10-16)
5,133 reads
SQL Server 2012 CU4 Is Now Available !
The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update...
2012-10-16
759 reads
SQL Server Quickie #4 – IAM Pages
Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I’m talking about IAM Pages in...
2012-10-16
643 reads
SQL Server Quickie #4 – IAM Pages
Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I'm talking
about IAM Pages in SQL...
2012-10-16
1,212 reads
Thirteen Years Old
A very cool shot of our company at 13.
I first heard of Red Gate back in 2001 and they were...
2012-10-16
1,051 reads
MDS: Copying models and data to another server
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...
2012-10-23 (first published: 2012-10-16)
6,048 reads
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,771 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,480 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers