How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.
2007-12-26
1,522 reads
To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.
2007-12-26
3,745 reads
Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that.
2007-12-25 (first published: 2006-12-28)
20,917 reads
2007-12-25
38 reads
2007-12-25
2,514 reads
Study encryption and hashing algorithm options for data security in SQL Server 2005 and use symmetric/asymmetric keys to encrypt and decrypt SQL Server data.
2007-12-25
3,463 reads
In the spirit of celebration at the end of the year, a break from the usual routine. Happy holidays to all and hopefully no one is working this weekend.
2007-12-24 (first published: 2004-12-24)
4,405 reads
2007-12-24
1,592 reads
How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.
2007-12-24 (first published: 2007-01-08)
21,734 reads
Steve Jones shares a few tricks that might make it easier and quicker for you to work with SQL Server 2005 Management Studio
2007-12-24
7,939 reads
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers