It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
The post General program for PASS Summit 2024 now available appeared first on SQLServerCentral.
Introduction to Gemini Gemini’s intro. In the beginning, there was Bard. A powerful language model, crafted by Google AI, […]
The post What does SQL NULL mean and how to handle NULL values appeared first on SQLServerCentral.
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables […]
I was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former […]
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how […]
Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking […]
Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,095. But […]
The post Prevent Duplicate Records in SQL using Filtered Index appeared first on SQLServerCentral.
At the PGConf.dev, where Postgres developers get together and strategize the work they wanna do for the next […]
After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One […]
The next release would normally be August, but I’m doing a release a little early in order to […]
A proxy function or wrapper function allows you to deploy a custom version of a function or […]
One of the things that many teams of DBAs have is a set of scripts they use in […]
In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in […]
The post Build Chatbot with Large Language Model (LLM) and Azure SQL Database appeared first on SQLServerCentral.
In this walkthrough, we will be setting up WSFC (Windows Server Failover Cluster) in Windows Server. An WSFC […]
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 […]
The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been […]
OneLake Storage What is a Lakehouse in Azure Fabric? Borrowing a quote from MS Learn – « Microsoft Fabric […]
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Recently, I was working on a project to analyze the schema of a third-party vendor. In our organization, […]
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes […]
Overview Our application is a microservice that stores metadata for actual data and is backed by Amazon Postgres […]
I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we […]
For this week’s Query Exercise, I asked you to write a better query than ChatGPT wrote. Your goal […]
The post SQL Server TRY CATCH, RAISERROR and THROW for Error Handling appeared first on SQLServerCentral.
In the databases I am currently working with, there are some tables containing Word documents stored as binaries […]
I’m coming to San Diego on Sept 13-14 for SQL Saturday San Diego! I’m teaching a one-day pre-conference […]
Introduction Visual Studio Code (VSCode) is a free and light source code editor created by Microsoft. It can […]
Synopsis Modern relational databases have comprehensive security mechanisms to enforce fine-grained access control for tables and views. But when […]
The post Power BI Treemap Chart Step-by-Step Tutorial appeared first on SQLServerCentral.
While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to […]
What are the best days of the week and times of the day to post a question at […]
As a SQL Server DBA, effectively controlling memory allocations is essential to guaranteeing optimal query performance. In SQL […]
NEW YORK – June 11, 2024 – Timescale, the PostgreSQL cloud database company, has unveiled two groundbreaking open-source […]
“The last person must have set it up that way.” “The last person wrote that code.” “The last […]
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services […]
Data generation is the science and art of providing data for database development work that is as […]
The post How to Sort String Date Values on a Power BI Slicer Visual appeared first on SQLServerCentral.
Microsoft Fabric is a new centralized, SaaS data analytics platform which has been generally available since November 2023. […]
In my last article – What happens when we drop a column on a SQL Server table? Where’s […]
Sails.js is a robust web development framework that runs on top of Node.js and uses JavaScript’s asynchronous […]
Microsoft Fabric is a cloud-based platform that lets you, among other Data Activity, stream, analyze, and visualize […]
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we […]
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a […]