How Can I Quickly Script Out Replication?
I recently finished taking down a bunch of servers that I was using to scale out my environment by forcing...
2010-07-16
519 reads
Free SQL Server Training for the Week of July 19, 2010
This will start a new trend on my blog. Every Friday morning I'll have a blog post covering the free SQL...
2010-07-15
749 reads
Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
690 reads
“One of the Pack to Top Dog”
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
580 reads
Scanning Without Wires - Epson Workforce 610
We are trying to buy another property here at the ranch. My wife had to leave town in the middle...
2010-07-15
748 reads
MDX Puzzle #3 Solution
Download Script
Sorry that it’s taken me so long to write this post, but I have been a little busy with...
2010-07-15
699 reads
Pruning the Blog List
I went through the exercise months ago where I tried to re-organize my blog reading to be more efficient at...
2010-07-15
840 reads
Making Choices Narrows Your Remaining Options
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
514 reads
SQL Saturday Advice - Build a Foundation
I think this is a good idea, and I’ll give you some reasons, but every SQL Saturday ought to consider...
2010-07-15
977 reads
Defensive Db Programming Chapter 02
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is...
2010-07-15
1,826 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