×

SQL Server

Replace Trace Flag with ‘USE HINT’

January 23, 2021

Introduced in SQL Server 2016 (13.x) SP1 and Azure SQL Database is the USE HINT option. At the time of writing this article, there are 23 of those. You can see an up to date list by running Dynamic Management View sys.dm_exec_valid_use_hints. With the introduction of this feature, we can replace some of the trace […]

How to Persist Information from Lightweight Query Profiling?

September 14, 2020

Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]

T-SQL Tuesday #130: Automate Trace Flag Consistency

September 8, 2020

I thank Elizabeth Noble (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Automate Your Stress Away. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating this program. If you […]

Stress Test Using sqlcmd Utility

August 17, 2020

I am writing this blog post for my own reference for future. Hopefully someone will be benefited in the process. Recently I was working on upgrading System Center Operations Manager and configuring alert for high CPU. I wanted the alert to trigger if CPU was above a certain percent for x consecutive polls. While simulating […]

Sensitivity Rank in Data Classification

May 27, 2020

Data Discovery & Classification is supported for SQL Server 2012 and later, and can be used with SQL Server Management Studio (SSMS) 17.5 or later. Starting SSMS 18.5, a new feature called ‘sensitivity rank’ was added in Data Classification. I will show details about the sensitivity rank in this blog post. I want to thank David Trigano, Program […]


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...