Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness.
2021-03-19
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.
2021-03-18
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
2021-03-17
Thanks to the consent of the speakers, the expert-led educational training courses covering the following four topics: Data Modernization, Azure Migration, Azure Synapse, Azure SQL, are now available to all. You can watch the sessions and learn from a range of experts online, for free.
2021-03-17 (first published: 2021-03-01)
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
2021-03-16
Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.
2021-03-16
Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.
2021-03-15
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.
2021-03-15
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.
2021-03-12
RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.
2021-03-11
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers