Instant File Initialization–Do You Know It’s Value?

This weeks post by our US Senior PFE Susan Van Eyck is about the value of using Instant File Initialization. Lets have a look!   Be convinced of it’s value! This week’s Byte is about something the SQL Server world refers to as “Instant File Initialization” or IFI.  Interestingly, it’s not really a SQL Server…

0

Install SQL Server Books Online – Offline

Many of my customers run production environments which have never, and will never, be able to connect directly to the internet. They still have the desire to install Books Online (BOL) into those environments though, which leads up to this blog post – how do we do that? SQL 2012 & SQL 2014 For SQL…


Assess an Enterprise With Data Migration Assistant–Part 4: Report on an Assessment

In my previous post I took you through how to consume the assessment data into the DMAWarehouse. In this post I’ll take you through the PowerBI report to visualize your upgrade / migration readiness.   DMA Reports If you haven’t already downloaded the PowerBI desktop then download it here. Open the DMA Reports PowerBI template…

0

Assess an Enterprise With Data Migration Assistant–Part 3: Loading an Assessment

In my previous post I took you through how to run a scaled assessment using the dmaDataCollector PowerShell function. In this post I’ll take you through how to consume the assessment JSON output using the dmaProcessor PowerShell function.   Consuming the assessment JSON file Once your assessment has finished you are now ready to import…

0

Assess an Enterprise With Data Migration Assistant–Part 2: Running an Assessment

In my previous post I took you through the prerequisites for successfully running a scaled assessment against your SQL Server enterprise. In this post I’ll take you through how to run a scaled assessment using the dmaDataCollector PowerShell script.   Running a scaled assessment Ensure that the PowerShell modules have been loaded into the modules…

0

Assess an Enterprise With Data Migration Assistant–Part 1: Prerequisites

In my previous posts How to Consolidate JSON Assessment Reports and Report on Your Consolidadted Assessments With PowerBI, I show how to run scaled DMA assessments across your estate and report on the results using PowerBI. In the next series of posts I’ll take you through the enhancements to the process, scripts and reports to…

0

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