This year will be my 6thPASS Summit that I will have attended. Some people have asked me why I still...

2017-10-11

328 reads

Identity_Cache feature introduced in SQL Server 2017

by Kapil Singh

Kapil Blogs

Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx

2017-10-11

492 reads

SQL Server Temporal Tables

by Tim Mitchell

Tim Mitchell

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...

2017-10-19 (first published: 2017-10-11)

2,105 reads

Avoid “Constants” in T-SQL

by Matthew McGiffen

Matthew McGiffen DBA

Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...

2017-10-19 (first published: 2017-10-10)

3,681 reads

How NOLOCK Will Block Your Queries

by Bert Wagner

Bert Wagner

Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...

2017-10-10

401 reads

How NOLOCK Will Block Your Queries

by Bert Wagner

Bert Wagner

Photo by James Sutton on Unsplash
Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints. The fact that it applies to NOLOCK queries...

2017-10-10

26 reads

Kill a Connection, Session, or Command in Analysis Services

by Richie Lee

Richie Lee's SQL Stuff

One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...

2017-10-10

3,225 reads

Microsoft Ignite US 2017 – Major Azure Announcements

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog] Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suite –...

2017-10-09

29 reads