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

Archives: May 2017

Tuning Parallelism on SQL Server

Parallelism and MAXDOP

There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the load across multiple processes and get the job done quicker.

However it’s important to understand that it has an overhead. There is extra effort involved in managing the separate… Read more

0 comments, 76 reads

Posted in Matthew McGiffen DBA on 26 May 2017

Microsoft Professional Program in Data Science – The Road So Far

I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open Online Course), all provided through the edX platform. You are free to participate, but for a verified certificate you will need to pay (and Microsoft/edX has bumped up the… Read more

0 comments, 139 reads

Posted in Koen Verbeeck on 26 May 2017

Speaking at SQL Saturday Pensacola!

I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!

If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

If you haven’t been to… Read more

0 comments, 53 reads

Posted in Anthony Nocentino's Blog on 26 May 2017

Friday Reading 2017-05-26

The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this weekend! Hope the weather is the same wherever you are, here’s some reading (to be done outside )…

Experienced DBA: Rookie Mistake
John Morehouse tells us about a mistake he… Read more

0 comments, 92 reads

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

PowerShell Remoting in Multi-Platform Environments using OpenSSH

So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going down that path together. In this post I’m going to introduce PowerShell Remoting in Multi-Platform Environments, specifically using OpenSSH. We’ll discuss WinRM in multi-platform systems in an upcoming post.

Have… Read more

0 comments, 78 reads

Posted in Anthony Nocentino's Blog on 25 May 2017

Save on IT/DevConnections this fall

For the first time in many years, I won’t be at IT/DevConnections this fall.  I’m disappointed to miss the event, but I had other commitments around this time when I heard about being chosen as a speaker and this would be the fourth event in four weeks. That’s a bit… Read more

0 comments, 122 reads

Posted in The Voice of the DBA on 25 May 2017

Restore to a point in time–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

One of the things I had to show recently was a restore… Read more

0 comments, 129 reads

Posted in The Voice of the DBA on 25 May 2017

Speaking at SQL Saturday Atlanta (#652)

I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year.  This is huge event where I’ve been a volunteer and attendee in the past, but this will be my first time as a speaker.

I will be presenting my session What… Read more

0 comments, 74 reads

Posted in SQL Swimmer on 25 May 2017

SSRS Subscription Schedules – Enhanced

Reporting Services

 

Over the past couple of articles I have illustrated some of the fun that can be had when dealing with the scheduling capabilities of Reporting Services (SSRS). The first article covered how to create more advanced schedules (from the SSRS point of view). In another I article,… Read more

0 comments, 101 reads

Posted in SQL RNNR on 25 May 2017

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

1 comments, 94 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

1 comments, 93 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

3 comments, 108 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, 191 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, 200 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, 111 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, 179 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

1 comments, 96 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

Downloads

Read more

0 comments, 98 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

3 comments, 120 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, 204 reads

Posted in SQL with Dustin Ryan on 23 May 2017

Older posts