In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.
2019-01-03
2,144 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,374 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
5,127 reads
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
991 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
864 reads
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,751 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,398 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,465 reads
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,034 reads
This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.
2012-04-20
6,539 reads
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
I recently took and passed the DP-700 exam, which is required for the Microsoft...
As a Consultant, I would typically answer with – it depends! Then a typical...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item How to Download and Restore...
Comments posted to this topic are about the item Tracking Table Sizes
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers