Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro. By Joey ...

Check out Part 2 of this interview, where we focus more on on-premises SQL Server. We discuss how these processes have improved the engineering process, and how Microsoft is focusing on the ...

As promised in part one, I developed a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database (See Code Download for full source code and executable). The ...

Figure 1. Get started by running SQL's version of PowerShell. Let's start off with looking at the SQL Server services running on a given machine. Use the Get-Service cmdlet to find out about services ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...

However, even without a JSON datatype, SQL Server 2016 still lets you query data stored in JSON format. I’ll look at that support in a later column (among other features, it provides a way to ...

The appeal of cost savings in moving SQL server farms to the cloud as part of this modernization cannot be overstated. Cloud giants like Azure, AWS, GCP and Snowflake offer attractive pricing ...