Running Unit and Integration Tests during Flyway Migrations
The post Running Unit and Integration Tests during Flyway Migrations appeared first on SQLServerCentral.
PostgreSQL Triggers Part 1
Article Overview In this article we will cover the following topics: Database trigger and concept Types of triggers PostgreSQL trigger vs SQL Server trigger key differences PostgreSQL trigger operations overview Access Trigger via pgAdmin and psql What …
Database DevOps: Standardize, Automate, Monitor & Protect
The post Database DevOps: Standardize, Automate, Monitor & Protect appeared first on SQLServerCentral.
Tips to improve Power BI report appeal
Introduction This time we will provide some tips to improve the Power BI report appeal. Let’s face it. Software engineers are not usually good to create nice reports. We can deal with complex code, AI, but usually (there are always some exceptions to t …
Your Turn: I’m Not Answering These 13 Office Hours Questions
Normally, after I do a round of Office Hours of going through the questions that got posted at https://pollgab.com/room/brento, I answer the highly upvoted ones and then clear the queue. If y’all didn’t upvote questions, then I don’t …
INSERT EXEC statement cannot be nested, the Simple Solution
If you use the tSQLt unit testing framework for long enough, you will eventually run into the “An INSERT EXEC statement cannot be nested” problem. This problem happens when you try to insert the output of a stored procedure into a temporary table for v …
Create a Table in Microsoft SQL Server
The post Create a Table in Microsoft SQL Server appeared first on SQLServerCentral.
5 things to look for in a 3rd party database monitoring tool
The post 5 things to look for in a 3rd party database monitoring tool appeared first on SQLServerCentral.
[Video] 300-Level Guide to Career Internals at SQLBits
You’re overwhelmed with choices: so many things you could learn, so many ways you could specialize in your career. Which one should you choose? What are the safe bets, and what are the risky bets? Should you be a contractor? A consultant? A freel …
[Video] Office Hours at the End of the World
I hopped down to Cabo San Lucas and sat at the End of the World to answer the questions you posted & upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Intros 00:44 Kirk Saunders: Hey Brent! When did you determine your …
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 …