The Real World: Implementing Data Compression in SQL Server 2008 R2
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
2018-10-19 (first published: 2016-01-18)
4,285 reads
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
2018-10-19 (first published: 2016-01-18)
4,285 reads
A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.
2017-07-18
4,823 reads
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
966 reads
The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.
2017-03-16
822 reads
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,701 reads
EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.
2016-11-30
2,308 reads
The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.
2015-02-17
6,419 reads
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,018 reads
This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.
2012-04-20
6,507 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
We're finally upgrading from SQL Server 2008 R2 Enterprise to SQL Server 2017 Standard...
I am working on a data warehouse project for a bakery. For the most...
I am working on a data warehouse project for a bakery. For the most...
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers