×

TSQL to Find Status of SQL Server Statistics

March 19, 2017

About two years ago, I was working on an update statistics solution for 15 TB OLTP database.   The first thing I needed to know, is the status of statistics.   With a google search, I landed into this blog post by Erin Stellato (blog | Twitter) from SQLskills. Which gave me a perfect head start. […]

Free Azure Credit

March 16, 2017

There are multiple ways you can get free Azure credit, which can add up to $500 for one year. With a Microsoft account and one of these free credit options you can open an Azure account. You will be able to use this account for any Azure service based on your needs including, Virtual Machines, […]

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 […]


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

Born when world population was just 3.5B, Winston Churchill and Malcolm X were alive, I still find it amazing that I can... sit in W. Europe participate in a Central America tech conference, with speakers from Bangalore, & Boston
@DataSaturdays (Guatemala), @A_Bansal, @sqlworldwide

Thank you to those attending my session this morning at #DataSaturday #Guatemala .
Slides and code is available at:
... https://github.com/sqlworldwide/Presentations/tree/master/The%20magnificent%20seven%20-%20Intelligent%20Query%20processing%20in%20SQL%20Server

#SQLServer
#AzureSQL

update para los links de los salonoes de #datasaturday

AI : ... https://us02web.zoom.us/j/83563966207?pwd=aUM4Z09xK285R05DUzBhNzZtQnhLZz09

Gestion : https://us02web.zoom.us/j/89554677160?pwd=Nks0U05IMEovNVZHMWxIMUpPcW1yZz09

SQL: https://us02web.zoom.us/j/82767681978?pwd=T3RwTUNnOSsxTDNCSEtBUWRhR21Rdz09

Los demas salones se quedan con sus links actuales

Speaking for the First Ever Data Saturday event today 😇 at 11am EST
Please register here for Data Saturday Guatemala:...
https://datasaturdays.com/events/datasaturday0002.html

Load More...