SQL Server – Conditions when value of @@error changes
Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...
2016-06-02 (first published: 2016-05-24)
1,365 reads
Kapil Blogs
SQL Server – Change in Identity() Property during transactions
Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on...
2016-05-16
557 reads
Find Unused Database Objects in SQL Server
Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...
2016-05-12
578 reads
SQL Server – Cleaning Procedure Cache for a particular database
HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...
2016-05-11
576 reads
SQL Server – Row Level Security in SQL Server 2016 – Part 3
Hi friends, continuing from the previous post in this post we will learn how to add the blocking predicate to...
2016-05-09
1,014 reads
SQL Server – Row Level Security in SQL 2016 – Part 2
Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You...
2016-05-13 (first published: 2016-05-05)
1,490 reads
SQL Server – Row Level security in SQL Server 2016 – Part 1
Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...
2016-05-03
479 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Merge not supported with memory tables as target
Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables as a Target in...
2016-02-12
615 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...
2016-02-09
527 reads
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,390 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers