The Politics of SQL Server Performance
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,522 reads
SQL Saturday #48 - Columbia, SC - Registration and Call for Speakers is On-line
The website is up for SQL Saturday #48 - Columbia. We're holding it on October 2, 2010, in West Columbia, SC,...
2010-06-30
1,445 reads
PASS, Don’t Waste My Time
Update: Apparently I can't write, or get a point across from the
comments and a few emails, so I have...
2010-06-30
2,518 reads
DB2 – Create a Database
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
4,992 reads
Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to...
2010-06-30
2,129 reads
MS Access Annoyance: Doesn’t Link Synonyms
I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data...
2010-06-30
3,150 reads
Does Your Company Have a SQL Server DR Plan?
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,556 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,139 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,039 reads
Partition Alignment and Late Night Infomericals
Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and...
2010-06-29
1,514 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