Articles

BMWs SQL Server Enterprise Architect on the challenges of monitoring

Tony Maddonna, BMW’s SQL Server Enterprise Architect, writes about the challenges of database monitoring. Drawing on experiences throughout his career, this blog covers manual vs third party, proactive monitoring in dev and test, and managing expectations of the cloud. To learn more, and read his tips on how to build a business case for third-party tooling, check out his blog.

2020-11-27

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-11-25 (first published: )

105,836 reads

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.

2020-11-25

Blogs

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Read the latest Blogs

Forums

Ideas for Auditing

By Tava

I'm currently looking to design some auditing on my SQL application and am wondering...

Set Variable to lookup first row value with white space in property name

By jdlayton83

Hi, How can I set the value of a variable from a Lookup activity...

How to aggregate Dimension values properly

By ktflash

Ahoi, im trying to deal with a user request to combine 2 values of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers