When deploying business critical applications in the cloud you want to make sure they are highly available. The good news is that if you plan properly, you can achieve...
2020-08-05 (first published: 2020-07-24)
131 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-05
5 reads
Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little beefier. There were ten virtual machines on the SuperMicro server, nine which were allocated 127...
2020-08-05
6 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In recent versions of SSMS, there’s been an...
2020-08-05
7 reads
When moving data in an extraction, transformation, and loading (ETL) process, the most efficient design pattern is to touch only the data you must, copying just the data that...
2020-08-05 (first published: 2020-07-23)
454 reads
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-05
48 reads
Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...
2020-08-04
9 reads
SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...
2020-08-04 (first published: 2020-07-22)
294 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-04
2 reads
This article was first published on: 2020-03-14.
This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.
We'll cover examples...
2020-08-04 (first published: 2020-07-23)
311 reads
Most of DBA are coming from On-premise Database Servers they know very well How...
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...
Hi, I'm using SQL Server 2017, I need to give developers only to view...
Comments posted to this topic are about the item Offline Filegroups
Ask SSC