Searching Flyway Migration Files using Grep and Regex
The post Searching Flyway Migration Files using Grep and Regex appeared first on SQLServerCentral.
Archives du mois : juin 2023
Unpivot Data Using Python
Problem Statement In one of the Business Analytics Dashboards Projects, Sales data is received from different countries (100 […]
[Video] How to Use ChatGPT to Write WordPress Blog Posts
Today’s live stream was a little different: I demonstrated using the Aiomatic WordPress plugin, ChatGPT, and Azure Open […]
[Video] Office Hours: As They Pour My Patio Concrete Edition
I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I […]
How to Reduce the Need for Bookmarks Using Parameters in ...
Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in […]
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted ...
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of […]
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people […]
How to Make Database Changes Without Breaking Everything
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you […]
Using a Subquery in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […]
[Video] Office Hours: Professional Development & Training Questions
The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.
SQL Server Resumable Index Operations
As the DBA, have you ever had to cancel an online rebuild or create index process on a […]
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, ...
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on […]
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 […]
Call for Panelists – WIT Panel at PASS Data Community ...
The WIT panel at the PASS Summit has been a longstanding tradition. We, the Data Platform WIT team, […]
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 […]
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 […]
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 […]
How to Avoid N+1 Queries: Comprehensive Guide and Python Code ...
Introduction N+1 queries are a prevalent performance issue in software applications that involve retrieving data from databases. The […]
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 […]
Snowflake: A Cloud Warehouse Solution for Analytics
This article explains what Snowflake data warehouse is and how it is different from other traditional data […]
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part ...
This is the final post in a series covering changes in SSMS 19. Please review Part 1 and […]
ISJSON enhancements in SQL Server for valid JSON format for ...
The post ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object appeared […]
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 […]
Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level ...
The post Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security appeared first on SQLServerCentral.
SQL Server slow performance troubleshooting documentation expanded
In the past 1.5 years we in the SQL Server CSS and content teams have been working […]
Horizontal Trees
Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent […]
How to Visualize Timeseries Data with the Plotly Python Library
The post How to Visualize Timeseries Data with the Plotly Python Library appeared first on SQLServerCentral.
Using Windows Security and Encryption with Flyway
The post Using Windows Security and Encryption with Flyway appeared first on SQLServerCentral.
Cumulative Update #5 for SQL Server 2022 RTM
The 5th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Cumulative Update #21 for SQL Server 2019 RTM
The 21st cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Working with MySQL transactions
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […]
Update: Hotfixes released for ODBC and OLE DB drivers for ...
We’ve released hotfix packages for the following drivers to address important security issues: Microsoft ODBC Driver 17.10.4 […]
Why Are Y’all Changing the Compat Levels on Master?
One of the things I love about SQL ConstantCare® (which happens to be free this month, by the […]
Secure your AI using SQL Server Machine Learning with Microsoft ...
Microsoft SQL Server Machine Learning Services is a feature that allows you to run Python, R, Java, and […]
Unmasking SQL Server Dynamic Data Masking, Part 3, Security Concerns
This is the third part of a series on SQL Server Dynamic Data Masking. The first part […]
[Video] Office Hours: Almost Back in San Francisco
It’s back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions […]
Calculating Prime Numbers With One Query
Introduction I want to share the solution to the problem of searching for prime numbers using T-SQL. The […]
Building a Kimball Data Warehouse
Introduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was […]
The SQL Server Advice You Don’t Wanna Hear
One of the big principles of our SQL ConstantCare® monitoring product – which happens to be free this […]
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part ...
This is the second post in a series discussing changes between SSMS 18.12.1 and SSMS 19, and new […]
Poll Results: Are You Going Back to In-Person Events?
Last week, I asked if y’all had been to in-person regional events before, and whether you were going […]
Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant
So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, […]
Flyway for SQL Server Data Tools Users
The post Flyway for SQL Server Data Tools Users appeared first on SQLServerCentral.
T-SQL Scripts to generate the HTML-formatted database storage report
This article explains the T-SQL scripts that can be used to manage and monitor the disk space on […]
Multiple Relationships on the same Table in a Power BI ...
The post Multiple Relationships on the same Table in a Power BI Data Model appeared first on SQLServerCentral.
Released: Microsoft.Data.SqlClient 5.2 Preview 2
Microsoft.Data.SqlClient 5.2 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […]
Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior ...
The post Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders appeared first on SQLServerCentral.