Latest Blog Posts
I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not fueled the fire.
The various posts and discussions and the time writing this (multiple drafts) have definitely caused me to re-examine my own views. I’ve found that some were simplistic… Read more
I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram but as fast as Power BI is changing, v1 of the diagram was quickly obsolete. I always wanted to come back and add more to the diagram to make it… Read more
I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores, and I like it. However I realize that I’ve never actually noted what it is, so a short blog to do so today.
An RGE is a… Read more
0 comments, 252 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 17 June 2016
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
If there is one process that should be simpler than it is out of the box, it is creating Excel spreadsheets from SSIS. Over the years i’ve tried doing it a number of ways, using the built in component, Interop , OLE DB etc all suck to one degree or… Read more
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which I think can… Read more
So I've had this tool around for a while, but never found much usage out of it to be honest. I didn't end up writing a review as I had other tools that did text replacements, and history/session saving. I've always considered this tools implementation of SQL History/Tabs saver the… Read more
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested in logging changes to certain columns? This is where the UPDATE function comes in. This function can only be used in DML triggers and it allows us to discover if… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
0 comments, 2,621 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 16 June 2016
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! What happened?
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we released. Free as in beer, so go get it.
Why use SQL Search?
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long list of new features and enhancements included with SQL Server Reporting Services 2016. The webinar has been recording and I’ve uploaded it to YouTube for your viewing pleasure.
If you’d… Read more
In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual. The Hexbin Scatterplot is a variation of the traditional Scatter Chart but instead of using bubble size it relies on color saturation and hexbins to show value distribution. You should consider using this chart… Read more
When working with a variety of instances, you can often deal with variances in configuration that might impact the performance. Without digging into each instance you wouldn't know immediately that this had happened. There are fantastic tools, like Brent Ozar's SP_Blitz, but this doesn't focus on every single… Read more
In this case, Michael J Swart is hosting this month’s blog party and he asks us to write about something to… Read more
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. The feature I want to talk about has been around for a bit. Not because it’s not part of SQL 2016 but because it’s part of… Read more