On March 16th, I posted (Twitter|LinkedIn) about achieving my first ever Azure Certification. AZ-900 Azure Fundamentals. I understand it is basics, and that is why it is called fundamentals. I had a few people asked me how I prepared as they want to do the same. Here are a few resources I used to prepare: […]
Here is a sample output of XML from sys.dm_os_ring_buffers where WHERE ring_buffer_type = N’RING_BUFFER_SCHEDULER_MONITOR’. What do those XML elements mean? In order to monitor CPU usages, you need to understand what each element means so you can use the values. I will explain each one in this blog post. ProcessUtilization Indicates the amount of CPU SQL […]
PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. SQLSaturday Rochester will be held on Feb 29, 2020, at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623, United States. […]
I thank Jes Pomfret (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Life hacks to make your day easier. 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 […]
With the announcement of Powershell support in Azure Functions, it has become easier for data professionals to use functions to manage cloud resources such as Azure SQL Database, Managed Instances. A common challenge when using functions is how to manage the credentials in function code for authenticating databases. Keeping the credentials secure is an important […]
Lightning Talks! We had them the last time and they are back. We have 10 speakers lined up to cram as much content as ... possible into a 10-minute slot. Find out more at http://www.dataweekender.com and sign up.
SSMS 18.9 had a bug. Fix is out with 18.9.1 ... https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
SQLServerGeeks is conducting a Virtual Symposium on SQL Server and Azure SQL.
Learn from skilled data professionals and... gather critical knowledge on all things SQL.
Calling all SQL database administrators, this session is for you! SQL is everywhere you need it from the IoT Edge to ... your datacenter to public clouds. Learn about these options, which to choose, and why with @BobWardMS on April 28. Register: https://bit.ly/3dffR9z #AzureSQL