[Video] Office Hours: Interview Horror Stories Edition
Wanna hear about my worst job interviews? I drove up to 8,000 feet where it’s 30 degrees colder than Las Vegas to bring you these answers to your top-voted questions from https://pollgab.com/room/brento. The audio’s a little odd on here because it was …
MongoDB and Python in action
Overview As a part of this article, we will learn basics of connecting to MongoDB using a python stand-alone script to make sure that we can push data into our locally setup MongoDB. We will focus on the following areas: Downloading and installing Mong …
Best Way to Repair SQL Database: How to Restore SQL Server?
Summary: SQL Server administrators frequently encounter the critical challenge of unexpected MDF file corruption. Such corruption can result in prolonged downtime and, in severe cases, permanent data loss, disrupting operations significantly. If you ar …
Poll Results: Yes, Your DBAs Can Read the Data.
Last week, I asked if your database administrators could read all of the data in all databases. The results (which may be different from this post, because I’m writing the post ahead of time and the poll is still open): Yes: 61% Yes, but we trust them …
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes in MySQL come in a variety of shapes and sizes. Readers of this blog will certainly not be alien to the nuances of indexes within MySQL – this blog has …
The Query Tuning Trick You Should Use More: Pagination
When I’m tuning queries, the normal answer is to make the query perform better – either via changing the T-SQL, adding hints, or adding indexes so that the data’s better prepared for the query. However, sometimes when I’m looking at the output of sp_Bl …
How to Increase SQL Server Column Width Without IO (Input/Output) Overhead
One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing column. Depending on the column’s use and data type, this process may involve hundreds of schema changes, app downtime, and a mountain of risk-prone …
How to optimize queries using AI (SQL Expert)
Introduction ChatGPT can help you with your queries. However, some customized GPTs inside ChatGPT can be useful for your job. This time, we will teach the SQL Expert (QueryGPT). It is a specialized GPT created by a third-party developer within ChatGPT. …
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; under heavy load they can still fall behind. This article shows how to measure and track that hidden replication delay using SQL Server perf …
[Video] Building a Brand By Sharing Your Work
You’ve got a good job, and some spare time. You’re thinking about giving back to the community by blogging, presenting, live streaming, or working on Github projects – and you’d like to make your next job search easier. Let’s talk about it. I apologize …
Connecting to PostgreSQL with Node.js
Overview In this article, we will understand how we can connect to PostgreSQL using Node.js application. We will start with setting up PostgreSQL in our local system and perform basic CRUD operations to interact with the PostgreSQL database. Prerequisi …
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, I’ve often encountered situations where a single, poorly written query or a resource-intensive application threatened to cripple t …
Monitor SQL Server using Zabbix
Zabbix is an open-source monitoring software, like Paessler PRTG, which can monitor SQL Server performance statistics and status. Although it doesn’t replace DBA functions, it is useful to provide evidence when things start to fail. Among its features …
Poll: Can Your DBAs Read the Data?
It’s a simple question: can your database administrators read all of the data in all databases? Yes Yes, but we trust them not to – as in, we’ve got written policies in place, and they know they’re not supposed to go poking around in the payroll tables …
How to use pgAdmin with Azure Database for PostgreSQL flexible server
Multiple tools are available for working with Azure Database for PostgreSQL flexible server. One of these is the psql command-line utility, which I introduced you to in the previous article in this series. Another valuable tool is pgAdmin, a much more …