Soaking in SQLServerPedia

One of the bloggers I follow is Brent Ozar. I tell you I’m a fan. I like the way he writes his stuff.

Anyway, he blogged about The Problem With SQL Server Training Today, and The Answer to SQL Server Training Problems a week or so ago. And this is the answer – SQLServerPedia  – SQL Server Knowledge and Advice Straight from the Experts.

So in between giving out candies to cute little Indiana Joneses, pirates of the Caribbean, vampires and dead cheerleaders, I’ve been soaking in SQLServerPedia (geeky ‘no?). So far, so good. I’ll be a frequent flyer.

 

PS – and if you’re a DBA, you’ll find great laughs in this post : Somebody Created a Halloween Monster #SQLputdowns

Drop and Re-Add Server Registration When Renaming Computer

Problem:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘SQLVMSQL02’. (Replication.Utilities)

Scenario:

1. We configured database mirroring on 2 SQL Server instances.

2. We changed the computer name from SQLVM to SQL2K5.

3. We tried launching the Database Mirroring monitor, but we got the following error:

SQL Server replication requires the actual server name to make a connection
to the server. Connections through a server alias, IP address, or any other
alternate name are not supported. Specify the actual server name, 'SQLVMSQL02'.
(Replication.Utilities)

If you just look at the error, it sounds a bit misleading because we don’t have replication configured in either of the servers.

Continue reading

SQL Server-Related Cheat Sheets That Can Save You Time

I previously posted about a SQL Server CheatSheet from DotNet4All that I thought was useful and comprehensive. If you already know what you need to do, but just forgot the syntax because you haven’t done it in eons, then  a well organized, concise, complete cheat sheet can save the day.

Continue reading

What to do if you accidentally lock yourself out of SQL Server (SINGLE_USER mode)?

Problem:

Msg 5064, Level 16, State 1, Line 1
Changes to the state or options of database <your db name> cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.”

Continue reading

Clustering SQL Server 2005 Videos … and some hacking

Brian Knight has posted a lot of good videos on JumpStartTV, including the following clustering videos:

Continue reading

White Papers: Backup/Recovery, Performance Tuning

Here are some older Quest White Papers (specific to SQL Server 2000, but general concepts and practices still applicable to SQL Server 2005/2008):

 

Backup/Recovery

SQL Server Backup Recovery & Troubleshooting. Part 1
SQL Server Backup Recovery & Troubleshooting. Part 2

 

Performance Tuning

Part 1: Analyzing and Optimizing T-SQL Query Performance on MS SQL Server using SET and DBCC
Part 2: Index Tuning Strategies
Part 3: Query Optimization Strategies
Part 4. Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using SHOWPLAN Output and Analysis