Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,389 reads
Kapil Singh
Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
543 reads
SQL Server – Check the status of active Trace Flags
Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...
2015-12-14
552 reads
SQL Server – Trace flag changes in Dynamic data masking in SQL Server 2016 CTP 3.0
Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...
2015-12-10
483 reads
SQL SERVER – Random function in Dynamic Data Masking in SQL Server 2016 CTP 3
Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...
2015-12-08
579 reads
SQL Server – DROP IF EXISTS in SQL Server 2016
Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets...
2015-11-27
1,133 reads
Steps to create SQL database at Azure
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...
2015-11-26
876 reads
Steps to install SQL Server CTP 3 on Windows Azure
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...
2015-11-23
493 reads
How Client Statistics helps in improving performance in SQL Server
Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...
2015-11-17
492 reads
SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns
Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...
2015-10-26
605 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers