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

Latest Blog Posts

Benchmarking with WorkloadTools

If you ever tried to capture a benchmark on your SQL Server, you probably know that it is a complex operation. Not an impossible task, but definitely something that needs to be planned, timed and studied very thoroughly.

The main idea is that you capture a workload from production, you… Read more

0 comments, 30 reads

Posted in SpaghettiDBA on 15 February 2019

Speaking at SQL Saturday Chicago

I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019.  I will be presenting my Profiling Your Data session.

It’s been a few years since I’ve been to Chicago.  Last time I was there was when… Read more

0 comments, 17 reads

Posted in SQL Swimmer on 15 February 2019

Achievement Unlocked – SQL Bits

Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email.  I had submitted to speak at SQL Bits and during my flight I was notified that one of my submitted sessions had been selected.  This means that I’ll be traveling to Manchester, England… Read more

0 comments, 31 reads

Posted in John Morehouse | Sqlrus.com on 15 February 2019

Practical Web Scraping–Getting Started

As part of my learning goals for 2018, I wanted to work through various books. This is part of  my work with Python.

After going through a few first chapters, I decided to start my February learning with Practice Web Scraping for Data Science, which looks at data… Read more

0 comments, 72 reads

Posted in The Voice of the DBA on 15 February 2019

Partitioning 4: Finding partitioning in DMVs and Object Explorer

Happy Friday! Today’s post will be light on the performance side and instead, I’m going to talk about how to take a look at your server’s partitioning.

First, partitioning in SQL Server Management Studio

Object Explorer, that thing on the left side of the SSMS window, will show partition info.… Read more

0 comments, 37 reads

Posted in Arthur's Blog on 15 February 2019

ASF 019 video invitation

Check how many bicycles he has got at home and where was the destination of last year of a 400 km trip? Which tool among Azure is the closest to his soul? What exactly is hiding behind the term “Modern Data Warehouse”? When Azure Data Factory (Mapping) Data Flow will… Read more

0 comments, 43 reads

Posted in SQL Player Blog on 15 February 2019

Speaker at SQL Saturday’s Guatemala city 2019

I’m very happy to announce that for the second year in a row I will be participating as speaker in this year’s SQL Saturday event in Guatemala city!

Here are the details of the two sessions I will be presenting on February 16:

  • Azure Fundamentals for the SQL Server DBA:

Read more

0 comments, 64 reads

Posted in DBA Mastery on 15 February 2019

Learn about the State of Database DevOps Next Week

It’s a week to my webinar with Donovan Brown (b t, y g), leader of the League of Extraordinary Cloud DevOps Advocates, Principal DevOps Manager at Microsoft, and the guy that wants to Rub DevOps on Everything. He’s a passionate, intelligent, exciting guy whose enthusiasm… Read more

0 comments, 101 reads

Posted in The Voice of the DBA on 14 February 2019

DBA Myths: Can a differential backup get bigger than the full backup?

The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one until I posted What’s a differential Backup? and Randolph West (b/t) pointed out that my belief that differential backups can’t get larger than full backups was… Read more

3 comments, 92 reads

Posted in SQLStudies on 14 February 2019

Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths

Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.

We’ve spotted an issue where unicode datatypes were having their size recorded as the data length rather than character count in the ‘Tables’ module. Another issue affected any MAX datatypes which were having their length… Read more

0 comments, 64 reads

Posted in SQL Undercover on 14 February 2019

Partitioning 3: Beyond just partition elimination

In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching the entire year’s partition for data. What if we filtered more specifically on the partitioning key?

Yesterday’s query: redux

Taking the same query, but this time let’s just search… Read more

0 comments, 71 reads

Posted in Arthur's Blog on 14 February 2019

Violin Plots in Power BI

In case you aren’t familiar, I would like to introduce you to the violin plot.

A violin plot is a nifty chart that shows both distribution and density of data. It’s essentially a box plot with a density plot on each side. Box plots are a common way to show… Read more

2 comments, 74 reads

Posted in Data Savvy on 14 February 2019

Speaking at SQL Saturday Victoria

I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is Power BI session.

This is another kind of homecoming for me.  When I was a kid, my sister & I lived… Read more

0 comments, 68 reads

Posted in SQL Swimmer on 13 February 2019

Free SQL tuning tool: How’s My Database?

It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.

What is “How’s My Database?” I’d… Read more

1 comments, 105 reads

Posted in Confessions of a Microsoft Addict on 13 February 2019

Where have I been?

Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of you know I’ve been working on a UWP app to help query tuning in SQL Server and showed quite a few people an alpha of the tool at PASS Summit.… Read more

0 comments, 91 reads

Posted in Confessions of a Microsoft Addict on 13 February 2019

Adding Objects to our SCA Project

In my last post, I started out with a new SCA project, getting a connection to my database up and running. Now, let’s start the new project by adding some objects.

Adding Objects

I’m going to start with a couple objects to make this simple, but we’ll move on from… Read more

0 comments, 136 reads

Posted in The Voice of the DBA on 13 February 2019

Proposed SQL Server defaults: cost threshold for parallelism

A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to enabled Set max… Read more

0 comments, 104 reads

Posted in Born SQL with Randolph West on 13 February 2019

Speaking Internationally at SQLBits


I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL Server conference in Europe, held in Manchester England February 27- March 2nd. It is a conference for leading data professionals with over 70 sessions from speakers all over… Read more

0 comments, 81 reads

Posted in SQLEspresso on 13 February 2019

Partitioning 2: Getting and measuring partition elimination

In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.

Adding the partitioning key to your query

Since I created the index in part 1 on the Posts_Partition_Scheme, the index was split up among the partitions. What if I only want… Read more

0 comments, 76 reads

Posted in Arthur's Blog on 13 February 2019

Azure SQL Database and Transaction Log

Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know about what your transaction log is doing in the cloud. The following queries have been tested and run okay within … Continue reading

Read more

1 comments, 93 reads

Posted in All About SQL on 13 February 2019

Older posts