It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

Excel has grown into a powerful hub for data preparation, modeling, and automation. With tools like Power Query, Power Pivot, dynamic arrays, and Office Scripts, you can connect to multiple sources, ...

Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. As a consultant, I work on wide swaths of database systems, which means I get to see many, many SQL statements ...

SQL Server 2025 is introducing AI-native capabilities alongside new approaches for secure integration with large language models. Enterprises can now run local AI models such as Llama 3 via Ollama for ...

Microsoft has released out-of-band (OOB) updates to fix issues affecting Windows Server systems after installing the April 2026 security updates. As Microsoft confirmed last week, some admins may ...

Databases are used in many different settings, for different purposes. For example, libraries use databases to keep track of which books are available and which are out on loan. Schools may use ...

Grafana Labs has launched Pyroscope 2.0, a rearchitected open-source continuous profiling database. This version improves ...

As a small business owner, Liz understands the unique challenges entrepreneurs face. Well-versed in the digital landscape, she combines real-world experience in website design, building e-commerce ...