×

TSQL Tuesday #88 -Communication is the Key

March 14, 2017

I thank Kennie Nybo Pontoppidan (b|t) for hosting TSQL Tuesday #88. The topic for this month is the daily database-related WT……. Last week I was setting up a collection of wait statistics with five minutes interval using a while loop. I was wrapping up Paul Randal’s (b|t) code from this blog post in a loop […]

View Multiple System Health Extended Event Files

March 10, 2017

Last week I blogged about increasing retention of System Health session files. In this post I will show how you can open multiple files at once and work with the data as one set. If you select multiple System Health extended event files (with extension .xel) and click open each file will open in separate […]

SQL Server system_health Session Retention

March 3, 2017

As per Microsoft’s books online The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server Database Engine starts, and runs without any noticeable performance effects. The session collects system data that you can use to help troubleshoot performance issues in the […]

SQL Server Fullscan Statistics Being Overwritten with Sample Statistics

March 3, 2017

I observed this behavior only in the following version of SQL Server while using Always On Availability Group feature. Version: Microsoft SQL Server 2012 (SP3) (KB3072779) – 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 9600: ) In this article by David Barbarin […]

How to migrate a SQL database to Microsoft Azure SQL V12

March 2, 2017

This is a session about migrating on premise SQL database to Microsoft Azure SQL V12. I present the session to following user groups. North Boston Azure Cloud User Group on February 28, 2017. Capital Area SQL Server User Group, Albany, NY on May 9, 2017. Pass DBA Virtual Chapter on April 12, 2017 SQL Saturday […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Check out this awesome lineup of #speakers for #COVID19 fundraiser Lightup Virtual Conference! Register now: ... https://2020twenty.net/lightup/ cc @thetechplatform @mitul_rana @jpomfret @SQLStad @SqlWorldWide @yashkamdar391 @PabloJavier911 @darkicebeam @PabloDiLoreto

Folks, I'm excited to speak at the #LightUp conference next week, it's 24 hours of fun. You can catch my dbatools ... session on Wednesday morning (4am EDT, 9am BST)

I'm super thrilled & honored that my "Notebooks 101 for SQL People session" has been selected as part of UNICEF ... #COVID19 #Lightup fundraising event. Tune in on July 14 at 9PM EDT. Register & donate: https://events.unicefusa.org/event/lightup2020 🙏
Check out the schedule here:
https://www.2020twenty.net/lightup/

Load More...