SQL Server Encryption
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
Blog Posts
SQL server encryption – Asymmetric Keys
In the previous blog we learnt about symmetric key encryption. We also learnt through an example how data is stored...
2015-10-10
3,661 reads
SQL server encryption – Certificates
In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...
2015-10-10
806 reads
SQL server encryption – Symmetric Keys
In the previous blog we learnt about encryption and a brief about the SQL server option provided for data protection...
2015-10-10
796 reads
Deployed Target Metadata with PoSH
Having just covered the methods to discover the metadata for a deployed session including the details about the session settings,...
2015-10-09
559 reads
Deployed Target Metadata with PoSH
This article shows a deeper dive that will show how to expose the Deployed Target Metadata with PoSH and familiarity with this powerful tool.
Related Posts:
PowerShell to Backup XE Session...
2015-10-09
4 reads
Excel Tip #29: Forcing Slicers to Filter Each Other when Using CUBE Functions
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-10-09
899 reads
How do you choose a source control system for your SQL Server database
If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.
If you...
2015-10-09
3 reads
How do you choose a source control system for your SQL Server database
If you already have a source code repository for your app code or other databases or you have another team...
2015-10-09
407 reads
How do you choose a source control system for your SQL Server database
If you already have a source code repository for your app code or other databases or you have another team...
2015-10-09
34 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers