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.

SQL Snippets Galore, Added to SQL Prompt

Imagine having at your fingertips all the metadata queries you need to explore your SQL Server databases and then, a few clicks later, all your diagnostic queries to troubleshoot their performance. Phil Factor demonstrates how it can be done, by storing each set of snippets in a standard JSON collection and using PowerShell to convert them to SQL Prompt snippet files.

Blogs

Database DevOps Deployment to Azure–Webinar

By

You can register now, but on Dec 3, I have a webinar with Microsoft...

[PowerShell Newbie] Using Start-Transcript

By

This week we are going to launch a blog series geared towards folks that...

My Experience on Geeks on Screen with Coffee

By

Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube...

Read the latest Blogs

Forums

Points of consedering during "Transaction Processing"

By gaurav

Hello Everyone, Here I need suggestions while I am trying to do some transaction...

when use dbachecks, it has error: unable to find type [Pester.outputtypes]

By huishi.ca

hi there: When I type invoke-dbcCheck, it pops up error below: Unable to find...

Finding Thanks

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Thanks

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers