Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2020-09-18 (first published: 2018-04-12)
13,942 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.
2020-08-28 (first published: 2018-12-11)
2,162 reads
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
2020-06-11
3,459 reads
There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.
2020-05-21
5,396 reads
An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.
2019-09-27 (first published: 2017-10-10)
4,589 reads
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,927 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,110 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
3,360 reads
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
811 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
728 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Ic markets là sàn th? nào dây ? gi?y phép và các th? t?c...
- Explore beautiful cruise destinations like Goa, Lakshadweep, Colombo, Maldives & many more by...
I work on sql server 2012 i need to get featurekey and feature value...
Ask SSC