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,297 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,297 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,867 reads
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
969 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
830 reads
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,707 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,334 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,424 reads
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,020 reads
This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.
2012-04-20
6,510 reads
By Steve Jones
There is a nice article at Harness.io on their use of feature flags and...
By James Serra
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
Hello, I have long-term task, which came one year ago, and just now I...
Comments posted to this topic are about the item LOGON Trigger Count
Comments posted to this topic are about the item Invisible Downtime
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers