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

Archives: March 2016

MDX – Putting Visual Totals on top or at the bottom

Dynamically totaling child members

Putting the dynamic totals on top or at the bottom can be a trivial or a big decision. Very often, visual tools reply on MDX queries to get the aggregation correct in the MDX query so that the need to aggregate in the visual tool is… Read more

0 comments, 1,067 reads

Posted in Sherry Li's BI Corner on 31 March 2016

Ola Hallengren’s solution on a network share using FTP

I use the Ola Hallengren’s maintenance solution for my SQL Servers instances. 
It happened to run the maintenance solution so that it writes to a separate server using FTP protocol.
An ftp user and a network share was given to me to use it for the backup files to store…

Read more

0 comments, 895 reads

Posted in SQL Mighty on 31 March 2016

March MVP – Gareth Swanepoel

The March nomination is Gareth Swanepoel (B|T).

If you don’t know Gareth you should make it a point to get to know him.  He originally hails from South Africa but now resides in the United States with his family.

Gareth is a frequent presenter in the… Read more

0 comments, 742 reads

Posted in John Morehouse | Sqlrus.com on 31 March 2016

I hope you didn't miss it!

Warning: This is a really short post.

Today March 31st, BrentOzar.com is giving away their videos! Well, not giving away... but they are 50% off! I doubt anyone follows this blog and isn't aware of Brent Ozar, but just in case!

Good luck and happy hunting. 

Read more

0 comments, 715 reads

Posted in DBA On The Go on 31 March 2016

2016 PASS Nominating Committee Announced

I was pleased to hear today that I was selected for the 2016 NomCom, along with Joaquin Romero, Erin Stellato, and Thomas LeBlanc. We’ll be working with the Nominations Committee (NomCom) Chair, Thomas LaRock, and Board representative, Tim Ford. It is a solid team and I’m eager to get… Read more

0 comments, 967 reads

Posted in SQLAndy on 31 March 2016

SQL Server 2016 Azure Virtual Machines

With the release candidates coming thick and fast for SQL Server 2016 downloading, uninstalling the previous version and installing the latest can be a little bit tedious.
A less timing consuming option to trying the latest is to use Microsoft Azure. If you have an Azure subscription you can spin…

Read more

0 comments, 1,355 reads

Posted in The SQL DBA in the UK on 30 March 2016

Multiple Tagging of TFS Work Items Using Excel

In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can be used to manage SQL Server-related development. Some of the feedback I received from the article was the issue of tagging items in Excel. This article illustrates… Read more

0 comments, 867 reads

Posted in Select SIFISO Blogs on 30 March 2016

When should I test?

To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the question posted here. It’s a big question so let’s break it down a bit.


You have a system and are about to upgrade some or all of it.… Read more

2 comments, 760 reads

Posted in SQLStudies on 30 March 2016

SQL Agent Job Schedules

Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You can read all about that here.

In a very similar fashion, today I want to share how easy it is to turn the internal schedules for SQL Agent jobs… Read more

2 comments, 2,459 reads

Posted in SQL RNNR on 29 March 2016

Certain DBs in an AG not Backing Up

Last week, I received an alert that the percentage of transaction log in use on one of our production databases was increasing more than it should have been. I’ll refer to this database as DB1 from here on in. It had reached 18%, which is above the normal 5-10% we… Read more

4 comments, 913 reads

Posted in The Database Avenger on 29 March 2016

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly there is no shortage of topics!  There is a list of all my presentations with slide decks and videos in some cases.  Here are… Read more

0 comments, 884 reads

Posted in James Serra's Blog on 29 March 2016

Monday Morning SQL Break – March 28, 2016

It’s Tuesday, and the Monday post is late.  A weekend of smoking quite a few pounds of pork kept me in a meat coma.  The three day weekend also kept motivation to get this post out low, but hey, it’s Tuesday and might as well share this – since I… Read more

0 comments, 894 reads

Posted in StrateSQL on 29 March 2016

Protecting the SA Account

The sa account is a well, known, built in account for SQL Server. Years ago, in previous

versions, I’d see people often use the “sa” account for development, usually with a blank password. Even those speakers and experts often showed demo code with a blank “sa” password.

Ugh, a horrible… Read more

0 comments, 947 reads

Posted in The Voice of the DBA on 29 March 2016

SQL Server 2016 features: Query Store

Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some thoughts on new features.

The first one I want to look at is a feature that I’m so looking forward to getting to use, the Query Store.

Query Store is… Read more

0 comments, 850 reads

Posted in SQL In The Wild on 29 March 2016

SQL Server 2016 features: Query Store

Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some thoughts on new features.

The first one I want to look at is a feature that I’m so looking forward to getting to use, the Query Store.

Query Store is… Read more

0 comments, 446 reads

Posted in SQL In The Wild on 29 March 2016

Update to TRUNCATE TABLE in SQL 2016 (partition support)

Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.

This change allows you to truncate an individual partition, instead of having to switch that partition out to another table and then truncate it. Full details can be found here:… Read more

1 comments, 2,732 reads

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

Do You Teach Azure Data Platform?

I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out. I started using Azure SQL Database (although it had a different name then) Day 1.

I know a few other people who don’t work for Microsoft, but have been actively… Read more

2 comments, 795 reads

Posted in The Scary DBA on 29 March 2016

SQL Server Service Broker – Service Architecture

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queuing technology built into the SQL Server Database Engine.

Previous posts:

In this installment, we introduce the basic Service Broker service architecture components. Read more

5 comments, 1,031 reads

Posted in Cleveland DBA on 29 March 2016

Talking about the Query Store at SQLBits!

From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will be in Liverpool promising four days of great SQL Server sessions and training. Just take a look at the agenda to be blown away by the amount of… Read more

0 comments, 728 reads

Posted in DotNine SQL Server and more on 29 March 2016

Nothing To See Here

In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to implement cell level encryption for sensitive data.  Their weapon of choice was to do this utilizing C# code within SQL Common Language Runtime (CLR).  Though the galaxy is full… Read more

1 comments, 839 reads

Posted in John Morehouse | Sqlrus.com on 29 March 2016

Older posts