Sites anglophones


Who is the Best Batman in Power BI

Publié le 9 mai 2022 sur sqlservercentral.com
 

Who is the best Batman? – A Power BI Analysis of data Introduction Who is the best Batman? We were drinking some cold beers with some friends when someone said that Pattinson was the best Batman. People started to discuss and after 2 hours, the p …

Flyway How-tos: a User’s Perspective

Publié le 9 mai 2022 sur sqlservercentral.com
 

The post Flyway How-tos: a User’s Perspective appeared first on SQLServerCentral.

How to automate table level refresh in Power BI

Publié le 6 mai 2022 sur sqlservercentral.com
 

The post How to automate table level refresh in Power BI appeared first on SQLServerCentral.

Database Development Visibility using Flyway and PowerShell

Publié le 6 mai 2022 sur sqlservercentral.com
 

The post Database Development Visibility using Flyway and PowerShell appeared first on SQLServerCentral.

Standards Matter

Publié le 6 mai 2022 sur sqlservercentral.com
 

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

Publié le 5 mai 2022 sur brentozar.com
 

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.

Publié le 4 mai 2022 sur brentozar.com
 

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

Publié le 4 mai 2022 sur sqlservercentral.com
 

The post Working with MySQL Stored Procedures appeared first on SQLServerCentral.

What is the Flyway Teamwork Framework?

Publié le 4 mai 2022 sur sqlservercentral.com
 

The post What is the Flyway Teamwork Framework? appeared first on SQLServerCentral.

 

SQL SERVER – Find Owner of Database – Change Owner of Database

Publié le 3 mai 2022 sur journey to sqlauthority
 

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

Publié le 2 mai 2022 sur brentozar.com
 

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

Publié le 2 mai 2022 sur sqlservercentral.com
 

The post Creating Flyway Migration Files using Redgate Schema Comparison Tools appeared first on SQLServerCentral.

Creating Tables in Power BI

Publié le 2 mai 2022 sur sqlservercentral.com
 

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

Publié le 2 mai 2022 sur sqlservercentral.com
 

The post Clustering data for insights appeared first on SQLServerCentral.

Azure Data Studio and Version Control

Publié le 29 avril 2022 sur sqlservercentral.com
 

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 …


Pages :