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
Blog Posts
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
558 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
3 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
897 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
406 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
33 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
41 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
2 reads
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...
2015-10-09
433 reads
SQL Server Contracting - The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-09
183 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers