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)
3,972 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,580 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,509 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,553 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,557 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,524 reads
For all those still using Microsoft Word to take memos, prepare templates for email, preparing to do lists or even...
2016-01-05
965 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,492 reads
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
545 reads
In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...
2015-10-10
794 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 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...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers