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 …
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 …