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

Latest Blog Posts

Find when your SQL Server database grew

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it. I went down the extended events route using sqlserver.database_file_size_change event. By the way … Continue reading

Read more

0 comments, 47 reads

Posted in All About SQL on 25 May 2017

Power BI – Problem, Design, Solution (Concatenated Tooltip)

Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions to problems that we often run into with customers. Each post will be accompanied by a video (found in the bottom under… Read more

0 comments, 62 reads

Posted in Devin Knight on 24 May 2017

SSAS high availability

If you are looking at providing high availability (HA) for SSAS, here are 3 options:

  1. Install SSAS on a Windows Server Failover Cluster (WSFC)
    Here’s a good article. The main issue with this option is that SSAS isn’t cluster-aware, so if windows is “OK” but SSAS (the service)…

Read more

0 comments, 78 reads

Posted in James Serra's Blog on 24 May 2017

TIL: Microsoft Azure Part 2

Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure.  This is part two of what I am learning in Azure.

Today’s topic is simply about Tenants, Subscriptions, Subscription Roles, Resource Groups, and Tags.

It’s Always Good to Start with Pictures

Here is a glimpse… Read more

0 comments, 111 reads

Posted in SQLEspresso on 24 May 2017

Looking Back at Build–CosmosDB

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.

One of the big announcements at Build 2017 was the release of CosmosDB. This is a rebranding of DocumentDB, the document store in Azure, with some additional capabilities. You can also… Read more

0 comments, 130 reads

Posted in The Voice of the DBA on 24 May 2017

Running multiple queries at the same time.

I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at the same time, but with different parameters each time. One way to do it would be to open multiple query windows, and run them all as close to at… Read more

2 comments, 81 reads

Posted in SQLStudies on 24 May 2017

Measuring SQL Query Performance

When running workshops on the subject of SQL Query Performance the first question I always ask is how do we measure the performance of a query? Or to look at it another way  – how do we measure the resources it consumes?

Attendees have come up with a range of… Read more

0 comments, 115 reads

Posted in Matthew McGiffen DBA on 24 May 2017

Disabling the identity cache in SQL Server 2017

One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable the cache that SQL keeps on identity values by using the ALTER DATABASE SCOPED CONFIGURATION command.

What disabling the cache will do is prevent any gaps in the IDs happening… Read more

0 comments, 72 reads

Posted in The DBA Who Came In From The Cold on 24 May 2017

Power BI Custom Visuals Class (Module 52 – Bowtie Chart)

In this module you will learn how to use the Bowtie Chart Power BI Custom Visual.  The Bowtie Chart visual is designed to show a flow of data from one process or category to another.

Module 52 – Bowtie Chart


Read more

0 comments, 83 reads

Posted in Devin Knight on 23 May 2017

Experienced DBA: Rookie Mistake

M.A.S.H 4077.  Mobile Army Surgical Hospital.  One of my all time favorite TV shows that I still watch to this day.  There is one episode that has always stuck with me is one where Hawkeye has to deal with death of a friend during surgery. Afterwards, Colonel Blake imparts advice… Read more

2 comments, 95 reads

Posted in John Morehouse | Sqlrus.com on 23 May 2017

What is Power BI Premium?

Yesterday I had the pleasure of delivering a webinar presentation in partnership with Pragmatic Works called “What is Power BI Premium?”.

New to Power BI? Watch this introduction to Power BI Desktop video.

Since Power BI Premium was announced on May 3 there’s been a lot of questions around what… Read more

4 comments, 147 reads

Posted in SQL with Dustin Ryan on 23 May 2017

Setting up the Power BI Report Server Preview

Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power BI Report Server includes the ability to host Power BI reports, along with traditional SQL Server Reporting Services content, within the boundaries of your organization’s firewall.

I put together… Read more

1 comments, 122 reads

Posted in SQL with Dustin Ryan on 23 May 2017

Database snapshot issue with sqlserver

Database snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserver

Database snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserver Read more

0 comments, 79 reads

Posted in MSSQLFUN on 23 May 2017

SSRS Subscription Schedules

Reporting Services

Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can be delivered in various formats and can even be scheduled to be delivered at various times. I even recently wrote about creating more advanced custom schedules.

With the ability… Read more

0 comments, 85 reads

Posted in SQL RNNR on 23 May 2017

A Busy Few Years

Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking engagements. This person noted they had done over 40 talks in the last few years, which is a lot. I do more, but it’s part of my job. Ten talks… Read more

2 comments, 138 reads

Posted in The Voice of the DBA on 22 May 2017

Technology Gender Gap By State

This is my first ever guest blog post. Take it away Hazel Garcia.

Though the gender gap narrows by the year, there remains a noticeable lack of balance in the professional workplace. This gap reflects in everything from gender-based pay scale discrepancies to the ratio of women to men… Read more

2 comments, 121 reads

Posted in The Scary DBA on 22 May 2017

Employees, encourage work from home

The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one aspect that drives me nutty-freaking bonkers: “But, I don’t want to work from home!“ Oh, my stars and grasslands. Techies: I don’t want to force work from home.  I’m not… Read more

4 comments, 123 reads

Posted in SQL Awesomesauce on 22 May 2017

SSRS Custom Shared Schedule

Reporting Services


Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power within Reporting Services (SSRS) giving one the ability to perform visualizations, render reports in various formats and even schedule reports to be delivered in different formats or on… Read more

0 comments, 109 reads

Posted in SQL RNNR on 22 May 2017

What’s in a partition?

In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit more attention.

So what does it do? Per BOL

Returns the partition number into which a set of partitioning column values would be mapped for any specified partition function in…

Read more

0 comments, 73 reads

Posted in SQLStudies on 22 May 2017

AD Authentication and Azure SQL Database

Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into issues but once rectified it felt great using AD authentication in Azure rather than just SQL logins. If you look … Continue reading

Read more

2 comments, 103 reads

Posted in All About SQL on 22 May 2017

Older posts