Tag: Microsoft SQL Server

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 >

Capturing SQL Server IO Latencies for a Period of Time with PowerShell

Today’s blog post is a demonstration of the PowerShell approach to Paul Randal’s recent blog post, Capturing IO Latencies for a Period of Time. Since wait statistics were properly implemented in SQL Server, it turned into a powerful resource to diagnose and troubleshoot…

Read More >

Watch: The Most Underrated Features of SQL Server 2014 — Part 3

Since its release back in April, SQL Server experts across the globe are becoming familiar with the top features in Microsoft SQL Server 2014—the In-Memory OLTP engine, the AlwaysOn enhancements, and more. But we couldn’t help but notice that there…

Read More >

Watch: The Most Underrated Features of SQL Server 2014 — Part 2

Since its release back in April, SQL Server experts across the globe are becoming familiar with the top features in Microsoft SQL Server 2014—the In-Memory OLTP engine, the AlwaysOn enhancements, and more. But we couldn’t help but notice that there…

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