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

Latest Blog Posts

T-SQL Tuesday #83–The Same Old Issues

This month is an interesting T-SQL Tuesday topic, and it’s brought to us by Andy Mallon, with the topic of the same old issues we’re still dealing with. I think that’s an interesting issue, since I do find myself answering the same old questions over and over.

If… Read more

0 comments, 154 reads

Posted in The Voice of the DBA on 11 October 2016

The Free-Con Returns to Seattle

On Monday, October 24, 2016, there will be a Free-Con in Seattle for those that might not be attending a pre-con before the Pass Summit. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day.

Register now to come. Read more

0 comments, 127 reads

Posted in The Voice of the DBA on 11 October 2016

Off-topic: If you’re in Texas and 18+ yrs old

Today is the last day to register to vote in Texas. I’m not sure about other states in the US but I’m sure the time is almost up.

Check to see if you’re registered here:

This site also has information about registering. You’ll never see anything from me about… Read more

0 comments, 80 reads

Posted in Confessions of a Microsoft Addict on 11 October 2016

Pre-Summit PASS Board Update

Busy, busy, busy.

A lot of the work around PASS currently is getting ready for Summit. I’m prepping my part in the keynotes. I’m involved in lots of community discussions including SQLSaturday, Chapters and Regional Mentors. We’re setting up the Community Zone for all sorts of activities throughout the week.… Read more

0 comments, 75 reads

Posted in The Scary DBA on 11 October 2016

Fight harassment: be the “Backup” at PASS Summit

Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and volunteers, can do to help? There should be a better way to ask others for help, and there should be a better way to show that you are willing to… Read more

3 comments, 119 reads

Posted in SQL Awesomesauce on 11 October 2016

PASS Summit Advice For First Timers

As I scrolled through the twitter feeds I ran across one from Tom LaRock (b|t) on PASS Summit being three weeks away:

Now, what caught my eye was the fact that he mentions the word “advice” to first timers. It wasn’t that long ago when I… Read more

2 comments, 73 reads

Posted in The SQL Professor on 11 October 2016

If backups are taken in silence can a recovery still take place?

My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a blog party started by Adam Machanic (b/t) almost 7 years ago. Each month someone selects a topic and hosts the “party”. Then… Read more

3 comments, 79 reads

Posted in SQLStudies on 11 October 2016

TSQL Tuesday #83 – The Stats update solution

TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic. This week’s TSQL Tuesday is hosted by Andy Mallon – the topic is ‘We’re dealing with the same problem’. I have chosen to write about a common problem… Read more

0 comments, 84 reads

Posted in Mala's Data Blog on 11 October 2016

9 Amazing features of SQL SERVER 2016

Although, I know I am bit late to share this thing on our blog but it says in Indian proverb “Der aai durust aai” means it’s OK you came late but you came that is more important.
Anyways, so you all might aware that Microsoft launched SQL SERVER 2016 officially…

Read more

2 comments, 191 reads

Posted in Rajat Jaiswal-337252 on 11 October 2016

Implementing Fuzzy Sets in SQL Server, Part 4: From Fuzzy Unions to Fuzzy Logic

By Steve Bolton

…………Fuzzy set relations carry an added layer of complexity not seen in ordinary “crisp” sets, due to the need to derive new grades for membership in the resultset from the scores in the original sets. As I explained two weeks ago in this series of amateur… Read more

0 comments, 117 reads

Posted in Multidimensional Mayhem on 10 October 2016

SSC Editorial: Does Log Data Belong in a Table or a File?

I think the topic of whether log data belongs in a table or a file would be a great one for a debate format. I think its one of my better editorial efforts because most people will already have an opinion on which is correct/better and will be curious to… Read more

0 comments, 99 reads

Posted in SQLAndy on 10 October 2016

SSC Editorial: A Visit to Microsoft

A Visit to Microsoft was posted back in August and I just re-read it. Here’s a quote that might interest you:

As a working DBA I heard two things that seemed very positive (not counting the new features and improvements of course). One was that Microsoft sees the ability to…

Read more

0 comments, 98 reads

Posted in SQLAndy on 10 October 2016

Statistics Are Vital For Query Performance

This is post #10 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.

When you send a query to your SQL Server database (and this applies to Azure SQL Database, APS, and Azure SQL Data Warehouse), that query is going to go through… Read more

0 comments, 1,329 reads

Posted in The Scary DBA on 10 October 2016

Columnstore Indexes – part 87 (“Indexed Views”)

Continuation from the previous 86 parts, the whole series can be found at A very long time desired feature from my side was something that I have described in the Connect Item – allowing calculation measures on the row…

Read more

1 comments, 131 reads

Posted in Niko's blog on 10 October 2016

Special Discount for PASS Summit Precon

I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th.I have a special discount code for you if you have not already registered for this outstanding conference. Please use the discount code PRE250DK for $250 off of… Read more

0 comments, 354 reads

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

Monday Night Networking at Summit 2016

It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.

For those of you that haven’t come in the past, Andy and I aren’t buying you dinner. What we are doing is setting up a time and location for people to come…

Read more

2 comments, 121 reads

Posted in The Voice of the DBA on 10 October 2016

Power BI Custom Visuals Class (Module 20 – Word Cloud)

In this module you will learn how to use the Word Cloud Power BI Custom Visual.  The Word Cloud is often used for mining large amounts of text data to determine the number of time certain words are used.

Module 20 – Word Cloud


  • Power BI Custom Visual –…

Read more

0 comments, 906 reads

Posted in Devin Knight on 10 October 2016

Making the case for CamelCase naming

Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting stuck between any combination of the right and left or those that don’t care can be entertaining and sometimes outright dangerous.

The HBO show Silicon Valley has a whole episode… Read more

10 comments, 2,160 reads

Posted in Confessions of a Microsoft Addict on 10 October 2016

Migrating Database Collation - The Red Gate Way

I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects that I would have had to drop and recreate was a bit daunting, so I looked for a way to migrate the database to a different collation.

Using the Red… Read more

0 comments, 68 reads

Posted in SQL Barbarian on 10 October 2016

Mastering Index – Nonclustered Index

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

Read more

0 comments, 136 reads

Posted in Help on MSBI on 10 October 2016

Newer posts

Older posts