SQL Server authentication methods, logins, and database users
Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.
What is Azure Databricks?
The goal of this article is to illuminate exactly what Azure Databricks is so that you can determine what parts of the platform might make sense to add to your organization's data stack.
New Options for Training and Learning
In 2008, I managed to achieve the goal of becoming a Microsoft Certified Trainer. Once I achieved the status, Microsoft shipped me a binder with dozens of DVDs containing lab VMs and class materials for all the current classes. At some point, instead of receiving DVDs, you were expected to download images which was quite […]
Imposter or Student
We all need to learn and tackle new technology in our career. When we do so, are we impostors or students?
Keep Column Headers Visible in SSRS
Keep column headers visible while scrolling down the page of SSRS reports.
Recruiting DBAs for DevOps
DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job.
PostgreSQL WHERE, ORDER BY, and GROUP BY Clauses
Overview A database clause is a conditional statement used to filter data from the database. There are various database clauses available in PostgreSQL, like Where, Order By, Group By, Having, Distinct, Limit, Fetch. In this first chapter of the tutorial we will cover Where, Order By, Group By clauses with suitable example. WHERE Clause The […]
Storage 101: RAID
RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.
Stairway to SQLCLR Level 6: Development Tools Intro
This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers