Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.
2011-03-16
4,312 reads
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-16
2,581 reads
2011-03-16
1,665 reads
How can I change the collation of SQL Server 2008? Learn how in this short tutorial.
2011-03-15
6,964 reads
Once again SQLServerCentral is sponsoring a track at SQL Connections in Orlando this March. Read about the event and our speakers and join us for SQL Server training in Florida.
2011-03-15 (first published: 2011-01-19)
1,697 reads
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-15
1,831 reads
We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server?
2011-03-15
6,215 reads
There are times when you need to use different network ports to communicate between two servers running database mirroring. Learn how to change the default ports.
2011-03-14
10,602 reads
SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.
2011-03-14
6,011 reads
A presentation by Steve Jones that looks at a number of common mistakes that people make with SQL Server on a regular basis.
2011-03-11
492 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers