(Ahmad Yaseen) This article will provide an overview of manually creating a SQL Server audit using SQL Server Extended events and triggers. It will provide an overview of SQL tracing/profiling as well as extended events.
Tag: sql server
Azure Automation and PowerShell Runbooks
(John Miner) The Microsoft Azure Cloud contains many different services that you can use as building blocks to solve business problems. For someone new to the Azure ecosystem, how do you combine these services (materials) in the right order to create a secure, highly available, performant, and resi
Planning for Accounts, Containers, and File Systems for Your Data Lake in Azure Storage
(Melissa Coates) Now that Azure Data Lake Storage Gen2 is now based on Azure Storage as its foundation, we have a new level to incorporate into our planning process the file system itself.
Using the Microsoft Authenticator app to log into Azure
(Kenneth Fisher) So I was trying to work on a blog post about the new truncation error this morning and realized I don’t have the version of SQL that I need installed on my machine (SQL 2019).
SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time
(Pinal Dave) One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time.
Use XEvent Profiler to capture queries in SQL Server
(Erin Stellato) In the course of monitoring performance or troubleshooting a problem such as system slowness, it may be necessary to find or capture queries that have high duration, high CPU, or generate significant I/O during execution.
Lonely Tables in SQL Server
(Michael J. Swart) Takeaway: I provide a script that looks at the procedure cache and reports tables that are never joined to other tables.
Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers
(Eli Leiba) I was given the task to write a process to find the greatest common divisor (GCD) of two or more integers. By definition, in mathematics, the greatest common divisor (GCD) of two or more integers, which are not all zero, is the largest positive integer that divides each of the integers.
Thoughts On The New Power Query Source In SSIS
(Chris Webb) Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it (the actual announcement is halfway through):
When Will My SQL Server Online Resumable Index Rebuild or Create Operation Complete?
(Greg Larsen) Have you ever wondered how much progress SQL Server has completed while rebuilding or creating an online resumable index?