Latest Blog Posts
In this module, you will learn how to use the Advanced Time Slicer Power BI Custom Visual. The Advanced Time Slicer gives you the capabilities of a line chart but with an easy-to-use filtering feature for zooming into desired focus areas.
Module 21 – Advanced Time Slicer
- Power BI…
Can’t make it to the #SQLSummit? I know EXACTLY how you feel. Maybe not at the depths or level of understanding as I think I can. Allow me to share some of what I have experienced. I’ll save some specific details for another story.
I have only been to the… Read more
I am proud to present that Deji Akomolafe from VMware Corporation, Cody Chapman from our team at Heraflux, and I will be presenting at this year’s USENIX LISA16 conference in Boston, MA, from December 4-9th!
On Thursday night, Oct 27, 2016, Andy Warren and I are hosting a game night event at the Washington State Convention Center. This is a low-key, alternative fun event for those of you that might not be attending another party elsewhere.
I read all the time how SELECT * hurts performance. I even see where people have said that you just have to supply a column list instead of SELECT * to get a performance improvement. Let’s test it, because I think this is bunkum.
I have here two… Read more
A couple of years ago I blogged about Installing the SQL Server 2014 Language Reference Help from disk.
With SQL Server 2016 things changed significantly: we have the new Help Viewer 2.2, which is shipped with the Management Studio setup kit.
However, despite all the changes in the way… Read more
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece of code. But a much faster way to get a simple template is to use a snippet. With a simple key command (ctrl-K, ctrl-X) you can… Read more
I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of our production databases. It’s a neat feature that honestly adds a boat load of possibility around logging.
In my testing I noticed that user created tables seem to store the… Read more
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. :-) This is definitely not the intended usage. As I've explored the benefits of using this a little more, I put a few notes together to help share the concepts I came across.… Read more
So, SQL SERVER 2016 introduce this two awesome functions for Compress & Decompress the data.
In our development many times it happens that we need to drop a…
A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of the new level 1200 compatibility model. But they weren’t yet ready to upgrade their SSIS server from SQL 2014. This presented a problem because they had been using the Analysis… Read more
This year PASS announced that Thursday night would be an open night at the PASS Summit, with no events scheduled. Typically Microsoft has sponsored a party at Gameworks, but not this year. PASS has a list of events at the Summit, if you want to browse. Many of these… Read more
The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was very nice meeting up with the #sqlfamily again. I had a session about the new features in SSRS 2016. I was so excited that I could do a… Read more
Many times, while working on SQL Server, the transaction log files frequently grow due to various reasons. Out of which, one such reason is that there is, already existing assigned space of the file in the SQL Server. This can be happened due to increment in the utilization of… Read more