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

Archives: March 2017

Speaking on Re-Indexing – The quest of ultimate automation – SQLSaturday (Orange County)

Apr 1st 2.45 pm, I will be presenting “Re-Indexing – The quest of ultimate automation” @ sqlsaturday, Orange County, if you are in the area I hope to see you…

Golden West College, 15744 Goldenwest St,
Orange County, California, 92647, USA

PASS sqlsaturday’s are free 1-day training events for… Read more

0 comments, 126 reads

Posted in SQLFeatures on 31 March 2017

SSIS Web Service Task: misleading role of WSDL file

[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just use an existing Web Service task. The latter option is easier, UI based, doesn't take too much time to set up and Input/Output parameters are very intuitive to navigate.

There is one gotcha with…

Read more

0 comments, 145 reads

Posted in Data Adventures on 31 March 2017

Thoughts on PASS Summit Speaker Selection Changes

Recently the PASS Blog released some changes to the speaker selection process that have generated some commentary and thoughts from various people. I read Joey D’Antoni’s thoughts, Andy Leonard’s thoughts as well as various tweets and comments. I talked with a few people, and wanted to put out a… Read more

10 comments, 226 reads

Posted in The Voice of the DBA on 31 March 2017

SSIS Catalog Logging Tables

Making the most of the SSIS catalog requires an understanding of how to access the information stored in the logging tables. Although there are built-in reports to show this information, there are limitations in their use. Fortunately, the logging tables in the SSIS catalog database are (mostly) straightforward and easy… Read more

1 comments, 149 reads

Posted in Tim Mitchell on 31 March 2017

Notes from the March 2017 MagicPASS Meeting

I was a last minute volunteer to speak at the March meeting and used it as a chance to talk about Devops for the DBA as a practice run for my session at the upcoming Orlando Code Camp. One of the nice things about having been to the group as… Read more

0 comments, 103 reads

Posted in SQLAndy on 31 March 2017

Friday Reading 2017-03-31

SQLBits is only a week away! But before that I’ve been reading…

Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution
Rob goes through how to use Ola Hallengren’s scripts to back up databases in SQL Server on Linux (now that the agent is supported)

Setting the default… Read more

0 comments, 112 reads

Posted in The DBA Who Came In From The Cold on 31 March 2017

Looking Back at the SQL Clone Launch(es)

Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along with Grant Fritchey, to help broadcast a few sessions about the product. I’ve been excited to see SQL Clone for a few years now, ever since I saw a POC… Read more

0 comments, 397 reads

Posted in The Voice of the DBA on 30 March 2017

Applying SQL Service Pack on Encrypted Drives

I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account and sysadmins have the ability to encrypt/decrypt files. The local system account does not, nor does the local admins group. Good for security, but it causes some pain when… Read more

0 comments, 140 reads

Posted in SQLAndy on 30 March 2017

Your physical memory configuration can slow down your servers

Watch your memory configuration! You can’t just throw RAM in a physical server and expect it to work right. Depending on your DIMM configuration, you might have accidentally slowed down your memory speed, which will surely slow down your application servers. This speed decrease is virtually undetectable from the OS.… Read more

1 comments, 145 reads

Posted in Technobabble by Klee from @kleegeek on 30 March 2017

Power BI Custom Visuals Class (Module 44 – Attribute Slicer)

In this module you will learn how to use the Attribute Slicer Power BI Custom Visual.  Using the Attribute Slicer you have the ability to filter your entire report while also being able to visibly see a measure value associated with each attribute.

Module 44 – Attribute Slicer


  • Power…

Read more

0 comments, 233 reads

Posted in Devin Knight on 29 March 2017

Trouble Shooting Little Jewel

I didn’t know about this little gem, so I shared it with my team and they didn’t know about it either. Then I tweeted about it and found others who didn’t know about it, so I decided I should write a short little blog.

Denny Cherry (B|T Read more

1 comments, 162 reads

Posted in SQLEspresso on 29 March 2017

Watch Your DataTypes in Aggregates–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I’ve got a database of NBA statistics with data like this for players. I downloaded a CSV and loaded it into SQL Server.

I decided to play… Read more

0 comments, 300 reads

Posted in The Voice of the DBA on 29 March 2017

Microsoft database migration tools

There are various Microsoft tools that you can use to help you migrate your database:

Data Migration Assistant (DMA) – enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server and Azure SQL Database.  It… Read more

3 comments, 30 reads

Posted in James Serra's Blog on 29 March 2017

Random Blogging Challenge Results

The winner is: Everyone.

Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone blog based on an image of the great Tom Baker:

In no particular order we have:

Persist and Aggregate Index Stats Across Server Restarts by Eric Cobb
Nice use… Read more

1 comments, 114 reads

Posted in The Scary DBA on 29 March 2017

Increasing and decreasing the performance level of your Azure SQL Database

One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability to increase and decrease your capacity as needed. This is easy enough with Azure SQL Databases.

  1. In the Overview blade you can see current pricing tier.
  2. Under settings, just below…

Read more

0 comments, 119 reads

Posted in SQLStudies on 29 March 2017

What Is A Day?

When designing a data warehouse or reporting architecture, the smallest questions can pose some of the biggest challenges. Identifying what may appear to be an obvious term or metric can slow down or even derail a business intelligence initiative. Early in my career as a BI professional, I was faced… Read more

1 comments, 129 reads

Posted in Tim Mitchell on 29 March 2017

SSMS – Not a Valid Value for Property Width

I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe – and it wouldn’t load, error “is not a valid value for property ‘Width'”. I finally tracked it down to this registry key. Editing or deleting fixed the problem. Read more

0 comments, 115 reads

Posted in SQLAndy on 29 March 2017

Getting SQL Server File Sizes and Space Used with dbatools

I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet and wondered how much I could do with the dbatools module

The dbatools module (for those that don’t know) is a PowerShell module written by amazing folks in the community… Read more

0 comments, 131 reads

Posted in SQL DBA With A Beard on 29 March 2017

Using SQL Client Aliases

SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA setup process. If you haven’t seen it, it’s here.

One of the problems that we ran into when moving to using containers was how to get the applications to… Read more

1 comments, 157 reads

Posted in The DBA Who Came In From The Cold on 29 March 2017

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Orange County)

on Apr 1st 1.30 pm, I will be presenting “consolidated essential performance health check using powershell” @ sqlsaturday, Orange County, if you are in the area I hope to see you…

Golden West College, 15744 Goldenwest St,
Orange County, California, 92647, USA

sqlsaturday-Orange County 2016

event schedule

session details Read more

0 comments, 111 reads

Posted in SQLFeatures on 29 March 2017

Older posts