Tag: Microsoft SQL Server

SQL On The Edge #4 – SQL 2016 Stretch Database

  As the Microsoft SQL Server team continues to build very interesting integrations between the full SQL Server box product we all know and the Azure cloud platform. Stretch database is another integration that will be included as part of SQL…

Read More >

SQL On The Edge #3 – Azure Elastic Database Jobs

Hello and welcome to episode number three of SQL On the Edge! In this episode we’re going to cover Azure SQL elastic database jobs. In the last few months, Microsoft has put a lot of effort in augmenting the elastic…

Read More >

Windows Containers: Installing SQL Server

This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server in a Windows Container. Introduction As many of you have heard, Microsoft is jumping into containers with native support for…

Read More >

VMware Debuts SQL Server DBaaS Platform

Yesterday at VMworld, VMware announced its entry into the managed database platform market with the introduction of vCloud Air SQL. This new service is an on-demand, managed service offering of Microsoft SQL Server. It’s meant to further the adoption of…

Read More >

Power BI General Availability

In the last months I’ve been keeping an eye on the Power BI Preview, the new version of the Power BI cloud solution that was completely revamped compared to the first Power BI v1. This last Friday, July 24th, Power BI…

Read More >

PowerShell Script to Manipulate SQL Server Backup Files

Scenario I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:\SQLBackup\ If you are familiar with Ola’s backup scripts, you know the…

Read More >

SQL Server 2012 SP2 Cummulative Update 5

Hey folks, Microsoft released the 5th Cummulative Update for SQL Server 2012 SP2. This update package contains fixes for 27 different issues, distributed as follows:     One very important issue that was fixed on this CU release was KB3038943 –   Error 4360…

Read More >

SQL Server 2014 Cumulative Update 6

Hello everyone, Just a quick note to let you know that this week, while most of North America was enjoying a break, Microsoft released the 6th cumulative update for SQL Server 2014. This update contains fixes for 64 different issues,…

Read More >

A (BIG) Trick Listing Windows Updates Using PowerShell

If you (like me) are using Microsoft.Update.Session for listing the installed windows updates, you might be surprised about something I spent a lot of time today. Our dream team here is deploying a very cool project for a client where we automated…

Read More >

Challenge Me! Capturing SQL Server Data with PowerShell

Hello PowerShell lovers! If you are reading this blog post, then you are likely interested in attending my extended session at SQLBITS SUPERHEROES ( Honored to be selected) Any data professional who is responsible for performance tuning, has their way of…

Read More >
Page 2 of 5012345...10...Last Page »