Latest Blog Posts
I decided to write a long term review… Read more
If you have followed my blog for the past year or so you may remember when I posted a Power BI workbook I created to analyze the previous season’s NFL player stats to help me with my fantasy football draft. I know, its nerdy, but I like Power BI and… Read more
There is greatness within you whether you believe it or not. Over the years there are certain skills that have helped me along the way that, in turn, may help you along your journey. These traits are by no means written in stone and some will not agree that these… Read more
So, the new industry buzz word is Data Science. Are you a Data Scientist? Do you remember taking that in college? Maybe have a DS (Data Science) Degree? Did you cringe at chemistry? Bomb physics? Snore at geology? Well now you too may already be a "DATA SCIENTIST. Sounds really cool:… Read more
When the word comes around for elections to the PASS Board, are you one of those people who, even in passing, considers running? If you are, my advice is to well, do it.
By the way, here’s that word.
In order to make this a stronger, even more vibrant… Read more
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those aspects (duh) is security. I’m not sure where I found this (probably someone tweeted it) but one MS has put out a document on the subject (again duh) called Microsoft… Read more
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table, truncated a table, dropped a procedure….” etc. Im sure we have all been there, something changes ( maybe schema or data ) and we have no way of telling… Read more
In this module you will learn how to use the Aster Plot Power BI Custom Visual. The Aster Plot is a twist on the standard Pie or Donut Chart. What sets the Aster Plot apart from these visuals is that it has the ability to use a second measure to… Read more
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how to control the deployment, what tool is used to deploy the dacpac, what connection details are passed in, which of the…
In this post we’re going set PowerShell as your default Linux shell.
What is a shell?
In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove almost anything that you want. And one of those options is your shell. The shell is the thing that you… Read more
For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison Power BI User Group. I’m always really excited when someone invites me back a second time to speak because that means that the first time wasn’t completely awful! We had… Read more
I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this is part of the SQL Server on Linux project, where I assume we’ll start to see the functionality that we have on Windows appear on Linux platforms. OSX is a… Read more
In this module you will learn how to use the Bullet Chart Power BI Custom Visual. The Bullet Chart serves as a replacement for poorly designed dashboard gauges and meters you might be using now. Typical gauges do not show very much information and require a lot of space on… Read more
SQL 2016 - New Functionality
These are notes taken from the Houston SQL Pass User group from July. This presentation was given by John Cook, (Data Platform Solution Architect Microsoft) who did a great job with limited time on providing some great details on the new functionality with SQL… Read more
In case you missed it (many did), TSQL Tuesday was a challenging event this month. I invited people to do a put a little more into writing a post than what they may usually do. There were some very good reasons for this. If you are interested, take… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I saw a problem that intrigued me and I… Read more
Getting PowerShell on Linux
Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now from GitHub – here!
Once you’ve downloaded an installation file you can use RPM or apt to install the package. If you’re on a Mac…well just… Read more
We’ve been working on this for a while now and I’m excited to announce the merger of Quanta Intelligence and DawaBI. This merger will deepen and broaden our service offering to provide more value to our customers through knowledge and expertise. With Datalere, you are not just provided a resource,… Read more
Yesterday evening I had the distinct pleasure of presenting at the Jacksonville SQL Server Users Group on some of the new features of SQL Server 2016. We had delicious pizza, lots of great networking, and a lot of fun talking about SQL Server. The group had a ton of great… Read more