Prevent Duplicate Records in SQL using Filtered Index
The post Prevent Duplicate Records in SQL using Filtered Index appeared first on SQLServerCentral.
Does Bit Column Order Matter in Tables?
At the PGConf.dev, where Postgres developers get together and strategize the work they wanna do for the next version, I attended a session where Matthias van de Meent talked about changing the way Postgres stores columns. As of right now (Postgres 17), …
T-SQL Tuesday #176: One piece of advice you wish Past You had
After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One of the things I tend to do when I am working on a project is to think of myself over three time periods. The past, present and the future. The past version of …
Updated First Responder Kit and Consultant Toolkit for July 2024
The next release would normally be August, but I’m doing a release a little early in order to fix 2 issues with the Consultant Toolkit. The May release broke the ability to automatically upload results to Amazon S3, and didn’t include all o …
Extending Get-Process to show the Process Chain using PowerShell Proxy Functions
A proxy function or wrapper function allows you to deploy a custom version of a function or cmdlet while the internal functionality remains implemented. That means you can get a core cmdlet or function, add parameters (or remove), and write the code fo …
Getting Your DBA Teams Scripts into Git
One of the things that many teams of DBAs have is a set of scripts they use in their various environments. These are usually built over time for specific purposes and often help ensure that the team can quickly diagnose and solve issues. These might al …
Saving Data Historically with Temporal Tables: Part 1: Queries
In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in a way that allows you to see not only what the value of any column is currently, but at any point in time that your system is created to handle. In t …
Build Chatbot with Large Language Model (LLM) and Azure SQL Database
The post Build Chatbot with Large Language Model (LLM) and Azure SQL Database appeared first on SQLServerCentral.
Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)
In this walkthrough, we will be setting up WSFC (Windows Server Failover Cluster) in Windows Server. An WSFC is a group of Windows servers that work together to ensure high availability of applications and services. Any WSFC (albeit for FCI or AG) comp …
[Video] Office Hours: I Don’t Have All the Answers
When I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today: Here’s what we covered: 00:00 Start 00:48 MyTeaGotCold: I increased my RAM from 16 GB to 32 GB and my buffer pool has grown …
Join Me in Seattle for Watch Brent Tune a Query in SQL Server 2022
The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been selected for a general session! Watch Brent Tune a Query in SQL Server 2022: Ever wonder how somebody else does it? In this all-demo session, w …
Control OneLake with Storage Explorer – Data Engineering with Fabric
OneLake Storage What is a Lakehouse in Azure Fabric? Borrowing a quote from MS Learn – « Microsoft Fabric Lakehouse is a data architecture platform for storing, managing, and analyzing structured and unstructured data in a single location ». I think of i …
The SQL Language is Just a Hurdle You Gotta Overcome.
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and think bigger picture for a second: is the SQL language itself a problem? Sometimes when I talk to client developers, they gripe about …
Deleting Documents from a MongoDB Collection
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collect …
How to Rename a Column in SQL Server
Recently, I was working on a project to analyze the schema of a third-party vendor. In our organization, we had an internal support ticket management tool. The tool used an SQL database, and after considering the cost of the tool, we decided not to ren …