Latest Blog Posts
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
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
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
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.
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
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
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…
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…
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
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
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…
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
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
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
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
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€
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
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