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…

0

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…


SQL Server 2016 new features to deal with the new CE

It is no news that SQL Server 2014 changed the Cardinality Estimator (CE). Ok. Even if it is not something new: What means CE? What is the impact of the new CE? And most important what SQL server 2016 propose to deal with it? The idea of this post is to answer those kind questions and give…


Report on your consolidated Data Migration Assistant Assessments With PowerBI

In a previous post How to consolidate Assessment Reports we looked at a method to consolidate the JSON output files from the DmaCmd.exe command line tool into SQL Server. Now lets look at a method to put some basic reports on top of that data. For this we will use PowerBi which you can download…

0

Oh it’s that time again ! – SQLBits!

It’s almost that time again!  Christmas day for data professionals! SQLBits !!!   Hopefully a lot of readers will have heard of the SQLBits conference that runs every year in the UK, but if you haven’t then suffice to say it’s the largest Data conference in Europe and we are sending some of the team…

0

xp_cmdshell – Naming, Shaming and Taming

I think most people dealing with SQL Server understand that xp_cmdshell can be a bit of a security hole if not used correctly. But… how do you know it is being used appropriately? Wouldn’t it be a nice feature to be able to see exactly who is using xp_cmdshell, when and why? You can with…


How to Consolidate Data Migration Assistant JSON Assessment Reports

Starting from Data Migration Assistant (DMA) v 2.1, DMA provides command-line support for running assessments in unattended mode.  This feature helps to run the assessments at scale.  The command-line version of DMA generates the assessment results in the form of a JSON or CSV file. You can assess multiple databases in a single instantiation of…

1

Query Store: How it works? How to use the new Query Store Catalog Views?

Part 2 /*Fix 2017.03.28: Not Query Store DMVs but Catalog Views. Thanks Kalen Delaney for point it*/ “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. “msdn. If you want to know,…