xSQL blog

Blog Post

In-memory tables in 60 seconds

As a SQL Server DBA or developer here is what you should know about memory-optimized tables (in-memory tables):

Introduced in SQL Server 2014
Primary store is main memory, second copy maintained on...

2016-10-13

1 reads

Blog Post

Temporal Tables in 60 seconds

If you've ever designed a database you've most certainly run into the need for what we called history tables, those tables that stored the history of row changes (sometimes...

2016-10-11

1 reads

Synchronizing NOT NULL Columns

Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data
Compare v7.0.0 – v9.0.0

Description: Using
xSQL Schema Compare and xSQL Data Compare to keep the tables of two databases
in sync...

2016-10-06

2 reads

Blogs

Grinding Away: Mary Spender

By

A few years ago I stumbled on this video and loved it. That led...

PASS Summit 2024 – A new experience

By

I attended the PASS Data Community Summit held in Seattle in person this year...

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

Read the latest Blogs

Forums

How do I fix the, "Unable to process the existing user settings" error message?

By Rod at work

I'm sure I've asked this question in either this forum, or another one, in...

Cannot restore new DB

By Edvard Korsbæk

I have made an empty DB called "HJEM_BB" I try to fill it from...

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

By Noman072

Comments posted to this topic are about the item How to Avoid Incorrect Results...

Visit the forum

Question of the Day

The AG Secondary Logs

What happens when an AG secondary receives a log record from the primary?

See possible answers