In the Previous blogs we have seen about virtual memory related concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.html
We came across concepts like Address Window Extension, Physical...
2016-02-24 (first published: 2016-02-22)
4,055 reads
Until now we have seen the windows memory addressing concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html
So how exactly are user applications like SQL server assigned to...
2016-02-09
2,617 reads
In the previous blog we saw the difference between Virtual Address Space between 32-bit and 64-bit systems. We also saw...
2016-02-05 (first published: 2016-02-01)
4,709 reads
Just a few days back I was asked a very basic question related to AWE and /3GB switch.I was surprised...
2016-01-28
4,795 reads
Hi Guys,
In the previous blog I took you through PowerShell basics We know that PowerShell to works with different modules...
2016-01-21 (first published: 2016-01-13)
2,566 reads
Windows PowerShell is all about exploring .NET framework capability through the command line.Announced in 2006 it’s an admins paradise with...
2016-01-20 (first published: 2016-01-12)
2,535 reads
For all those still using Microsoft Word to take memos, prepare templates for email, preparing to do lists or even...
2016-01-05
971 reads
In the previous blogs we came across various encrypt functions like ENCRYPTBYKEY(),ENCRYPTBYASYMKEY(),ENCRYPTBYCERT().We also saw the corresponding decrypt functions likeDECRYPTBYKEY(),DECRYPTBYCERT(),DECRYPTBYASYMKEY(),DECRYPTBYCERT(),We shall...
2015-10-15
1,505 reads
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
558 reads
Encryption is a methodology used to hide confidential information from any illegitimate user is such a way that they do...
2015-10-10
1,600 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Think there's a reason why this is still in preview, but have someone manage...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers