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

Latest Blog Posts

Power BI Custom Visuals Class (Module 111 – Horizontal Bar Chart)

In this module you will learn how to use the Horizontal Bar Chart. The Horizontal Bar Chart is similar to the native Bar Chart but with a few additional customizations that can be configured.

Module 111– Horizontal Bar Chart


Read more

0 comments, 527 reads

Posted in Devin Knight on 17 July 2018

Power BI World Tour Is Coming to Charlotte

If you haven’t heard, Power BI is doing a world tour, eight cities in four months and Charlotte, NC is one of those stops.  The Power BI World Tour is coming to Charlotte on August 27, 2018, and I will be speaking at this event!

I will be presenting my… Read more

0 comments, 116 reads

Posted in SQL Swimmer on 17 July 2018

New Logo Revealed

I’ve been pondering the creation of a logo for quite some time and I finally decided to go ahead with it.

Now, I can barely draw stick people (and have them even resemble people), so I knew I was going to have to hire someone to do this for me.… Read more

1 comments, 102 reads

Posted in SQL Swimmer on 17 July 2018

The Figleaf Data Masking Beta

I’ve been using the Redgate Software Data Masker for SQL Server in a number of situations to help customers. This is a tool we purchased in 2017 and is a part of the SQL Provision bundle to make building safe, secure dev and test databases.

Project Figleaf is the next… Read more

0 comments, 146 reads

Posted in The Voice of the DBA on 17 July 2018

T-SQL Tuesday #104 Roundup

This month’s T-SQL Tuesday topic asked “What code would you hate to live without?” Turns out you like using script and code to automate boring, repetitive, and error-prone tasks.

Thank you to everyone who participated; I was nervous that July holidays and summer vacations would stunt turnout, however we wound… Read more

3 comments, 451 reads

Posted in Bert Wagner on 17 July 2018

Quickly Change SQL Job Owners

It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent. Sometimes, the user creating the job(s) sets themself as the owner of the job. There are certain cases where this behavior is hard to avoid like when… Read more

1 comments, 150 reads

Posted in SQL RNNR on 16 July 2018

Understanding Data Sharing in SQL Server Docker Containers

This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers the following topics: Introduction of the Docker volumes. Managing volume using Docker CLI commands or Docker API. Sharing data between … Continue reading

Read more

0 comments, 162 reads

Posted in PowerSQL By Prashanth Jayaram on 16 July 2018

Solving Ken’s FizzBuzz 3D–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I like the FizzBuzz test. It’s cute and fun, and I’ve had my kids solve it, just to think about what it means to structure a simple problem.… Read more

2 comments, 179 reads

Posted in The Voice of the DBA on 16 July 2018

Databases and DevOps, Tools are the Easy Part

Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools are a necessary aspect of DevOps because, one of the fundamentals of implementing a DevOps approach is automation. To automate, you need the right tools. However, tools and automation, while… Read more

4 comments, 129 reads

Posted in The Scary DBA on 16 July 2018

SQL Saturday Louisville–Bout That Time

SQL Saturday Louisville is less than a week away!! A lot of hard work has gone into putting on this event by some great organizers and volunteers. It has been awesome to be part of the journey with them. You can check out the event homepage here and if your… Read more

0 comments, 84 reads

Posted in The SQL Professor on 16 July 2018

Counting NULLs

Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As always I enjoy these quizzes and in this particular case it gave me an idea for a post.

How do NULL values affect the COUNT… Read more

2 comments, 459 reads

Posted in SQLStudies on 16 July 2018


I was speaking at a conference recently and when I bumped into a friend, the first thing she said to me was “have you burnt out yet?”

Now this was a joke but it did get me thinking. I’ve been speaking at quite a few events this year and tbh… Read more

0 comments, 127 reads

Posted in The DBA Who Came In From The Cold on 16 July 2018

Inline Table-Valued Functions (TVFs)

Lets start off with what is a table-valued function (TVF)? A TVF is a dynamic table produced at the time of execution, depending on parameters. Like a view, a TVF creates a result set only when it’s executed, but, unlike a view, it can be parameterized.

You get two types… Read more

1 comments, 182 reads

Posted in The SQL Girl on 16 July 2018

Another MVP Award – 2018-2019

Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled to receive the Microsoft MVP award 2nd time in a row.

Thank you !!

My gratitude to my family who has been always there to support, guide and making me… Read more

0 comments, 99 reads

Posted in SQL Geek on 16 July 2018

Book Review – Factfulness by Hans Rosling

I recently bought the book Factfulness – Ten Reasons we’re wrong about the world – And why things are better than you think by Hans Rosland (with Ola Rosling and Anna Rosling Rönnlund). The book is a fascinating read and I recommend it to everyone. Not just people working with… Read more

0 comments, 460 reads

Posted in Koen Verbeeck on 15 July 2018

SQL Server data flow into Excel template with Power Query function-based parameter

(2018-July-15) Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a few minutes and Power Query is a very handy tool to connect/shape and extract your data into a worksheet format. What if you need to create multiple files where…

Read more

0 comments, 208 reads

Posted in Data Adventures on 15 July 2018

SQL Server : Understanding Backup and Restore operations using Docker Containers

In this article, we will discuss the concepts of database backup-and-restore operations on SQL Server Docker containers. This is certainly the era of containers and it made the buzz in the business, so let us understand the importance of backup-and-restore … Continue reading

Read more

0 comments, 180 reads

Posted in PowerSQL By Prashanth Jayaram on 12 July 2018

Back to #SQLSat Louisville

Next week is SQL Saturday #729 – Lousiville and I’m making the trip. This will be my third or fourth trip there, and I’m looking forward to the trip. It’s a nice town, I can visit some family, and lots of #sqlfamily friends will be there.

This is the 10th… Read more

0 comments, 244 reads

Posted in The Voice of the DBA on 12 July 2018

Balancing Security Concerns.

I have a presentation I do every now again on security basics that I’m actually quite proud of. One of the sections at the end is on best practices, where I mention a few important security best practices broken down as follows:

  • Least Maintenance
  • Least Least Surface Area
  • Least…

Read more

2 comments, 120 reads

Posted in SQLStudies on 12 July 2018

Finding Inconsistent Key Values–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I was reading Iris Classon’s blog recently and ran across a post on her day at work. I think it’s a fantastic post that does help younger… Read more

0 comments, 1,501 reads

Posted in The Voice of the DBA on 11 July 2018

Newer posts

Older posts