Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Power BI with Narrative Science: Look Who's Talking (Part 2: Predicting the Future)

[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well known illustration that a human optic nerve is thicker than the auditory one; thus, resulting to more information being consumed by brain with seeing things rather than hearing or listening to…

Read more

0 comments, 121 reads

Posted in Data Adventures on 18 October 2016

Power BI Custom Visuals Class (Module 21 – Advanced Time Slicer)

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…

Read more

0 comments, 128 reads

Posted in Devin Knight on 17 October 2016

To Those Who Cannot Go To #SQLSummit

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

2 comments, 117 reads

Posted in Todd Kleinhans on 17 October 2016

Presenting at USENIX LISA16 in December

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!

The three of us are presenting a half-day workshop entitled “Designing Your VMware… Read more

0 comments, 97 reads

Posted in Technobabble by Klee from @kleegeek on 17 October 2016

Thursday Game Night at PASS Summit

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.

If you’re interested, please purchase a ticket. We… Read more

2 comments, 159 reads

Posted in The Voice of the DBA on 17 October 2016

SELECT * Does Not Hurt Performance

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.

The Test

I have here two… Read more

10 comments, 592 reads

Posted in The Scary DBA on 17 October 2016

Installing SQL Server 2016 Language Reference Help from disk

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

0 comments, 124 reads

Posted in SpaghettiDBA on 17 October 2016

Using Snippets

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

0 comments, 86 reads

Posted in SQLStudies on 17 October 2016

Read this before using SQL 2016 Temporal Tables

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

0 comments, 167 reads

Posted in Confessions of a Microsoft Addict on 17 October 2016

Query Plan's Compile Time Parameter Values

Most of you would know how to get the query plan from the cache via "sys.dm_exec_cached_plans" or "sys.dm_exec_query_stats" DMV or via a "sys.dm_exec_requests" with the plan_handle. But one interesting thing which many not have noticed is the ability to check the "compile time" parameter…

Read more

0 comments, 73 reads

Posted in SQL and SQL Only on 17 October 2016

The dark side of Fn_dump_dblog

I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are consistently dumping the contents into a table for analysis) The below 2 queries shows the current state of my system … Continue reading

Read more

2 comments, 773 reads

Posted in All About SQL on 17 October 2016

Centralized Management Server 101

Registered Servers

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

0 comments, 1,018 reads

Posted in SQL Barbarian on 16 October 2016

Do you know Compress & Decompress function in SQL SERVER 2016 ?

This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware of Gzip Compression algorithm. If not then try  this link.

So, SQL SERVER 2016 introduce this two awesome functions for Compress & Decompress the data.

Read more

2 comments, 126 reads

Posted in Rajat Jaiswal-337252 on 16 October 2016

Here Come New Ideas for DROP IF EXISTS in SQL SERVER

In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a new cool feature which introduced in SQL SERVER 2016 which is DROP IF EXISTS (DIE) .
In our development many times it happens that we need to drop a…

Read more

0 comments, 136 reads

Posted in Rajat Jaiswal-337252 on 15 October 2016

Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014

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

0 comments, 526 reads

Posted in Data Savvy on 14 October 2016

Thursday Night Networking Dinner Meetup at Summit 2016

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

1 comments, 589 reads

Posted in The Voice of the DBA on 14 October 2016

Mastering Index – Unique Index

This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a look at the content of this series -  Mastering Index  One of the most interesting and talked about topic in database field is Index. I am writing this Series…

Read more

0 comments, 214 reads

Posted in Help on MSBI on 14 October 2016

What’s new in SSRS 2016 – Session Contents

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

0 comments, 137 reads

Posted in Koen Verbeeck on 14 October 2016

Control Flow Package Parts in SSIS 2016

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages.  The intent is great, but like with many first iterations, there are limited use cases, and rough edges.  I'll provide an overview of those here, and in…

Read more

4 comments, 1,182 reads

Posted in Todd McDermid's Blog on 14 October 2016

Learn Uses of log_reuse_wait_desc In SQL Server


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

0 comments, 171 reads

Posted in Zora's SQL Tips on 13 October 2016

Newer posts

Older posts