Expert Insights

blog

SQL Server


“Concurrency” (ha no, not our company!) and Locks in SQL Server

SQL Server needs to be able to manage data with many different transactions happening that are reading, updating, inserting, and deleting.  Whenever SQL looks at data, it needs to put a lock on the record or object to maintain data integrity and allow stable “concurrency” while the database is being used.  There are several different locks that can be put on several fundamental different objects within SQL Server.  Let’s look at them.

Nick Adams by Nick Adams

Exploring SQL Server Metrics in Power BI

This blog is aimed at IT/Database folks to show you how you can leverage Power BI when analyzing databases and environments for problem areas or performance issues. This exercise presents an alternative to rows and rows of data, and gives some tools/ideas to create a quick report and make it repeatable across environments when analyzing SQL Server metrics.      

Seth Bauer by Seth Bauer