Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Open Source Power BI Desktop Workshop

I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired to do this by Brent Ozar, who also created a free open-source course How to Think Like the Engine. If you haven’t checked out that course, make sure you… Read more

5 comments, 259 reads

Posted in Koen Verbeeck on 13 February 2017

Implementing Fuzzy Sets in SQL Server, Part 8: Possibility Theory and Alpha Cuts

By Steve Bolton

…………To get the point across that fuzzy sets require membership grades of some sort, throughout this series I’ve borrowed the stored procedure I coded for Outlier Detection with SQL Server, part 2.1: Z-Scores and rescaled the results on the customary range of 0 to 1. The… Read more

0 comments, 189 reads

Posted in Multidimensional Mayhem on 13 February 2017

Altering a Job Step on Hundreds of SQL Servers with PowerShell

I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad to present to the joint Dutch SQL and PowerShell User Groups. Whilst I was sat at the airport I got a phone call from my current client. “We need to change the backup path for all… Read more

1 comments, 142 reads

Posted in SQL DBA With A Beard on 13 February 2017

Export All Plans From Cache to a .SQLPLAN File

I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file. My immediate answer was, “I’m sure there’s a PowerShell script out there somewhere.” However, rather than do a Gingle search, I figured I’d quickly knock up an example.

The Script

Read more

2 comments, 169 reads

Posted in The Scary DBA on 13 February 2017

Monday Coffee 2017-02-13

Man, if there was an award for procrastinating I’d definitely be in with a shout for today (I write these posts on the weekend). 

So I’m half writing this sitting on my balcony with a beer, one eye on the Italy v Ireland Six Nations game and trying not to… Read more

0 comments, 104 reads

Posted in The DBA Who Came In From The Cold on 13 February 2017

The Foundry and Data Masking

There’s a group at Redgate that investigates new ideas and products. They’re called the Foundry, and they do some cool things. One of those is work on data masking. They’ve got a whole section on the Redgate site. Check it out and see what you think.

I’ve seen some… Read more

0 comments, 140 reads

Posted in The Voice of the DBA on 13 February 2017

Lightweight Statistics Profiling (with a potential bug)

The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightweight query execution … Continue reading

Read more

1 comments, 164 reads

Posted in All About SQL on 13 February 2017

SSDT and Friends - .net meetup video

I did a talk at the london .net meetup if you want to get an overview of what SSDT is and how to get started then I would recommend it:


This was aimed at .net developers rather than DBA's so there isn't much talk about "why you should use…

Read more

0 comments, 122 reads

Posted in Ed Elliott's Sql Developer Blog on 10 February 2017

Devops without management buy in?

I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn't sold on the idea and the DBA's had complete control to push back on all and…

Read more

0 comments, 202 reads

Posted in Ed Elliott's Sql Developer Blog on 10 February 2017

How to get Open Live Writer working with Blogger

Wow – I didn’t blog at all in 2016!  While I’m certain that falls squarely on me, perhaps a small part of it is related to a bug connecting to Blogger (formerly Blogspot) blogs in my favorite blogging software – Open Live Writer.  This blog post explains the… Read more

0 comments, 179 reads

Posted in New York City .NET on 10 February 2017

How Can the SQL Server Resource Governor Help You?


If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don’t share the… Read more

0 comments, 256 reads

Posted in Kevin E. Kline on 10 February 2017

YouTubing Down the SQL Server River

I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and one of the nicest people out there - Kendra Little (blog/@Kendra_Little).  Since divesting herself from Brent Ozar Unlimited over a year ago Kendra has been…

Read more

0 comments, 153 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 February 2017

Friday Reading 2017-02-10

Fun week, performed some RAM upgrades for my production SQL boxes which for one server, somehow fried its motherboard, hard drive AND backup drive, huh?? Meh, I like rebuilding servers…Also got a whole load of writing done so quite pleased with myself!

In-between all that, I’ve been reading…

Why databases… Read more

2 comments, 120 reads

Posted in The DBA Who Came In From The Cold on 10 February 2017

Opening the PowerShell ISE from Explorer

This is a cool productivity trip, and one that I ran into by accident. I had heard that I could launch a command prompt by typing cmd in the address. That works, and it’s cool. It even works with ConEmu, which is my default command window.

However, while I was… Read more

2 comments, 407 reads

Posted in The Voice of the DBA on 9 February 2017

Consumption Based Architecture for Modern Data Analytics

Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data in one location so it could be easily consumed by reporting and analysis tools from SQL Server Reporting Services to Microsoft Excel. We have followed the dimensional modeling processes promoted… Read more

2 comments, 222 reads

Posted in DataOnWheels on 9 February 2017

Speaking at Triad Developer’s Conference

I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference in Winston-Salem on March 10, 2017.

The Triad Developer’s Conference is a low cost one day learning event put on by a myriad of local user groups in the Piedmont… Read more

0 comments, 117 reads

Posted in SQL Swimmer on 9 February 2017

Missing Checkbox for Security Filter in Power BI Desktop

Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing checkbox.
I was implementing security using roles in a Power BI Desktop model. I had defined the role along with its filter on top of a many 2 many relationship.… Read more

0 comments, 495 reads

Posted in Koen Verbeeck on 9 February 2017

TugaIT – Pre-conference workshop on PowerShell on Linux

Where – Thursday, May 18, 2017

Where – TUGA IT – Lisbon, Portugal

Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your Heterogenous Data Center“ 

Registration Link – https://app.weventual.com/detalheEvento.action?iDEvento=4011

  • Early Bird Price – before 03/18/2017 – 150€
  • Normal Price – before 05/01/2017 – 200€
  • Late…

Read more

0 comments, 122 reads

Posted in Anthony Nocentino's Blog on 8 February 2017

DBA 101: What you may be missing with “Missing indexes”

If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I will say they are improving every day and maybe, just maybe, we will see the day when you can click happily away and do everything you want. Sadly, this is… Read more

7 comments, 1,967 reads

Posted in Confessions of a Microsoft Addict on 8 February 2017

Let NonAdmins Get Logins

I saw a question recently about how to allow some users to see the logins on a server without being a sysadmin or securityadmin. This was in support of a migration effort, so users needed read rights without being able to change anything.

This appears to be a good place… Read more

0 comments, 299 reads

Posted in The Voice of the DBA on 8 February 2017

Newer posts

Older posts