SQL server encryption – Certificates

In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...

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...

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...

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,...

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...

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...

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...

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...

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...

log reader uses single CPU

For replication even if you have multi core CPU it uses only one as log reader agent has single threaded...