PASS Data Community Summit registration is open!

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.
The post PASS Data Community Summit registration is open! appeared first on SQLServerCentral.

How to Slice Data by Week in a Calendar Table using DAX

Judging from my experience working with business stakeholders across several organizations, slicing data by current week, previous week, two weeks ago, and so on has become a requirement for reporting. I will demonstrate a simple approach to achieve this requirement.
The post How to Slice Data by Week in a Calendar Table using DAX appeared first on SQLServerCentral.

Working with Flyway And Entity Framework Code First: An Overview

This article presents an approach to database development and deployment that combines the strengths of Entry Framework Code First for .NET-driven development with the control and database versioning provided by Flyway's SQL migrations. It allows every database change to be reviewed and tested for integrity, performance, and stability in the same way as any application change. It should make a Database CI process much easier to sustain.
The post Working with Flyway And Entity Framework Code First: An Overview appeared first on SQLServerCentral.

How to Automate Cross-Platform Database Development

In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.
The post How to Automate Cross-Platform Database Development appeared first on SQLServerCentral.

PASS Data Community Summit registration is open!

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.
The post PASS Data Community Summit registration is open! appeared first on SQLServerCentral.