If you want to use ASR to replicate SQL Server 2008 R2 standalone or clustered instances, you will need to update the SQL Writer to 2012 or later. You...
2019-06-18
68 reads
I just noticed today that there is a new blade in the Azure portal when creating a new SQL Server virtual machine. I’ve been looking for an announcement regarding...
2019-06-11 (first published: 2019-05-24)
403 reads
Google first reported an “Issue” on Jun 2, 2019 at 12:25 PDT. As is now common in any type of disaster, reports of this outage first appeared on social...
2019-06-03
18 reads
If you are deploying SQL Server in Azure, or any Cloud platform for that matter, instead of just provisioning storage like you did for your on-premises deployments for many...
2019-05-14 (first published: 2019-05-02)
462 reads
If you are like me and were unable to get away from the office to attend Microsoft Build 2019 you will be glad to know that Microsoft has published...
2019-05-10
44 reads
Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. However, if you move those SQL...
2019-05-02 (first published: 2019-04-19)
566 reads
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
654 reads
If you have been following my blog, you probably know that I write a lot of step-by-step guides for building...
2019-02-15
274 reads
Introduction
If you are reading this article you probably are still using SQL Server 2008/2008 R2 and want to take advantage...
2019-02-04
587 reads
If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9,...
2019-01-09
41 reads
At best these phantom backups cause undue headache in troubleshooting. At worst, they make...
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
I’m a creature of habit. I have my routine when I get to my...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Hi, i would like to generate csv file with datetime through sql job with...
--test data declare @T table(a int null, b int null) insert @T(a, b) select...
Ask SSC