Articles

Free eBook: Defensive Database Programming

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: )

105,836 reads

Simple Database Development with SQL Change Automation

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

Business Reasons For Implementing Power BI

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 […]

2.4 (5)

2020-07-07

6,105 reads

Blogs

Azure SQL Training

By

I thought being an Azure Data/Database blogger I would share some amazing content from...

Managing virtual machine drives on ESXi

By

Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little...

Thinking About the 2021 PASS Summit

By

I know that we don’t yet know how the 2020 Summit will turn out,...

Read the latest Blogs

Forums

Mobile DBA Tool for Android

By tung858

Has anyone used Brain Box SQL app for Android in the google play store?...

Loading ODS strategies

By stricknyn

Hi everyone, Just curious on others' approaches on this.  So I'm developing a data...

THROW vs RAISERROR with bubbling up

By Mark Eckeard

Hi all, I know THROW is newer and recommended but I'm wondering if one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers