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

Archives: February 2019

SQL Server 2017 Reporting Services: The Basics Part 4

Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I did this was on a book on SQL Server 2012 Reporting Services published by Packt. SSRS has since evolved into a better reporting platform with the addition of… Read more

0 comments, 51 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 February 2019

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC #SQL #Azure #MSDTC

If you have been following my blog, you probably know that I write a lot of step-by-step guides for building SQL Server Failover Cluster Instances (FCI) on Azure, from SQL Server 2008 through the lastest. Here are some links to get you started, but really there is very little difference… Read more

0 comments, 60 reads

Posted in Clustering for Mere Mortals on 15 February 2019

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, 49 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, 43 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, 52 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, 266 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, 205 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, 50 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, 74 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, 115 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

4 comments, 102 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, 67 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, 77 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, 248 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, 106 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, 310 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, 105 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

Older posts