[From the archives] 5 things to look for in a 3rd party database monitoring tool
The post [From the archives] 5 things to look for in a 3rd party database monitoring tool appeared first on SQLServerCentral.
[Video] Office Hours: Long Answers Edition
This time on Office Hours, I let a few questions piled up at https://pollgab.com/room/brento that required in-depth answers to really do ’em justice. In particular, there was a statistics question that needed demos. Here’s what we covered: …
Let’s Make September Our Free Community Tools Awareness Month.
Last week, I was reading a brand new article from a Microsoft employee about how you should directly query sys.dm_exec_requests in order to find out what’s running on your system. “Step 1: get a stone that looks round.” I lost my mind …
Increasing the Visibility of Database Changes in Flyway Development
The post Increasing the Visibility of Database Changes in Flyway Development appeared first on SQLServerCentral.
Tracking Configuration Changes Against a Baseline
One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, h …
Identify and Correct a Large SQL Server Error Log
The post Identify and Correct a Large SQL Server Error Log appeared first on SQLServerCentral.
Who’s Hiring in the Database Community? August 2022 Edition
Is your company hiring for a database position as of August 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must inc …
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. Think of the scenario where you have a form with first name and last name. Now users have input the data in a different order than you expect. In this cas …
How to Get Data Using Python in Power BI
Introduction Get data from Python in Power BI is a possible. Python is one of the most popular programming languages. Several websites consider Python as the #1. Even the DBAs feel some pressure to learn Python. SQL Server included some features to int …
A day in the life of a DBA using SQL Monitor: in a 90 second video!
The post A day in the life of a DBA using SQL Monitor: in a 90 second video! appeared first on SQLServerCentral.
Running a Python Application as a Windows Service
The post Running a Python Application as a Windows Service appeared first on SQLServerCentral.
How to Backup Redshift Log Views
Recently I had a discussion with my manager about the need to save the log data that is stored in the STL log views, as I found the following line in the AWS Redshift documentation: « To manage disk space, the STL log views only retain approximately two …
Office Hours: Dodging Work Edition
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today, I’m dodging work, so I went through your questions while I waited for the coffee shop to open: Here’s what we covered: 00:00 …
How to setup multi-subnets Azure SQL VM AG group based WSFC (Windows Server 2019)
In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner’s guide for people who have no experience to …
[Video] Fundamentals of Stored Procedures at SQLBits
Anybody can write a stored procedure with a little help from Google. This session is about how to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot. This fast-paced, all-demo session from SQLBits will N …