Latest Blog Posts
Tldr: A bit of a rant. I’m not spending a bunch of time crafting this.
I have mixed feelings about searching for information on Microsoft sites. It kind of works, kind of doesn’t. I know that there are resource constraints to upgrading their sites, but I’m more and more annoyed. Read more
I’ve been working with ReadyRoll quite a bit the last few months, and wanted to start putting out some information. I’m looking to do a longer series, but here’s a quick post on getting started.
When you install ReadyRoll, you get a new project type under SQL Server.
This is… Read more
This past week, Microsoft revealed that SQL Server 2016 will be available in June. Exciting news indeed! With that said, I thought I’d take a few moments to point out some neat new features housed in SQL Server 2016 Setup.
As you can see from the following image, SQL… Read more
In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server and discuss various techniques to protect against one. Brute force attacks are nothing new. They have been around for a long time and are very simplistic by design. The recent… Read more
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. In particular the way it works.
It seems like it was just yesterday that we all said goodbye in Seattle at last year’s PASS Summit, but the calendar on the wall says that the next event is a mere four months away. This means that it’s that time of year again: the schedule of sessions has… Read more
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.
- SQL Server Service Broker – Introduction
- SQL Server Service Broker – Service Architecture
- SQL Server Service Broker –…
In this module you will learn how to use the Radar Chart, a Power BI Custom Visual. The Radar Chart is sometimes is also know to some as a web chart, spider chart, or star chart. Using the Radar Chart allows you to display multiple categories of data on each… Read more
I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built a few presentations on them. In learning about them, and trying to understand them, I found some challenges, and it took some experimentation to actually understand how the functions work… Read more
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working with Microsoft’s Azure platform and using one of the free credit options. I get a free $25 a month for a year and fortunately for me this put a… Read more
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, 240 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