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

Latest Blog Posts

Power BI Custom Visuals Class (Module 09 – Chord)

In this module you will learn how to use the Chord Power BI Custom Visual.  Chord diagrams show directed relationships among a group of entities using colored lines (chords); this allows for an easy representation of correlating data.

Module 09 – Chord


  • Power BI Custom Visual – Chord
  • Dataset…

Read more

0 comments, 37 reads

Posted in Devin Knight on 25 July 2016

SQL Server 2016 FK operator bug?

I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016. One of the topics covered was a new operator for foreign key checks.

This new operator certainly looked like it simplified the graphical plan considerably; so, I thought I’d test… Read more

0 comments, 90 reads

Posted in Confessions of a Microsoft Addict on 25 July 2016

Deploying Row Level Security with SQL Compare

Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for some time, but we now have it on premise. It’s easy to setup and use, and worth taking a look at if you have multi-tenant scenarios, or need more granular… Read more

0 comments, 90 reads

Posted in The Voice of the DBA on 25 July 2016

Monitor Query Performance

Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.

Sooner or later when you’re working with SQL Server, someone is going to complain that the server is slow. I already pointed out the first place you should look when this… Read more

1 comments, 51 reads

Posted in The Scary DBA on 25 July 2016

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out trying to build an on-line resume (just in case) and over time it’s evolved like crazy. I’ve become a huge proponent of blogging and… Read more

2 comments, 45 reads

Posted in SQLStudies on 25 July 2016

Fourth Week in July

This is the fourth week of four of my July training programming and this week we have two courses that I am involved in

Tomorrow 26th July I will be teaching a one day course titled Writing SQL Queries. This course provides and introduction to writing queries, using…

Read more

0 comments, 44 reads

Posted in The SQL DBA in the UK on 25 July 2016

Speaking at SQL Server Geeks Annual Summit 2016

I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual Summit 2016 to be held in Bangalore from Aug 11 to 13th. SQL Server Geeks Annual Summit is the biggest Technical conference in Asia with 60+ speakers from across the…

Read more

0 comments, 69 reads

Posted in SQL and SQL Only on 25 July 2016

Learn About SQL Server Master Data Services 2016

SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have been added to improve its performance. It helps the database administrators to manage the database properly. In the following discussion, we will be discussing the changes that have taken place… Read more

Happy Birthday Power BI!

Today marks one years since Power BI was officially released.  It’s been an amazing ride and I’d like to thank the team at Microsoft for so responsive to the community’s feedback.  Check out this video the community created to celebrate! 

Read more

0 comments, 100 reads

Posted in Devin Knight on 24 July 2016

CISL 1.3.0 is released

I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL – Columnstore Indexes Scripts Library is finally public – the 1.3.0 version. The most important part of this release is…

Read more

0 comments, 117 reads

Posted in Niko's blog on 24 July 2016

Happy Birthday Power BI

Well today marks the one year anniversary since the initial release of Power BI.  We all have watched this product mature from a small infant to what we see today in an amazing Business Intelligence solution.  To the Power BI product team and those that support the product keep up… Read more

0 comments, 89 reads

Posted in SQLDownSouth on 24 July 2016

Happy Birthday Power BI

Today marks the first anniversary of Power BI Desktop and the Power BI Service.  The effort to achieve this milestone and the on-going commitment of the teams responsible for this product is nothing short of phenomenal.  Earlier this week, I reached out to a few friends to join me in…

Read more

1 comments, 62 reads

Posted in SQL Server BI Blog on 24 July 2016

I’m speaking at the first ever SQL Saturday San Antonio on 8/13/16!

San Antonio is such a great city with a lot to see and do, such as the Alamo and the river walk. I’m excited to be speaking at their very first SQL Saturday!!

My session is on troubleshooting and monitoring storage, including SAN, flash, and in Azure. If you ever… Read more

0 comments, 103 reads

Posted in Confessions of a Microsoft Addict on 23 July 2016

Thank You SQL Saturday Sioux Falls!

I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls.  The audience was great with some multiple questions and follow-ups, so it was awesome!

The sessions have been informative and the event team has done a wonderful job with all of…

Read more

0 comments, 70 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 July 2016

Speaking at DevConnections 2016

I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year… Read more

0 comments, 108 reads

Posted in Tim Mitchell on 22 July 2016

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)

Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along with key observations which DBA should verify and share with IT stakeholders for increasing transparency and improved efficiency

Read more

0 comments, 103 reads

Posted in SQLFeatures on 22 July 2016

What’s Database Drift?

The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this was a problem when implementing continuous delivery and DLM Dashboard Read more

1 comments, 186 reads

Posted in The Voice of the DBA on 22 July 2016

Overview of Published Articles – 2016Q2

Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:

Read more

0 comments, 141 reads

Posted in Koen Verbeeck on 22 July 2016

Day 3: Agile Fundamentals: Scrum, Kanban, Lean and XP

It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum, Kanban, Lean and XP After the pre-course meeting with Alan O'Callaghan on Tuesday evening and sitting through Day1 and Day 2 this is turning into an interesting week for me and…

Read more

0 comments, 108 reads

Posted in The SQL DBA in the UK on 22 July 2016

Another Query to Help Find the Right Event

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will share another means to quickly explore the… Read more

0 comments, 237 reads

Posted in SQL RNNR on 21 July 2016

Older posts