How Far Have You Traveled for a SQL Saturday?
This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.
This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.
Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is too much.
React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.
Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.
A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.
Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.
Releasing software is stressful, and as Steve Jones notes today, can cause bankruptcy if you don't have a solid process.
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers