Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Remotely Administering the Docker Engine on Windows Server 2016

Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell window when working with Docker on servers. Nothing wrong with this, if you want to know how to do that you can follow my instructions here.

However what if… Read more

0 comments, 24 reads

Posted in The DBA Who Came In From The Cold on 22 February 2017

We Hired!

The response to our most recent job position was incredible, and I’d like to thank all of the folks who responded and submitted their CVs to us for consideration. In the end, we had one open position, and we selected the most qualified candidate for the position.

I’d like to… Read more

0 comments, 72 reads

Posted in Technobabble by Klee from @kleegeek on 21 February 2017

Heading Back to SQL Bits

I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL Server conference, and it’s always a joy to attend. Especially the Friday night party, where everyone seems to have a lot of fun.

I’ll be presenting “Including Your Database in… Read more

0 comments, 84 reads

Posted in The Voice of the DBA on 21 February 2017

Giving a Security Webinar on Thursday

On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server.

Register Here for Free (you can also register for other upcoming MSSQLTips webinars)

Here’s what I’ll be covering:

You’re building a new application using SQL Server as a… Read more

0 comments, 52 reads

Posted in Databases – Infrastructure – Security on 21 February 2017

Power BI Custom Visuals Class (Module 39 – Waffle Chart)

In this module you will learn how to use the Waffle Chart Power BI Custom Visual.  The Waffle Chart visual is most useful for presenting a percentage of data. This chart is a great option to choose over other visuals like Pie Charts, which are not great at showing proportions… Read more

1 comments, 65 reads

Posted in Devin Knight on 21 February 2017

Permanent Employment v Contracting: How the figures stack up

In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over at BrentOzar.com collected and made available back in January 2017. The data is very interesting and in my first post on this topic over the learning Tree blog, we…

Read more

0 comments, 68 reads

Posted in The SQL DBA in the UK on 21 February 2017

Error while loading Excel data into database

Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a simple SSIS package to do that, but unfortunately, it fails with error: –


Microsoft (R) SQL Server Execute Package Utility  Version 11.0.6020.0 for 64-bit  Copyright (C) Microsoft Corporation.… Read more

0 comments, 94 reads

Posted in MSSQLFUN on 21 February 2017

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR stored procedure / function / trigger etc) in VS 2015.

If you google “sign a SQL Server CLR Assembly”, you will most likely find out content published 5+ years ago… Read more

0 comments, 205 reads

Posted in DBA Philosophy on 21 February 2017

Improve performance by replacing temp tables with memory optimized tables - Part 3

Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).

Previously we discussed about using memory optimized tables to replace table variable and global temp table, this time we will replace local temp tables and seek for performance gain. We all use…

Read more

0 comments, 98 reads

Posted in Dennis's SQL Blog on 21 February 2017

SQL Server vNext: sys.dm_db_stats_histogram

Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for SQL Server 2016 Service Pack … Continue reading

Read more

1 comments, 85 reads

Posted in All About SQL on 21 February 2017

External SQL files vs. Stored procedures in SSIS development

[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions in future.

One of my client's existent SSIS solution contains a use of multiple SQL execute tasks which are configured to use external files with a complicated SQL code.…

Read more

0 comments, 141 reads

Posted in Data Adventures on 21 February 2017

Estimated Costs of All Queries

One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not by Microsoft, but by most everyone else). However, what value should you set yours to?

What Do Your Plans Cost?

I have a question right back… Read more

2 comments, 385 reads

Posted in The Scary DBA on 20 February 2017

Penny wise, pound stupid

Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the pound is the British equivalent of the dollar.) Basically, it means paying attention to the small stuff at the expense of the big stuff. My favorite example of this… Read more

0 comments, 70 reads

Posted in SQLStudies on 20 February 2017

Setting up SQL Server to SQL Database (Azure) Replication

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed a selection of tables that I wanted to off-load to Azure.  For this post I will be going through the … Continue reading

Read more

1 comments, 120 reads

Posted in All About SQL on 20 February 2017

AlwaysOn Availability Groups: Step by Step Setup

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases. Secondary databases are not backups. Continue to back up your…

Read more

0 comments, 78 reads

Posted in Ganapathi's MSSQLLover on 20 February 2017

Adding a T-SQL Job Step to a SQL Agent Job with PowerShell

In my last post, I explained how to alter an existing job step across many servers. I also had cause to add a T-SQL Job step to a large number of jobs as well. This is how I did it.
As before I gathered the required jobs using Get-SQLAgentJob… Read more

0 comments, 81 reads

Posted in SQL DBA With A Beard on 20 February 2017

DevOps Webinar Tomorrow

A quick reminder that tomorrow, Feb 21 at 12pm EST, I’ll be hosting another DevOps, Database Lifecycle Management (DLM) webinar. Together with Arneh Eskandari, we’ll show how we can each make changes to our own database, push the changes to git and reconcile merge issues.

Register now, and… Read more

0 comments, 114 reads

Posted in The Voice of the DBA on 20 February 2017

Monday Coffee 2017-02-20

No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat has never been cleaner!

So last week Microsoft announced Availability Groups for SQL Server on Linux.

This is a big announcement as one of the first things I noticed… Read more

0 comments, 62 reads

Posted in The DBA Who Came In From The Cold on 20 February 2017

SQL Cruise 2017 – Western Carribean – my experience

As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is a training(&-vacation for some) event organized by Tim Ford(b | t ) and Amy Ford (t) that happens twice a year. I went on the first one… Read more

0 comments, 140 reads

Posted in Mala's Data Blog on 19 February 2017

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database

One of my client vCenter Server fails to start as below shown error in event logs.
Could not allocate space for object 'dbo.VPX_EVENT'.'VPXI_EVENT_USERNAME' in database 'VCDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,…

Read more

0 comments, 44 reads

Posted in Ganapathi's MSSQLLover on 17 February 2017

Older posts