Author: Warner Chaves

The end of an era – preparing for a SQL Server 2005 upgrade

Extended support for SQL Server 2005 will come to an end April 2016. This webinar provides a live demo on how to plan and perform a SQL Server 2005 upgrade

Read More >

SQL On The Edge #5 – custom visualizations in PowerBi

  Have you ever used Microsoft’s PowerBi service? If you have, have you used it within the last year? The reason I ask is that the current PowerBi service is so radically different from the initial release that pretty much only…

Read More >

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 >

SQL On The Edge #2 – SQL 2016 temporal tables

Hello and welcome to our second episode of SQL On The Edge! On this episode we’re going to focus on a new feature of SQL Server 2016 called Temporal Tables. What’s a Temporal table? Temporal tables allow us to go…

Read More >

SQL On The Edge #1 – 2016 installer

  Hello and welcome to my new video blog (Vlog) series SQL On The Edge! My goal with these videos is to provide short, concise demonstrations of the latest and greatest features regarding SQL Server, Azure SQL Database and other…

Read More >

Log Buffer #120: A Carnival of the Vanities for DBAs

Welcome to Log Buffer #120. My name is Warner, and I’m a SQL Server DBA at The Pythian Group. This is my first time on Log Buffer duties ever, so here’s hoping I can give everyone a fair and unbiased look at this week in the database blogging world (and related).

Read More >

Browsing SQL server 2008’s new DMVs

SQL Server 2008 is out of the bag and—luckily for my team—at Pythian we are already seeing customer interest in upgrading, even from SQL Server 2000 and 2005. There are many new features and there will definitely be more blog posts coming from the team regarding them, but for now, I was just browsing around the new 2008 Dynamic Management Views (DMVs), and did a quick overview of some that spiked my attention:

Read More >

SQL Server COMPILE Locking and Encryption Keys

he morning begins with this page: “a large number of sessions are blocked on one of your managed SQL Server 2005.” So you go and check out the Activity Monitor, and you can tell something unusual is going on. Knowing the procedure, it’s then a matter of discarding possibilities. The common causes of COMPILE locking are well documented on the Microsoft KB, “Description of SQL Server blocking caused by compile locks”, so if you have a chance, go on and read that. If you don’t, then this is the gist of it here.

Read More >
Page 6 of 6« First Page...23456