Getting More Information From the String or Binary Data Truncated Error
One of the more annoying things that I have dealt with in SQL Server is inserting a large amount of data, only to have this message appear. Msg 8152, Level 16, State 30, Line 14 String or binary data would be truncated. The statement has been terminate …
Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
The post Power BI Dynamic X and Y Axis Using Groupings in Field Parameters appeared first on SQLServerCentral.
Introduction to Testing a Flyway Development
The post Introduction to Testing a Flyway Development appeared first on SQLServerCentral.
How to use PowerShell to set secure SA passwords for bulk servers
In this article, I will help you how to set secure SA passwords for bulk servers, sometimes, we have many SQL server instances in our company environment, the amount of it may over hundreds, and for security requirements, you may need to make the SA pa …
Download the Current Stack Overflow Database for Free (2022-06)
Stack Overflow, the place where most of your production code comes from, shares a version of their data in XML format from time to time, and then I import it into SQL Server format. Stack Overflow’s database makes for great blog post examples bec …
How to Visualize Python Charts in Power BI
Introduction In this article, we will learn how to visualize data using Python in Power BI Desktop. Python is an extremely popular programming language and it includes several libraries that can be used for charts. In other words, if you do not know ho …
Re-baselining a Database using Flyway Desktop
The post Re-baselining a Database using Flyway Desktop appeared first on SQLServerCentral.
Metrics that matter for IT organizations on an agile journey
The post Metrics that matter for IT organizations on an agile journey appeared first on SQLServerCentral.
Searching a Flyway Database
The post Searching a Flyway Database appeared first on SQLServerCentral.
Data Flow Formatters – Flatten, Parse and Stringify in Azure Data Factory
Introduction I recently worked on a data pipeline project where I had to process JSON files and transform the data into CSV files. Azure Data Factory provides data flow formatters transformations to process the data in the pipeline. In this article, we …
[Video] Office Hours: Speed Round Edition
Not all of the questions you post at https://pollgab.com/room/brento require long answers. Here’s a quick speed round: Here’s what we discussed: 00:00 Introductions 00:24 EngineHorror: Hey Brent! What’s your opinion on page- and row-l …
Database DevOps: Standardize, Automate, Monitor & Protect
The post Database DevOps: Standardize, Automate, Monitor & Protect appeared first on SQLServerCentral.
Python Built-in Statistics Functions using SQL Server Data
The post Python Built-in Statistics Functions using SQL Server Data appeared first on SQLServerCentral.
Estimated and Actual Plans Can Have Different Shapes.
A reader posted a question for Office Hours: Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution pl …
How to use a Powershell script to track the network latency issue in AOAG
In this article, we will learn how to use a Powershell script to track the network latency issue in the AwlaysOn availability group (AOAG), the network latency may become a real issue for the AOAG, if the network latency is too high for AOAG, the prima …