Tag: sql server

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

SQL-Server-Upgrade-ignore

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 >

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

  The show goes on. This Log Buffer Edition picks some blogs which are discussing new and old features of Oracle, SQL Server and MySQL.

Read More >
Page 2 of 612345...Last Page »