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

Latest Blog Posts

Power BI Custom Visuals Class (Module 86 – Bubble Chart by Akvelon)

In this module you will learn how to use the Bubble Chart Custom Visual by Akvelon. The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble.

Module 86 – Bubble Chart By Akvelon


Read more

0 comments, 144 reads

Posted in Devin Knight on 19 January 2018

tSQLt Tests for Advent of Code 2017 Day 4

This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and solving the issues that way. This lets me use… Read more

0 comments, 125 reads

Posted in The Voice of the DBA on 19 January 2018

Finding the Default Path with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

It’s been awhile since I worked on any… Read more

0 comments, 138 reads

Posted in The Voice of the DBA on 19 January 2018

Implementing SSL for Your Blog

With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been focused on security awareness this entire week.  To further underscore it, we are hosting a Security Webcast today, Friday January 19th, 2018 at 2:00PM EST (11:00 AM PST).  Make… Read more

0 comments, 74 reads

Posted in John Morehouse | Sqlrus.com on 19 January 2018

Toolbox - Why is My Database So Big????

I have written previously (here) about how to tell which database files have free space in them when your drive starts to fill.

What if all of your database files are full and you are still running out of space?

F DB03

Read more

0 comments, 117 reads

Posted in Nebraska SQL from @DBA_ANDY on 19 January 2018

What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?

REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL users and even administrators at times get confused about the real functioning of this command. It is to be noted that it contains the term Repair, which signifies that the… Read more

0 comments, 98 reads

Posted in SQL Server Overview on 19 January 2018

Friday Reading 2017-01-19

It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…

Discussing PASS Linux Content with OVA Winner Tracy Boggiano
Tracy Boggiano (b|t) talks to PASS about Linux content in the PASS Virtual Groups

Best newish SSMS feature Read more

0 comments, 87 reads

Posted in The DBA Who Came In From The Cold on 19 January 2018


In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA we have some need for the speed. The one that makes us run faster, eat faster, drive faster, fly faster, compete with each other …
Because we want to… Read more

0 comments, 81 reads

Posted in Niko's blog on 19 January 2018

Template Explorer (Day 18)

You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up a template for you to fill in – for instance, when creating a new stored procedure. Have you ever wondered where SSMS gets the template from? You can view all… Read more

1 comments, 82 reads

Posted in A Discussion of SQL Server-Related Topics on 18 January 2018

Advent of Code 2017 Day 4–#SQLNewBlogger

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

This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1.

This is Day 4, which… Read more

0 comments, 210 reads

Posted in The Voice of the DBA on 18 January 2018

Database Corruption and IO Errors

A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users are panicked, applications are not working and the HelpDesk team is curled up in the fetal position in the corner. Why?… Read more

2 comments, 150 reads

Posted in SQL RNNR on 18 January 2018

Pester 4.2.0 has a Because…… because :-)

I was going through my demo for the South Coast User Group meeting tonight and decided to add some details about the Because parameter available in the Pester pre-release version 4.2.0.

To install a pre-release version you need to get the latest  PowerShellGet module. This is pre-installed with PowerShell v6… Read more

0 comments, 85 reads

Posted in SQL DBA With A Beard on 18 January 2018

Jack of ALL Trades

Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about something that is important & sensitive.
And if it has not, then this blog post was not written for you

In the past number of years, there has been… Read more

2 comments, 120 reads

Posted in Niko's blog on 18 January 2018

All Scripts Now On Github

@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox

Read more

0 comments, 145 reads

Posted in SQL Undercover on 18 January 2018

Add color to connections (Day 17)

Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well, you can change the status bar to any color that you want for any instance.

In the Connect to Server dialog, select the Options button.

Then select the “Connection Properties”… Read more

0 comments, 100 reads

Posted in A Discussion of SQL Server-Related Topics on 17 January 2018

SQL Server 2017 DMVs and DMFs for DBAs

Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the system state. On querying the related system objects, database administrators can understand the internals of SQL Server. It allows us to monitor the performance of the SQL Server instance, and… Read more

0 comments, 119 reads

Posted in PowerSQL By Prashanth Jayaram on 17 January 2018

Secure or fast? Secure, obviously …

By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM) resulting in a series of vulnerabilities in operating systems and … web browsers? One of my favourite things to do is to make queries run… Read more

0 comments, 110 reads

Posted in Born SQL with Randolph West on 17 January 2018

How to read a technical blog

There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If you do a search on a subject you are likely to get back multiple (if not large multiples) of responses and it can be hard to know what advice is… Read more

2 comments, 97 reads

Posted in SQLStudies on 17 January 2018

How to get started with Always Encrypted for Beginners Part 3: One Two Punch

A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the… Read more

2 comments, 117 reads

Posted in SQLEspresso on 17 January 2018

How to Run DBCC CHECKDB to Check SQL Database Integrity

Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is supported in databases that contain memory-optimized tables but the validation is only supported in disk-based tables. The DBCC repair option is unavailable in memory-optimized tables and therefore,… Read more

0 comments, 139 reads

Posted in SQL Server Overview on 17 January 2018

Older posts