(Grant Fritchey) I wrote a short blog post about the misperception that Profiler was easier than Extended Events when it came to the core concept of “click, connect, BOOM, too much data”.
Tag: sql server
(Jeremy Kadlec) Between the legislation over the years (HIPAA, GLBA, GDPR, CCPA, etc.) and data breaches from large organizations that seem to pop-up in the news on a monthly basis, SQL Server database encryption is critical for our industry.
(Jason Brimhall) Tracing a query is a common task for a DBA. The methods employed are pretty varied. I seem to encounter a new method here and there throughout my journeys and projects.
(Kenneth Fisher) Conditions are the life blood of programming. This condition is met so now I need to do this task. That condition is met so I need for the program to end. Typically we are going to use parameters or calculate information to be used in the condition, but sometimes we want human input
(Pinal Dave) If you have learned about the new features of SQL Server 2019, you might already know about this feature called “memory-optimized tempdb metadata”.
(Daniel Janik) Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses.
(Ron L’Esteve) The recent hype of AI in the tech industry is digitally disrupting organizational goals while empowering the way we approach business and pleasure in our daily lives.
(Pinal Dave) When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs. In this blog, I would share my learning about logging about SQL Server Agent itself.
(Itzik Ben-Gan) This article is the third installment in a series on NULL complexities. In Part 1 I covered the meaning of the NULL marker and how it behaves in comparisons.
(Thomas LaRock) At SQL Server Live last November, I demonstrated enabling SQL Audit for Azure SQL Database. During the class discussion I explained you must use Powershell to modify SQL Audit for Azure SQL Database. So, that’s my post today, showing you how it is done.