×

SQL Server

Azure SQL Database Serverless – Facts!!

October 20, 2020

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview Few […]

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

GO AND DROP YOUR BALLOT IN PERSON OR VOTE IN PERSON.

I dropped mine in person and took 16 days to get recorded.

... #Elections2020

GO AND DROP YOUR BALLOT IN PERSON OR VOTE IN PERSON.

IT TOOK 16 DAYS FOR MINE.

DO NOT LISTEN TO MEDIA!
DO NOT LISTEN ... TO POSTMASTER!

#Elections2020

📣 Public preview: Auditing of Microsoft support operations in Azure SQL DB and #AzureSQL MI. Learn more: ... https://bit.ly/37R75gN

Load More...