SQL Server Resumable Index Operations
As the DBA, have you ever had to cancel an online rebuild or create index process on a very large table? Perhaps it didn’t finish during your maintenance window or consumed valuable resources, causing other queries to run slowly? It is a headache for a …
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on SQLServerCentral.
Pipelining Configuration Information Securely to Flyway
The post Pipelining Configuration Information Securely to Flyway appeared first on SQLServerCentral.
It’s Friday. I’m Not Answering These 14 Office Hours Questions.
Sometimes, I don’t care if questions get a lot of upvotes at https://pollgab.com/room/brento – I just don’t wanna answer ’em. They’re not necessarily bad questions, but I’m just not interested in them, or I’ve …
Call for Panelists – WIT Panel at PASS Data Community Summit, 2023
The WIT panel at the PASS Summit has been a longstanding tradition. We, the Data Platform WIT team, are honored to be entrusted with the task of selecting and hosting this year’s panel. To determine the topic, we conducted a brief poll and arrived at t …
How to Find the SQL Server Version
This article explains various methods to find the SQL Server version for an instance. Knowing the SQL Server version is important for several reasons: Feature availability: Different versions of SQL Server have different sets of features available. Som …
Troubleshoot SQL Server Deadlocks in Stored Procedures
The post Troubleshoot SQL Server Deadlocks in Stored Procedures appeared first on SQLServerCentral.
[Video] Office Hours: Github Copilot in Azure Data Studio
I start today’s Office Hours by playing with the very underwhelming Github Copilot in ADS, then take your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 04:06 Github Copilot in Azure Data Studio 24:36 By …
Updated First Responder Kit and Consultant Toolkit for June 2023
This one’s a pretty quiet release: just bug fixes in sp_Blitz, sp_BlitzLock, and sp_DatabaseRestore. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First …
How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples
Introduction N+1 queries are a prevalent performance issue in software applications that involve retrieving data from databases. The N+1 query problem occurs when an application retrieves a collection of records and their associated data by making a se …
The Best Career Advice I Ever Got (#TSQL2sday)
Steve Jobs. Photo by Matthew Yohe. I have been absurdly lucky to be around so many amazing and inspirational managers. Almost everything I know was taught to me by someone else. Over my life, I’ve learned so much about careers, marketing, busines …
Snowflake: A Cloud Warehouse Solution for Analytics
This article explains what Snowflake data warehouse is and how it is different from other traditional data warehouses. This article will cover how to create virtual warehouses and different types of tables, how to handle semi-structured data, how to pr …
ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object
The post ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object appeared first on SQLServerCentral.
Advantages of Kappa architecture in the Modern Data Stack
Introduction In the big data era, organizations require real-time processing to make well-informed decisions and extract valuable insights from vast amounts of data. Initially, Lambda architecture emerged to address these needs. While it successfully p …
Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security
The post Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security appeared first on SQLServerCentral.