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

Archives: June 2017

Security Basics: The Principle of Least Privilege

Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle of Least Privilege. There are several definitions out there, some wordier than others. Here’s mine:

Give the permissions necessary to do the job. No more. No less.

If this is… Read more

3 comments, 2,539 reads

Posted in Databases – Infrastructure – Security on 30 June 2017

Don’t Forget the Keys

I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server 2016.  This came none too soon as SQL Server 2012 (SP3) goes out of mainstream support on July 11, 2017.

We decided to go with a brand new box since… Read more

0 comments, 2,186 reads

Posted in SQL Swimmer on 30 June 2017

Using Organization Hierarchies as Reporting Unit filters with Management Reporter

Well, hello. It has been more than three years since my last blog, since then I have been really busy at work and have a…

Read more

0 comments, 542 reads

Posted in Terry's Business Intelligence on 30 June 2017

VMworld 2017 USA Sessions

I’m proud to announce that my sessions for this year’s VMworld 2017 conference in Las Vegas have turned up in the VMworld Content Catalog! I have four exciting sessions (if you’re a database geek) at the conference, and for those DBAs with VMware administrators attending this conference, tell them to… Read more

0 comments, 624 reads

Posted in Technobabble by Klee from @kleegeek on 30 June 2017

Power BI Custom Visuals Class (Module 57 – Infographic Designer)

In this module you will learn how to use the Infographic Designer Custom Visual.  The Infographic Designer give you the ability to make your reports tell a story and even theme the visuals to be more relevant to the topic of your data.

Module 57 – Infographic Designer


  • Power…

Read more

0 comments, 2,103 reads

Posted in Devin Knight on 30 June 2017

Implementing Fuzzy Sets in SQL Server, Part 11: Fuzzy Addenda

By Steve Bolton

…………One of the key reasons I looked into the topic of fuzzy sets in the first place was my suspicion that T-SQL, as a set-based language, would be ideal for modeling them. That turned out to be an understatement of sorts: I definitely was not prepared… Read more

0 comments, 615 reads

Posted in Multidimensional Mayhem on 30 June 2017

Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations

Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.

I have been asked a few times what the process is for creating a module, using Github and developing with Pester and whilst this is not a comprehensive how-to I hope it… Read more

4 comments, 783 reads

Posted in SQL DBA With A Beard on 30 June 2017

Friday Reading 2017-06-30

Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up early to watch it tomorrow, the team selection is here.

But anyway, this week I’ve been reading…

Using SQL Server Diagnostics
Arun Sirpal goes through how to use… Read more

0 comments, 535 reads

Posted in The DBA Who Came In From The Cold on 30 June 2017

SQL Server Permissions and Security Principals on UserGroup.tv

You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a site dedicated to capturing presentations just like this, run by Shawn Weisfeld, Sr Technical Evangelist from Microsoft. Thanks Shawn!

Thanks again to the organizers of the very successful SQLSaturday Houston…

Read more

0 comments, 644 reads

Posted in SQL Tact on 30 June 2017

Reading the log on SQL for Linux

The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server instance. As last checked today (6/29/2017) the latest CTP build seems to have problems reading the log.

This can be a problem when trying to diagnose an issue. Here’s what… Read more

0 comments, 859 reads

Posted in Confessions of a Microsoft Addict on 29 June 2017

DevOps Basics–Staging and Committing Changes

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.

In the course of normal work, you’ll change your code files. Git… Read more

0 comments, 665 reads

Posted in The Voice of the DBA on 29 June 2017

Data lake details

I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide more details on this popular technology, some of which I cover in my presentation “Big data architectures and the data lake“.  In short, the… Read more

3 comments, 2,356 reads

Posted in James Serra's Blog on 29 June 2017

PowerShell Module for the SQL Server Diagnostics API – 1st Command Get-SQLDiagRecommendations

I saw this blog post about the SQL Server Diagnostics add-on to SSMS and API and thought I would write some PowerShell to work with it as all of the examples use other languages.

SQL ServerDignostics API

The Diagnostic Analysis API allows you to upload memory dumps to be able… Read more

4 comments, 683 reads

Posted in SQL DBA With A Beard on 29 June 2017

Recording of PASS Security VC Webinar

If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has been published to YouTube.

As requested, here are the slides: The Dirty Business of Auditing (278 KB).

Read more

0 comments, 534 reads

Posted in Databases – Infrastructure – Security on 29 June 2017

Trying to Solve the Wrong Problem

Some time back, while pulling into a local coffee shop, I spotted a stranded motorist in the parking lot. Per the Texan code of ethics, I was duty bound to walk over and offer my assistance, and in doing so I discovered that someone else had already stopped to help.… Read more

1 comments, 519 reads

Posted in Tim Mitchell on 29 June 2017


Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to shoot a conclusion that the database files are experiencing high latency issue. The reason is the overall aggregation will mask spikes of poor performance.

It is recommended to capture the… Read more

0 comments, 757 reads

Posted in SQL Geek on 29 June 2017

Where To From Fundamentals?

The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little time understanding how databases store text, known as collation. The next step was understanding data types in general, and how SQL Server stores them. After that was understanding normalization, with… Read more

0 comments, 314 reads

Posted in Born SQL with Randolph West on 28 June 2017

Row-count Estimates when there are no Statistics

I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use if you’re selecting from a column where there are no statistics available? I’ve discovered there are a few algorithms in play depending on how you’re querying the table. In this… Read more

0 comments, 2,108 reads

Posted in Matthew McGiffen DBA on 28 June 2017

SQL Crossword : T-SQL Keywords : June 2017

I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked around and I’ve decided to make this a regular thing (end of the month or so) for a little while (till I get bored with it). I’m going… Read more

2 comments, 2,379 reads

Posted in SQLStudies on 28 June 2017

The Three A’s: Auditing

Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at some point we’ll need to do who is accessing that what and when it happened. That brings us to the third A: Auditing.

Auditing isn’t strictly required on all systems.… Read more

0 comments, 1,594 reads

Posted in Databases – Infrastructure – Security on 28 June 2017

Older posts