Self Joins…ROW_NUMBER()…LAG()! … Oh My!

  In this post by our US based Senior PFE, Susan Van Eyck goes through different query patterns to achieve cumulative data while keeping the query performant.  Check it out !   Today’s Byte was inspired by a question from a colleague.  He had a bunch of data from a monitoring system that sampled cumulative…

0

Presenting with SSMS

Whilst presenting at a Microsoft Operations Day in Reading last Tuesday, I was giving a demo on some TSQL using SSMS. In order to ensure that the audience could see the text I naturally turned to ZoomIT until a member of the audience (one of our excellent Microsoft Program Managers – Thanks Pedro Lopes!) shouted…

0

SELECT *, Indexes, Data Access, and the Optimizer!

  Another great “Database Byte” by our US PFE guest writer Susan Van Eyck!  This time on the pitfalls of using SELECT * on huge tables and the effects on the optimizer.   A customer of mine recently had a problem – a legitimate need to use a SELECT * query (mind you, they had…

0

Implicit Conversions – Ouch!

Today we have a guest post from one of our excellent Premier Field Engineers from the United States – Susan Van Eyck. In this post Susan explains the pitfalls of comparing different data types in a where clause and how it can hurt performance.   This post is about implicit conversions, or more accurately, it’s…

0

SQL Server 2017 GA Announced!

Short But Sweet It’s finally been announced! Scott Guthrie and Rohan Kumar announce at Ignite SQL Server 2017 general availability on the 2nd October! Check the post from the SQL Server team here:  https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/microsoft-for-the-modern-data-estate/ Excited?  So are we!  

0

Recover the SSISDB to a New Machine Without a Database Backup

It’s Not Pretty! Imagine your SQL Server instance, which contains your very important SSISDB fails.  You have no backups, or worse, you do have backups but you have been hit by a virus rendering all those backups unusable.  Also, you have no backups of the actual SSIS packages!  Not a great situation to be in…

1

SQL Performance Counters are Missing

There was one time when I was delivering a Service using a tool that gathers performance data through the SQL Server Counters on Performance Monitor, I got surprised when I tried to review the data and there was no information. Then I checked the SQL Server counters directly on Performance Monitor and the counters were…


SQL Azure DW – What is it? How it works?

Azure DW what is it? Is it the same as SQL Azure but bigger? No. It is kind of…different. It is a full Cloud Service from Microsoft in the Microsoft Cloud (PaaS), multi-tenant, cloud-based data warehouse ‘Platform as a Service’ offering which elastically scales on demand. Separates storage and compute for elastic scale requirements regardless…