2015-07-22
1,246 reads
2015-07-22
1,246 reads
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,099 reads
Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL...
2015-07-16
702 reads
Hi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s...
2015-07-14
692 reads
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
590 reads
Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query...
2015-07-06
359 reads
Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....
2015-07-03
338 reads
In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we...
2015-07-02
376 reads
Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause. So first...
2015-06-30
893 reads
Hi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server...
2015-06-27
748 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers