SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Thoughts on Query Performance with TDE enabled

Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance  overhead of 2-4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want to make sure my data is encrypted at rest.

However, you may have heard other sources saying that… Read more

0 comments, 40 reads

Posted in Matthew McGiffen DBA on 23 May 2018

Jobs in PoSh to Create a Load

I saw this from Argenis Fernandez, and thought it was wonderful.

1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U sa -P ‘iLovePoSh’ -i /home/username/test.sql } }

Create 128 threads, each running a background job in PowerShell to connect to an instance and… Read more

0 comments, 64 reads

Posted in The Voice of the DBA on 23 May 2018

Virtual Log Files: 200 or 1000?

Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During the follow-up meeting, the senior DBA and I had a discussion about Virtual Log Files (VLFs), disagreeing on the maximum number of Virtual Log Files a transaction log should have.… Read more

1 comments, 62 reads

Posted in Born SQL with Randolph West on 23 May 2018

The public role

A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. Connection only. So how come there are some things that everyone can do once they are connected to a database? Well, it’s the public role. Everyone is a member and… Read more

0 comments, 48 reads

Posted in SQLStudies on 23 May 2018

dbachecks – Save the results to a database for historical reporting

I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got asked was will you write a command to put the results of the checks into a database for historical reporting.

The answer is no and here is the reasoning. The… Read more

0 comments, 68 reads

Posted in SQL DBA With A Beard on 23 May 2018

Deploying Azure Container Instances

In a previous post I went through how to Push an image to the Azure Container Registry

Now let’s look at using that image to create an Azure Container Image instance.

Azure Container Instances (ACI) are Microsoft’s serverless container technology. They allow us to spin up a container without having… Read more

0 comments, 65 reads

Posted in The DBA Who Came In From The Cold on 23 May 2018

How to pass data between procedures using temp tables.

In this post I will show how in some cases we can split a long procedure to a small and manageable parts using a simple technique of passing data in temp tables

Read more

0 comments, 96 reads

Posted in SQL Design Patterns on 23 May 2018

Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler


This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux and Windows machines.

Here’s an outline of what this article is all about:

  • Introduction
  • Technical specifications
  • How to load SQL Server modules on Windows machine
  • Security – Credential Management

Read more

0 comments, 78 reads

Posted in PowerSQL By Prashanth Jayaram on 22 May 2018

SQL Saturday – Dallas – May 2018

I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to attend. As I noted in the meeting you can find details related to Power BI Data Security in the following posts on my site.

Power BI Is Finally in the… Read more

0 comments, 61 reads

Posted in DataOnWheels on 22 May 2018

SQL Saturday Iowa City Precon June 22

I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June 22, ahead of the SQL Saturday in Iowa City, Iowa. This all-day training class, entitled “Level Up Your Cloud Infrastructure Skills“, is designed to help you,… Read more

0 comments, 82 reads

Posted in Technobabble by Klee from @kleegeek on 22 May 2018

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2.

This went as many patches have gone for me, which is fairly boring… Read more

2 comments, 110 reads

Posted in The Voice of the DBA on 22 May 2018

Azure SQL Database / SQL Server – Paused Index Rebuild

I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when I executed this code:

ON [dbo].[Audit] ([UserId])
INCLUDE ([DefID],[ShopID])

Msg 10637, Level 16, State 3, Line 7

Cannot perform this operation on ‘object’ with ID 1093578934… Read more

1 comments, 78 reads

Posted in All About SQL on 22 May 2018

Azure PowerShell – List Data Center Locations

Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do training with a customer. Part of that meant creating 6 data science VMs. So we updated the software on a VM… Read more

0 comments, 78 reads

Posted in Bradley Schacht on 22 May 2018

Power BI Custom Visuals Class (Module 104 – User List by CloudScope)

In this module you will learn how to use the User List by CloudScope. The User List by CloudScope is designed for showing a list of data presented in the format of a Twitter profile.

Module 104 – User List by CloudScope


Read more

0 comments, 100 reads

Posted in Devin Knight on 22 May 2018

Converting JSON to SQL Server CREATE TABLE Statements

Watch this week’s episode on YouTube.

Tedious, repetitive tasks are the bane of any lazy programmer.  I know, because I am one.

One such repetitive task that I find comparable to counting grains of rice is building database layouts from JSON data sources.

While some online services exist that will… Read more

0 comments, 99 reads

Posted in Bert Wagner on 22 May 2018

Day 22 Other Storage Engines

So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL has, there are some other Storage engine which are specific to the business requirement and used only for their special … Continue reading

Read more

0 comments, 62 reads

Posted in Vinay Thakur on 21 May 2018

Monday morning comic 2018-05-21

I decided to poke fun at ORM tools again this week. Hope you enjoy.

Read more

0 comments, 90 reads

Posted in Confessions of a Microsoft Addict on 21 May 2018

Linux LFCE Learning Path Available at Pluralsight

I’m proud to announce the completion of my first Pluralsight Learning Path. This learning path is built to advance your Linux knowledge to the system administrator or system engineer level. In this series of courses you’ll learn the theory behind how things work and also practice demonstrations and tips to… Read more

0 comments, 88 reads

Posted in Anthony Nocentino's Blog on 21 May 2018

Day 21 NDB Storage Engine (Cluster)

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading

Read more

0 comments, 81 reads

Posted in Vinay Thakur on 21 May 2018


In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform professionals on the planet. It consists of local groups, virtual groups, multiple online events, SQLSaturday, and, to pay for it all, PASS Summit. However, that’s… Read more

0 comments, 76 reads

Posted in The Scary DBA on 21 May 2018

Older posts