What is Change Management?
The post What is Change Management? appeared first on SQLServerCentral.
How to get DevOps buy-in across your organization
The post How to get DevOps buy-in across your organization appeared first on SQLServerCentral.
Wanna Speak at the PASS Summit This Year? Move Fast.
The PASS Summit is November 15-18 in Seattle this year. This time around, it’s a hybrid conference, with both speakers and attendees in a mix between in-person and remote. I’m really excited to get back to in-person events. I recently atten …
SQLDay Poland Workshop: How I Use the First Responder Kit
Watch and learnI’m presenting remotely at the upcoming SQLDay Poland on 9-11 May! I’m teaching a one-day workshop, How I Use the First Responder Kit. You’ve downloaded sp_Blitz, sp_BlitzIndex, and sp_BlitzCache from the First Responde …
SQL SERVER – Sample Script for Compressed and Uncompressed Backup
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course, I have and here it is. The scripts are very simple. Compressed Backu …
Working with MySQL tables
The post Working with MySQL tables appeared first on SQLServerCentral.
Import Web pages with Power BI
Introduction In this article, we will learn how to create charts from web pages with Power BI. Power BI is an extremely great tool to easily generate reports. We will combine and analyze data from different websites, and we will talk about COVID 19 wit …
Think you know SQL Monitor? Think again.
The post Think you know SQL Monitor? Think again. appeared first on SQLServerCentral.
Live Office Hours Next Week
Tuesday & Wednesday afternoon at 2PM Pacific, 5PM Eastern, I’ll be streaming Office Hours live in my Twitch channel. I’ll post the recordings on my YouTube channel. Post your questions and upvote the ones you’d like to see here. H …
Bulk Formatting of the SQL Server SQL Files
The post Bulk Formatting of the SQL Server SQL Files appeared first on SQLServerCentral.
Monitoring Azure SQL Databases
There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This arti …
The effects of NULL with NOT IN on Oracle transformations
The post The effects of NULL with NOT IN on Oracle transformations appeared first on SQLServerCentral.
[Video] Office Hours: Morning in Mexico Edition
Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but w …
Prevent Accidental Resource Deletion Using Locks in Azure Data Factory
Introduction While working in Azure Data Factory a user can delete a resource unknowingly. We can implement Azure Locks to prevent this accidental resource deletion. You can create your own custom roles to give users read-only access to the Azure Data …
The basic T-SQL SELECT statement
The post The basic T-SQL SELECT statement appeared first on SQLServerCentral.