Video Test
One of the things I've been wanting for awhile is the ability to embed videos here on the blogs. It's...
2010-07-14
447 reads
Core DBA Skill – Backing up the tail log
I’ve never had to do this in production, and I’ve only practiced it a few times, but I think this...
2010-07-14
2,269 reads
Red Gate SQL Source Control
You just have to love Red Gate tools. They find the small area that they want to cover and then...
2010-07-14
1,878 reads
T-SQL Tuesday #008: Gettin’ Schooled
Here we go again with another round of T-SQL Tuesday fun this time brought to you by recent SQL Certified...
2010-07-13
637 reads
Test Cluster Delivered & Ready to Assemble
I finally received all the components of my SQL Server test cluster (pictured left), which includes:
–One PowerVault MD3000 DAS with...
2010-07-13
563 reads
Learning that Presenting is Worth Doing (T-SQL Tuesday #008: Gettin’ Schooled)
This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach?...
2010-07-13
1,350 reads
Advanced Troubleshooting Week at SQL University, Lesson 1
Advanced Troubleshooting Week at SQL University, Lesson 1
Welcome to Advanced Troubleshooting Week at SQL University. Once again, I’m your guest...
2010-07-13
5,438 reads
Implicit Data Conversion: The "HHidden" Bottleneck
Have you ever written a query that just seems to take forever? You have looked it over time and time...
2010-07-13
980 reads
Gettin’ Skewled
Observe and Report
This month we get to frolic in our memories of school days. Thanks to HeadMaster Robert Davis (Blog...
2010-07-13
802 reads
Writing Better Queries in Steel City
T-SQL is a very forgiving language. As long as you have the basic syntax of the statement correct, SQL Server...
2010-07-13
428 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers