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

Latest Blog Posts

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, 8 reads

Posted in The Voice of the DBA 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, 56 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, 41 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, 60 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

1 comments, 77 reads

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

What is Power BI Premium?

Today I’m delivering a webinar presentation in partnership with Pragmatic Works called “What is Power BI Premium?”. You can register for the webinar here.

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… Read more

2 comments, 89 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, 82 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, 67 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, 76 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, 133 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, 110 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, 113 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, 94 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, 68 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, 98 reads

Posted in All About SQL on 22 May 2017

Fischer’s Exact Test – with T-SQL and R

This post is a long overdue second part to the post on Chi Square Test that I did a few months ago.  This post addresses relationships between two categorical variables, but in cases where data is sparse, and the numbers (in any cell) are less than 5. The Chi Square… Read more

0 comments, 93 reads

Posted in Mala's Data Blog on 22 May 2017

Monday Coffee 2017-05-22

I hope everyone had a good weekend. I spent mine watching probably the most dismal performance of rugby I’ve seen for a long time but there’s still a bunch of matches on before the end of the season so fingers crossed for the next one (not to mention the Lions… Read more

0 comments, 124 reads

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

Dump Data From SQL 2005 table to Excel 2016

By First looking at the topic name, does the task sound simple to you? Well, I thought so but it turned out to be quite a mammoth task with loads of learning.

The requirement is to transfer the data from a SQL Server table to an excel spreadsheet. The caveat is…

Read more

0 comments, 81 reads


Learning – Webcasts/Video

Learning for this week. http://www.pass.org/24hours/2017/security/Schedule.aspxhttp://sqlblog.com/blogs/damian_widera/archive/2017/04/20/sql-server-2017-all-sessions-from-microsoft-data-amp-are-online-complete-list-of-links.aspx http://sqlblog.com/blogs/davide_mauri/archive/2017/05/01/pass-appdev-recording-building-rest-api-with-sql-server-using-json-functions.aspx http://sqlblog.com/blogs/sergio_govoni/archive/2017/04/15/pass-business-analytics-marathon-march-2017-recordings-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/31/the-recording-for-biml-in-the-enterprise-data-integration-lifecycle-is-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/14/the-recording-for-the-ssis-catalog-compare-version-2-launch-event-is-available.aspx  

Read more

0 comments, 128 reads

Posted in Vinay Thakur on 21 May 2017

Azure CosmosDB SQL Server

As you know Microsoft has retrieve the data from Hadoop with by polybase and extended the R language to External language(R and Phython). now Microsoft is wanted to make sure that it has feasibility for all the environment whichever is available … Continue reading

Read more

0 comments, 186 reads

Posted in Vinay Thakur on 21 May 2017

Older posts