Blog Post

Temporal Table Data Fixes

I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...

2023-09-06 (first published: )

52 reads

Blog Post

Microsoft Fabric Overview

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...

2023-07-19 (first published: )

412 reads

Blog Post

Automating Database Maintenance on Azure SQL

Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes...

2023-06-07 (first published: )

504 reads


Penetration Testing your SQL Server, Part 1 – The Recon Mission


Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

SQL Saturday Denver 2023–VCS Primer for the Database slides


My slides are here: VCS Primer Denver 2023 This was an overview of what...

Future Data Driven 2023 is This Week


The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Read the latest Blogs


upgrade evalution editon reporting services to Stanadard

By Shivrudra

Hi All, I installed reporting services evaluation edition for testing purpose, but now 180...

cost threshold for parallelism value to be set

By bobrooney.81

Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are...

Master Data - Relational or Dimensional modeling?

By river1

Dears, In my company, we have certain master data domains like customer; Vendor; Product;...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers