[Video] Office Hours: Speed Round Edition
Not all of the questions you post at https://pollgab.com/room/brento require long answers. Here’s a quick speed round: Here’s what we discussed: 00:00 Introductions 00:24 EngineHorror: Hey Brent! What’s your opinion on page- and row-l …
Database DevOps: Standardize, Automate, Monitor & Protect
The post Database DevOps: Standardize, Automate, Monitor & Protect appeared first on SQLServerCentral.
Python Built-in Statistics Functions using SQL Server Data
The post Python Built-in Statistics Functions using SQL Server Data appeared first on SQLServerCentral.
Estimated and Actual Plans Can Have Different Shapes.
A reader posted a question for Office Hours: Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution pl …
How to use a Powershell script to track the network latency issue in AOAG
In this article, we will learn how to use a Powershell script to track the network latency issue in the AwlaysOn availability group (AOAG), the network latency may become a real issue for the AOAG, if the network latency is too high for AOAG, the prima …
Business Analytics from Application Logs and SQL Server Database using Splunk
Introduction Splunk is a well-known log management tool. Splunk mines log from different machines in real-time and can be used to monitor, search, and analyze gathered data. It is a Big Data log management tool that can give insight from the unstructur …
SQL Server vs Oracle: Data Masking
The post SQL Server vs Oracle: Data Masking appeared first on SQLServerCentral.
Building a Database with Flyway
The post Building a Database with Flyway appeared first on SQLServerCentral.
How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Introduction First of all, I agree with most of the heavy hitters in saying that you should avoid formatting in both the “Data Layer” and the “Business Layer” of your applications and that it should only be done in the “Presentation Layer”. The two big …
[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.