ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCP Santa Telpon/WA:085188120691 Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta...
BCA KCP Wahid Hasyim Telpon/WA:087768193341.Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota...
BCA KCP Raden Saleh Telpon/WA:087768193341.Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers