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?

[2016-Aug-31] Someone said a picture is worth a thousand words and this is true that in most cases a visual representation of a fact is absorbed better compared with a verbal or textual version of it.  However sometimes just looking at a “picture” or analytical report it also would be…

Read more

0 comments, 62 reads

Posted in Data Adventures on 31 August 2016

This Week in Data – Episode 2 (How to Ask for Help)

Welcome back to another episode of This Week In Data! In our first episode, Adam and Devin debated the value of certifications. In this week’s episode, we’re discussing the right way to ask for help.

For some, knowing when and how to ask for help can be a major… Read more

0 comments, 60 reads

Posted in Devin Knight on 31 August 2016

ForumSurfer – a RSS reader for the SQL Server online community

Today I published the first release of ForumSurfer, a RSS reader designed explicitly to be a tool for the SQL Server online community.

Here is a screenshot:

ForumSurfer has some unique features that will help you help others online:

  • it is designed to help you keep an eye on…

Read more

0 comments, 66 reads

Posted in SpaghettiDBA on 31 August 2016

Filtering Objects with DLM Dashboard

I’ve been looking at some of the features of DLM Dashboard as I go through work building database development pipelines. In this post I wanted to cover one of the lesser used features, filtering objects.

Why would you filter objects if you’re auditing changes? Well, this isn’t really an audit… Read more

0 comments, 102 reads

Posted in The Voice of the DBA on 31 August 2016

How to solve the LSN mismatch in SQL server

 

There are many times, we face the LSN mismatch issue in alwaysON and other HA technologies. It is a bit hard to find the missing transaction log backup to apply. Since, there are hundreds of thousands log generated, depends on the transaction log frequency and it can be run… Read more

1 comments, 51 reads

Posted in SQL Server Blog Forum on 31 August 2016

Organizing a SQL Saturday – Part 2 – The Team - Syndication – WaterOx Consulting

A lot of these types of events are pulled together by the local user group. If there is none, it is a great resource to spawn a group afterwards. Regardless, it helps to get a team together to get things underway. The trick is how you build the team and…

Read more

0 comments, 67 reads

Posted in WaterOx SQL on 31 August 2016

The new Data Migration Assistant has been released!

Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released.

First things first the DMA is a replacement of the Upgrade Adviser. In fact it’s an upgrade of the Upgrade Adviser. It has some amazing new features.

  • You can install…

Read more

2 comments, 56 reads

Posted in SQLStudies on 31 August 2016

Finding out Who’s Touching Your Database at DevConnections

I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready to deliver it.

Earlier this year, with all the security… Read more

0 comments, 153 reads

Posted in The Voice of the DBA on 30 August 2016

Benchmark Azure SQL Database Wait Stats

Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database.  In the past, I blogged about how you should benchmark wait stats with the box product.  This process will give you misleading data in Azure SQL Database.  You will want to focus… Read more

0 comments, 106 reads

Posted in John Sterrett on 30 August 2016

Events By Feature

Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.

With all of this change occurring within SQL Server, sometimes… Read more

0 comments, 102 reads

Posted in SQL RNNR on 30 August 2016

Power BI Custom Visuals Class (Module 14 – Tornado)

In this module you will learn how to use the Tornado Power BI Custom Visual.  The Tornado allows you to compare two categories of data vertically similar to a bar chart.

Module 14 – Tornado

Downloads

Read more

0 comments, 114 reads

Posted in Devin Knight on 29 August 2016

Conference speakers: Why do you teach at events?

I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at events where there’s no compensation. I know more or less why I do this, but I’ll hold off on my answer. I want to hear about you. #SQLSaturday and…

Read more

0 comments, 164 reads

Posted in SQL Awesomesauce on 29 August 2016

Azure SQL Data Warehouse Execution Plans

Azure SQL Data Warehouse can sometimes feel like it’s completely different from SQL Server, but under the covers, it is still (mostly) SQL Server and it does have execution plans. Let’s take a look at one.

I’ve created a new SQL Data Warehouse using the sample database available on the… Read more

4 comments, 105 reads

Posted in The Scary DBA on 29 August 2016

SQL Azure, Hekaton, and Bob Dorr is Awesome

Hello Dear Reader!  I had recently written a blog for the PFE blog, "How Many Tables Can I Have In SQL Azure DB & SQL Server".   It was a fun blog that I had written during a very long layover when traveling home.  It covers the maximum…

Read more

0 comments, 81 reads

Posted in SQLBalls on 29 August 2016

Using Extended Events to Visualize Availability Group Replication Internals

SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release. This isn’t just a collection of bug fixes…there’s some serious value in this Service Pack. Check out the full list here. One of the key… Read more

0 comments, 103 reads

Posted in Anthony Nocentino's Blog on 29 August 2016

Natural vs Artificial Primary Keys

There has been a long standing debate over the use of a natural primary key vs an artificial one. I thought I would throw in my two cents.

First of all why is it important? The primary key is used for two major purposes.

Uniqueness

The primary key is one… Read more

2 comments, 93 reads

Posted in SQLStudies on 29 August 2016

Making Start-Demo work with multi-line commands without a backtick

I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the PowerShell Conference in Hanover I started to make use of it in my presentations.

Start-Demo was written in 2007 by a fella who knows PowerShell pretty well :-)  https://blogs.msdn.microsoft.com/powershell/2007/03/03/start-demo-help-doing-demos-using-powershell/

It… Read more

0 comments, 108 reads

Posted in SQL DBA With A Beard on 29 August 2016

Remote Desktop Workflow Improvements

Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that provided a better workflow than the default Microsoft tools. This one came out as the winner by far.

A better remote…

Read more

0 comments, 25 reads

Posted in SQL Barbarian on 29 August 2016

CISL 1.3.1 is released

I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live! Do not get confused by the small incremental of the build version – this release is something that anyone should…

Read more

0 comments, 139 reads

Posted in Niko's blog on 28 August 2016

Is a CTE really worth it?

If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d be Mark Cuban. With that said I thought it would be a good idea to ask if a CTE was actually the right solution or if it’s just the… Read more

0 comments, 182 reads

Posted in Confessions of a Microsoft Addict on 27 August 2016

Older posts