Flyway How-tos: a User’s Perspective
The post Flyway How-tos: a User’s Perspective appeared first on SQLServerCentral.
How to automate table level refresh in Power BI
The post How to automate table level refresh in Power BI appeared first on SQLServerCentral.
Database Development Visibility using Flyway and PowerShell
The post Database Development Visibility using Flyway and PowerShell appeared first on SQLServerCentral.
Standards Matter
At first, this was going to be a technical article about an index maintenance horror story. I received an off-hours page because the index maintenance job was running for a long time on a big table. I have an agent job setup to use Ola’s scripts, and I …
The Top Feature Requests for SQL Server
If you want to get a look at where Microsoft SQL Server is heading in the future, it helps to get an idea of what users are repeatedly asking for. Here’s a quick rundown of the top requests from feedback.azure.com as voted by the people who cared …
“Index Seek” Doesn’t Mean Much.
When you see “index seek” on an execution plan, that doesn’t mean SQL Server is jumping to exactly the row you’re looking for. It only means that SQL Server is seeking on the first column of the index. This is especially mislead …
Working with MySQL Stored Procedures
The post Working with MySQL Stored Procedures appeared first on SQLServerCentral.
What is the Flyway Teamwork Framework?
The post What is the Flyway Teamwork Framework? appeared first on SQLServerCentral.
SQL SERVER – Find Owner of Database – Change Owner of Database
Recently I had the opportunity to help a client with Comprehensive Database Performance Health Check, and while working together we ended up in a very interesting situation where they had one database without an owner. As there was no owner, it was not …
Who’s Hiring in the Database Community? May 2022 Edition
Is your company hiring for a database position as of May 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
Creating Flyway Migration Files using Redgate Schema Comparison Tools
The post Creating Flyway Migration Files using Redgate Schema Comparison Tools appeared first on SQLServerCentral.
Creating Tables in Power BI
Creating tables in Power BI can be useful in some situations. In this article, we will see the two main ways to create our own internal tables in Power BI. Prerequisites All we need for this example is the Power BI Desktop edition. Getting Started Firs …
Clustering data for insights
The post Clustering data for insights appeared first on SQLServerCentral.
Azure Data Studio and Version Control
One of the more important things that I think we should be doing as software developers is maintaining our changes in some sort of version control system (VCS). This is important to protect code, allow us to undo problem changes by finding old code, an …
Finding deeper insights with Topic Modeling
The post Finding deeper insights with Topic Modeling appeared first on SQLServerCentral.