Improve Deployment Speed and Reduce Overhead with Containers in Windows Server 2016

Learn how containers work in Windows Server 2016 and how they can be used to increase deployment speed, workload density and decrease server overhead to create a more efficient IT environment.  Workload candidates and security options are also discussed to help you understand how containers may best fit in your server environment. Finally watch a…


Tři nejčastější chyby v licencích pro SQL Server

I když se za posledních několik let podstata licenčních podmínek pro Microsoft SQL Server téměř nezměnila, setkáváme se často s neporozuměním nebo chybným výkladem. Proto se v následujících několika odstavcích pokusíme shrnout typické chyby a omyly, které se stále opakují. Pozor na nepřímé přístupy Pořídili jste licenci SQL Serveru a podle počtu přistupujících uživatelů nebo zařízení jste pořídili i odpovídající počet licencí User…


[Script Of Mar. 24] Determining which version and edition of SQL Server Database Engine is running

Mar. 24 Script Download: The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/Determining-which-version-af0f16f6. The sample code demonstrates how to determine the version and edition of SQL Server Database Engine that is running by SQL Script.. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery


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…


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…


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…


[Script Of Mar. 2] How to export SQL Server bacpac backup file by PowerShell

Mar 2 Script Download: The script is available for download from https://gallery.technet.microsoft.com/How-to-export-SQL-Server-10452c4e. The sample code demonstrates how to export SQL Server bacpac backup file by PowerShell. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery


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