Endi Zhupani is a university graduate from Tirana with a degree in Information Systems. He currently works for Pragmatic Software, a company in Tirana that develops transaction and operation management systems as web applications. Throughout his entire development experience, Q&A and blog posts from other developers have saved my day more times that he can count, so he thought he’d start giving back by writing about my work and solutions he has come up with for some interesting problems.

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

12 reads

Blog Post

Stretch Databases in 60 seconds

SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...

2016-10-12

11 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

14 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

13 reads

Blogs

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

does anyone used https://github.com/ktaranov/sqlserver-kit

By ARUN KUMAR AGUNURU

Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...

How Can Database Performance Improve the Overall Website Experience?

By Brooks-Hayward

I’ve been looking into ways to improve the connection between a website and its...

When And How to Automate?

By AndrewGuard

Comments posted to this topic are about the item When And How to Automate?

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers