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

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

By

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

DevOps Devour Hour Slides

By

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Advice I Like: Take Two Trips

By

If you have any doubt about being able to carry a load in one...

Read the latest Blogs

Forums

Is there an ISERROR equivalent in SS?

By water490

Hi everyone I have a SP that just failed.  Format of SP is: Select...

Analyzing Tempdb Spills and Usage Across Recursive Queries

By shukla.chandan12

Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...

Creating a new API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new API in...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers