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
1,229 reads
In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.
2018-12-11
606 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)
3,449 reads
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2018-04-12
3,295 reads
An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.
2017-10-10
1,179 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
1,095 reads
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
578 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
594 reads
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,099 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
1,225 reads
By Kamil
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...
In this post we saw how to create some graph tables with data. In...
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
Comments posted to this topic are about the item Is Data the Future of...
Hi All, Need help here. Why is sql server is not releasing memory to...
Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....
Ask SSC