DBA to Data Engineer
A title change can come with a salary bump in some cases, but you might need to work to achieve both of those. Steve has a few ideas today.
Getting More Information From the String or Binary Data Truncated Error
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
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 password of them different and enough safe, there will be […]
Introduction to Testing a Flyway Development
How to use Flyway Teams to run basic tests whenever it successfully executes a migration, checking that all the business processes supported by our database always produce the expected results.
Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
In this step-by-step article, learn how to dynamically select what displays on the X or Y axis of a Power BI chart.
Looking Back
Today Steve talks about retrospectives and how we learn and grow as software professionals.
Potholes in the Road of Progress
Phil Factor looks at some technologists more famous for thwarting progress than for their own creations.
How to Visualize Python Charts in Power BI
This article will show how you can code in Python and produce a chart for Power BI.
Reducing Debt and Increasing Security
DevOps is often thought of as bringing more features to customers, but it can also help security.
Blogs
Creating TAIL on Windows for Text Files
By Steve Jones
I wrote recently about making a HEAD utility to find the top few lines...
Daily Coping 17 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The book that made me love goal-setting
By Jen McCown
Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...
Forums
Select * (Sql query)
Hi, I have a problem like below one. Give, for each train station, the...
SQL Query
Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...
Combine or join 3 tables, 1 for each databases
Hello guys, I hope you're all great and healthy I would love to learn...
Ask SSC