Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.
2020-07-08 (first published: 2013-08-28)
105,836 reads
SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development. Phil Factor describes a project to update the Pubs database, using it in combination with a PowerShell function and to maintain in source control the build scripts, migration scripts and object-level scripts, for every version of the database.
2020-07-08
Keeping SQL Server instances patched can be a time-consuming task for DBAs. In this article, Alejandro Cobar explains how he created a service in Azure that anyone can use to retrieve the build information for SQL Server.
2020-07-08
Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools. There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc. Each data extract or report is created by a BI or DB Development Team member. Often […]
2020-07-07
4,148 reads
Learn how to use the 'hybrid' approach in the Deployment Suite for Oracle to automate Oracle database deployments. In this approach, the team maintains the current state of the database in version control during development, then, at key stages, generates and tests the migrations script that will be used to deploy the new database changes safely.
2020-07-07
In this series of tips we will introduce PowerShell scripts with T-SQL code that can be used to monitor your SQL Server environment. This first set of scripts creates the core objects needed for this solution.
2020-07-07
2020-07-06
1,477 reads
Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of commands needed. In this article, Robert Cain demonstrates how to run SQL Server in a Docker container on Ubuntu.
2020-07-06
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out.
2020-07-06
Learn how you can enable the Stretch Database feature in SQL Server 2016.
2020-07-03 (first published: 2019-01-15)
3,421 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
How many times have you been afraid to hear “No”? We have all been...
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Hello SQL Gurus I am new to Database design. We are building an application...
Comments posted to this topic are about the item Adding a Calculated Column in...
Ask SSC