[Video] Office Hours: SQL Server Career Q&A, Part 1
I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here were the questions you upvoted the most, and I’ll post another round of ’em next week. The audio on this isn …
Effective Data Governance: Being Grown Up About Data
The post Effective Data Governance: Being Grown Up About Data appeared first on SQLServerCentral.
Wanna Ask Me Anything About Careers & Professional Development?
I’ll be answering your questions from right here. Ever wanted to ask me questions about careers or professional development? Now’s your chance. Post your questions here – and you may wanna use a fake name if you’re asking s …
Introduction to PostgreSQL Database on Amazon RDS
In this article, I am going to explain how to create a PostgreSQL database using Amazon RDS. Amazon is one of the most popular cloud vendors in today’s market. There are a lot of services offered by Amazon. These services can be found under Amazon Web …
Updated First Responder Kit and Consultant Toolkit for December 2020
sp_BlitzLock gets better identification of parallel deadlocks, sp_DatabaseRestore uses Ola’s scripts for logging, and lots of bug fixes this month. Watch and learn To get the new version: Download the updated FirstResponderKit.zip Azure Data Stud …
Email Validation Simplified with Web API and SSIS
The post Email Validation Simplified with Web API and SSIS appeared first on SQLServerCentral.
What is a Data Catalog?
The post What is a Data Catalog? appeared first on SQLServerCentral.
Basic Git for DBAs: Ignoring Files and Customizing Your Environment
This is the eighth article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git …
Free Webcast: 3 Ways to Prove Your SQL Server Storage is Slow
Your users are complaining that their queries are slow. You’ve tried changing SQL Server settings, tuning indexes, but the problem just won’t go away. You’ve got a hunch that it’s a storage problem, but you need real, empirical …
Database Updates: Rolling Back and Fixing Forward
The post Database Updates: Rolling Back and Fixing Forward appeared first on SQLServerCentral.
DBA in training: Know your server’s limits
The series so far: DBA in training: So, you want to be a DBA… DBA in training: Preparing for interviews DBA in training: Know your environment(s) DBA in training: Security DBA in training: Backups, SLAs, and restore strategies DBA in training: DBA in …
More Gems from the SQL Prompt Treasure Chest
The post More Gems from the SQL Prompt Treasure Chest appeared first on SQLServerCentral.
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
The post Deploy Database Objects to Multiple SQL Server Instances Using PowerShell appeared first on SQLServerCentral.
Scheduling PowerShell Using Jenkins
Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, OSX, and Windows) and …
Take the 2021 State of Database DevOps survey
The post Take the 2021 State of Database DevOps survey appeared first on SQLServerCentral.