Blog Post

SQL Temporal Tables — Gotcha!!!

Hello, again reader… Today, I will discuss a gotcha I ran across with SQL Server Temporal Tables. In my day-to-day environment, we do not use Temporal Tables widely.  However,...

2022-11-21 (first published: )

609 reads

Blog Post

Log Shipping – Standby Mode

Hello, dear blog reader. This week’s blog is coming to you from the home office. Finally, my son is back in school, and the house has some peace. For...

2022-09-05 (first published: )

241 reads


Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS


One of the nice things about the Microsoft Connector for Oracle is that it...

ChatGpt Experiments–Getting Documentation


I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska


jouska – a hypothetical conversation that you compulsively play out in your head –...

Read the latest Blogs


Can't Restore DB

By water490

hi everyone I need to get a copy of a stored proc from backup...

How Can I Speed This Query Up?

By water490

Hi everyone My SQL query is close to 1000 lines with 17 separate calcs...

partitioning a huge table

By anoop.mig29

Hi folks I would like to get your views about  partitioning  a huge table...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers