SQLSaturday 258, Istanbul Event Recap

This write-up of SQL Saturday in Istanbul was provided by Turgay Sahtiyan, a Senior PFE specializing in SQL Server. Along with the team of PFEs presenting, Turgay was an active participant in planning and organizing this event, and is one of its founders. After SQLSaturday 258, Istanbul event, I would like share an update and…


SQL Saturday in Baton Rouge… is this Saturday!

This post was written by Mike Huguet, Premier Field Engineer. Along with the team of PFEs presenting, Mike was an active participant in planning and organizing this event, and is one of its founders. SQL Saturday is a well-known, regularly scheduled training event for SQL Server professionals, as well as those wanting to learn about…


Microsoft PFE is at SQL Saturday 231!

SQL Saturday is a well-known, regularly scheduled training event for SQL Server professionals and those wanting to learn about SQL Server. This event is run in partnership with the renowned SQL PASS association and features deep technical content from both community champions and speakers from the local Microsoft offices. And where there is a high-quality…


A Quick Look At System Center Advisor (SCA)

Summary:  Milad Aslaner, a Microsoft Premier Field Engineer based in Germany, gives us a quick peek at System Center Advisor (SCA), a freely available cloud-based service from Microsoft that enables you to assess your server configurations and proactively avoid problems. As you probably know by now, my passion is around reliability and performance. I just…


SQL Server Statistics: Charting Volatile Data And Density Vector Values

  Summary: Tony O’Grady, a Microsoft Premier Field Engineer based in the UK, continues with his second post of 5 advanced articles on charting statistical data with SQL Server.  In this post he explores how changes to the underlying data are reflected in cardinality estimations, explores some scenarios, and introduces the concept of density vectors….


The Case For Hosting a ConfigMgr SQL Database on a Dedicated SQL Instance

Summary:  Piotr Gardy, a Microsoft Premier Field Engineer based in Poland, provides us with recommendations on why (and how) a ConfigMgr database should be hosted on its own dedicated SQL Server instance.  For more useful tidbits, please check out Piotr’s Polish language TechNet blog. When you perform following operations with System Center Configuration Manager (a.k.a….


Understanding SQL Server Cardinality Estimations by Charting Histogram to Actual Values

Summary: Tony O’Grady, a Microsoft Premier Field Engineer based in the UK, helps us understand whether or not a SQL dataset is going to produce useful query statistics by looking for patterns in histogram values in comparison to actual values. He introduces SQL Server histograms and explains how SQL Server divides the histogram in ranges…


An easy-to-use dashboard over the SQL Server System Health session

  SQL Server 2008 and above provide an amazing diagnostics capability in the form of the System Health extended events session. However, not everyone knows about it – part of the reasons being that there is not a convenient way to visualize the data collected therein. Our colleagues at the SQL Server PFE Blog, specifically…


SQL Server 2012 AlwaysOn FAQs

Krishna Golla has a grab-bag of SQL Server 2012 AlwaysOn FAQs suitable for DBAs and Infrastructure types, covering everything from the hotfixes recommended for AlwaysOn, to whether Availability Groups can be defined outside a domain boundary. For example, in the Failover Scenarios section: 1. What happens when your primary replica is offline? Which replica does…