Upcoming webinar: CI and CD with SSDT and Living to Tell About It

I’m delivering an upcoming webinar in PASS Global Hebrew Virtual Group: CI and CD with SSDT and Living to Tell About It, on September 25th, 17:00 Israel Standard Time (GMT+3) Details and registration: https://globalhebrew.pass.org/MeetingDetails.aspx?EventID=14256 Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the application development lifecycle. Source control, version history, … Continue reading Upcoming webinar: CI and CD with SSDT and Living to Tell About It

#TSQL2sday : I wish SQL Server had better Table Partitioning

For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature.

The feature I wish we had is Table Partitioning, but… Better. Unfortunately, the feature by large remained the same way since its release in 2005, without any meaningful improvements (besides some parallelism and statistics maintenance improvements).

But I think Microsoft can do much better. Continue reading #TSQL2sday : I wish SQL Server had better Table Partitioning