SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2016

Power BI Box and Whisker visualization vs. Box Plot chart in SSRS

[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First, it starts from data extraction and then playing around with various visual settings to make those boxes and whiskers to look good.

I assume that sometimes we tend to work…

Read more

0 comments, 1,853 reads

Posted in Data Adventures on 30 April 2016

Big Data architectures

Over the last few years I have been involved in reviewing the architectures of various companies that are building or have built big data solutions.  When I say “big data”, I’m referring to the incorporation of semi-structured data such as sensor data, device data, web logs, and social media.  The… Read more

4 comments, 2,454 reads

Posted in James Serra's Blog on 29 April 2016


When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to learn more. So the other day we had to brain storm on one of the similar issues where the database stored procedure was returning data quickly as compared to the…

Read more

2 comments, 3,030 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 29 April 2016

A New Look & A New Direction

You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you choose. You're on your own, and you know what you know. And you are the guy who'll decide where to go. - Dr. Seuss

The post A New Look &… Read more

10 comments, 353 reads

Posted in WaterOx SQL on 28 April 2016

Power BI Is Finally in the Azure Trust Center

With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security and compliance as it relates to various customer needs. I do a lot of work with financial, energy, and medical customers.… Read more

0 comments, 2,177 reads

Posted in DataOnWheels on 28 April 2016

April MVP – Chris Yates

The April MVP nomination is Chris Yates (B|T).

Chris is one of those individuals that always have a positive outlook on life which infectious.  He hails from Louisville, Kentucky and over the past year I’ve had the pleasure of really  getting to know him.   Chris has a serious passion about… Read more

1 comments, 376 reads

Posted in John Morehouse | Sqlrus.com on 28 April 2016

Dynamic Security in Power BI

UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.

In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this feature to implement… Read more

3 comments, 1,536 reads

Posted in Koen Verbeeck on 28 April 2016

New Pluralsight Course – Understanding and Using Essential Tools in Enterprise Linux 7

My new course “Understanding and Using Essential Tools in Enterprise Linux 7” in now available on Pluralsight here!

This course targets IT professionals that design and maintain RHEL based enterprises. It aligns with RHCSA and RHCE objectives and can be used by both the IT pro learning new skills… Read more

1 comments, 479 reads

Posted in Anthony Nocentino's Blog on 28 April 2016

Red Gate Dependency Tracker - Making Databases Into Moving Art

data structures are art

If anyone thinks that working with complex data structures is boring... I don't know what world they live in. The problem is often that sql tables and data structures are just script files and lists of tables in an object explorer.

However, once you crack open… Read more

0 comments, 379 reads

Posted in SQL Barbarian on 27 April 2016

PowerShell – SQL Databases Backup Status Report of Multiple Servers


This post is a requirement from one of my blog reader.

There are plenty of scripts available to get the backup status of the databases across multiple server. The  requirement is to read a server name and application names from an input file. The server name is used for… Read more

10 comments, 545 reads

Posted in PowerSQL By Prashanth Jayaram on 27 April 2016

Customizing Your Azure Portal

Not all of us are going to use Azure in the same way. That’s just common sense. Therefore, not all of us are going to want it to look the same. Here’s a default view of the portal for a login I created within my own domain:

You can contrast… Read more

0 comments, 1,276 reads

Posted in The Scary DBA on 27 April 2016

My Cable Modem Keeps Rebooting!

There are obviously quite a few things that could cause internet issues that are totally out of our control, but there are some things that we may be able to try to help ourselves. Face it, dealing with cable service calls is right up there with doing your taxes. If… Read more

0 comments, 372 reads

Posted in cjsommer.com on 27 April 2016

Certificates, Proxies and Jobs! Oh My!

Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need them to have specific file level permissions! What do I do! I know I need to run my job/job step as a specific AD/Windows user but I don’t see how… Read more

2 comments, 1,867 reads

Posted in SQLStudies on 27 April 2016

PolyBase: I now Pronounce you SQL and Hadoop

  Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called PolyBase.  To summarize what it is, just think about it as a marriage between SQL Server and Hadoop.  It is a way to store and query data on…

Read more

4 comments, 510 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 27 April 2016

My Cable Modem Keeps Rebooting!

There are obviously quite a few things that could cause internet issues that are totally out of our control, but there are some things that we may be able to try to help ourselves. Face it, dealing with cable service calls is right up there with doing your taxes. If… Read more

0 comments, 29 reads

Posted in cjsommer.com on 27 April 2016

Columnstore Index Enhancements in SQL Server 2016

One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue developing this technology and make it faster and faster.

In a nutshell, as oppose to what we’re used to today, a Columnstore index keeps our data at the column-level… Read more

0 comments, 3,011 reads

Posted in Matan Yungman on 27 April 2016

Power BI and the Bing Maps API

This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The problem for this very large school district was that they were missing the street… Read more

3 comments, 2,996 reads

Posted in SQL with Dustin Ryan on 26 April 2016

MongoDB : How to get Top, Bottom,Middle and Range of records

In MongoDB,the limit() method is used to limit the result set to be returned. You can also use this with various methods such as sort() and skip() for various combination of requirement.

The MS SQL equivalent is TOP function


Some examples are

Top ‘N’Record

Read more

0 comments, 1,262 reads

Posted in PowerSQL By Prashanth Jayaram on 26 April 2016

Upcoming conferences

It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy an English summer.


The InsideSQL conference is a new conference organised by Neil Hambly. It’s a deep-dive conference, with longer… Read more

1 comments, 413 reads

Posted in SQL In The Wild on 26 April 2016

Interview with Warwick Rudd


Part of traveling to various events and being a part of the SQL Community means one can meet some pretty awesome professionals. I was fortunate enough to run into Warwick Rudd (B|T) at one of the PASS Summit events held in Seattle, and he definitely… Read more

0 comments, 817 reads

Posted in The SQL Professor on 26 April 2016

Older posts