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

Archives: August 2016

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, 542 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, 260 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, 330 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.

Note: DLM Dashboard is a free tool from Redgate Software. Use it to monitor the… Read more

0 comments, 334 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

5 comments, 604 reads

Posted in SQL Server Blog Forum on 31 August 2016

Organizing a SQL Saturday – Part 2 – The Team

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, 268 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

3 comments, 319 reads

Posted in SQLStudies on 31 August 2016

Sql Server - Find and Replace a value across all tables in database

Find and Replace a value across all tables in database In my project I faced this problem due to typing mistakes. End user has entered ‘goodmorning’ and ‘good morning’ interchangeably and it was causing logic failure at application level. So task was to replace ‘goodmorning’ with ‘good morning’ in database…

Read more

0 comments, 117 reads

Posted in Help on MSBI on 31 August 2016

Sql Server - Monitoring the Performance of All Stored Procedures

Monitoring the Performance of All Stored Procedures  Every Project suffer from this problem, over the time they have developed many stored procedure and their versions. No one is actually sure about their utilization and performance. Use this very simple SQL Script and generate a report with all the information you…

Read more

0 comments, 115 reads

Posted in Help on MSBI on 31 August 2016

Sql Server - Monitoring the Performance of All Stored Procedures

Monitoring the Performance of All Stored Procedures  Every Project suffer from this problem, over the time they have developed many stored procedure and their versions. No one is actually sure about their utilization and performance. Use this very simple SQL Script and generate a report with all the information you…

Read more

0 comments, 34 reads

Posted in Help on MSBI 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, 366 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

2 comments, 401 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, 291 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, 409 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

1 comments, 355 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

5 comments, 313 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, 322 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 things… Read more

2 comments, 352 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, 322 reads

Posted in SQLStudies on 29 August 2016

Sql Server - Index Utilization Report

Index Utilization Report One day my manager came and told me that he need Index Utilization Report. He felt that during development of the project we have created so many indexes but he is not sure about how useful those are. So he wants a report which shows all the…

Read more

0 comments, 114 reads

Posted in Help on MSBI on 29 August 2016

Older posts