Tag: sql server

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

Fahd Mirza, Pythian database expert and Oracle ACE, explains why there is no better way to enjoy the holidays than to kick back and soak in the best of Oracle, MySQL and SQL Server from around the globe! Seriously, where else would you rather be?

Read More >

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

Fahd Mirza, Pythian Database Consultant and Oracle ACE, presents this weeks Log Buffer Edition digging deep into the world of Oracle, SQL Server and MySQL to bring you some of the best blog posts around the web.

Read More >

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 >

Locks, Blocks and Deadlocks – What’s the Difference?

  We are often being paged by development teams talking about locks, blocks or deadlocks and some people make the wrong use of the terms. There is a big difference between the three and it will explained at a high level…

Read More >

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

This Log Buffer Edition covers top Oracle, SQL Server and MySQL blog posts of the week.

Read More >

DATA COLLECTOR AND POLICY-BASED MANAGEMENT: PART 3

  In my previous post I talked about how create and use a policy against your SQL Server Instance (don’t forget to check our part 1 in this series too). Now we will talk about the Data Collector and how configure it on…

Read More >

Data Collector and Policy-Based Management: Part 2

  In my previous post we talked about the architecture of Policy-Based Management. In this post we will create and run a policy against some SQL Server Instances. Creating a Policy In SQL Server 2014 you are allowed to create a…

Read More >

SQL 2016 – Improve Performance with the Query Store feature: Part 1

  After playing with this great new feature for some time and speaking about it during a SQL Saturday in Montreal, I can say that I am very excited about Query Store in SQL 2016! Performance tuning is our bread and butter…

Read More >

Data Collector and Policy-Based Management: Part 1

  This article will address the main techniques for the efficient management of multiple instances in a SQL Server database 2014 using the Tools Data Collector and Policy-Based Management. In addition, it will be demonstrated in a practical way how…

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 >
Page 3 of 812345...Last Page »