Script: Backup All your Databases
We all know the importance of taking regular backups of our SQL Server databases. This is a useful little script...
2010-03-18
1,720 reads
Blog Posts
Stay Interview Instead of Exit Interview
I had not heard of the stay interview until a friend sent over a link. The idea is that rather...
2010-03-18
1,074 reads
The Coming Upgrade Tidal Wave
Microsoft is poised to release new versions of several different products and technologies that have the potential to have a...
2010-03-18
722 reads
This is Dumb - eBooks
Amazon v Apple, both pressuring publishers on ebook concessions. It’s big business, and it could easily be good or bad...
2010-03-18
945 reads
Undocumented Virtual Column: %%lockres%
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,671 reads
Want to Learn More About How to Master Microsoft Technologies?
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,435 reads
Automating Imports from Access
Access is actually pretty good at importing files, and doesn’t on the surface work much different that import/export from Management...
2010-03-17
874 reads
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-17
815 reads
SQL Saturday – A Few Lessons for Future Events
I’ve been to a few SQL Saturdays, and while most have run smoothly, I have a few comments on a...
2010-03-17
876 reads
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also...
2010-03-17
6,084 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers