Worse Before Better
We need to approach software development with a balance of making things better, and ensuring they work.
Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services
In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS
How a monitoring tool benefits the entire organization
Redgate estimate that the savings realized with a monitoring tool could be well over $85,000 / year*. Does your organization understand how a monitoring tool can impact almost every department?
Access All Your Data in Google Data Studio with CData Connect Cloud
Google Data Studio helps you create comprehensive reports and data visualizations. When combined with CData Connect Cloud, you get instant, cloud-to-cloud access to data from supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. CData Connect Cloud provides a live cloud-to-cloud interface for all your data, making it easy to build reports from […]
Azure Data Studio - A SandDance demo
Learn how you can get better charting in Azure Data Studio with SandDance.
Dry Runs for Database Migrations using Flyway Teams
How Dry Run scripts work, and how they can be used to deliver a single-script release artifact to Staging, verify placeholder substitutions in SQL migration scripts, and simply team code reviews.
Using SQL Server sequence objects
SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.
Holiday Fun for Your Career
The Advent of Code is live, and Steve finds it to be a fun way to take a break during your day.
SQL Server Data Masking: a comparison with Gallium Data
Introduction In SQL Server 2016, Microsoft introduced a new feature called dynamic data masking, which allows you to mask the values of certain columns and keep that data hidden from certain users, without having to modify your applications. Let's take a look at how SQL Server does data masking, and compare it to the way Gallium Data […]
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers