Transforming Event Log Data
Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...
2012-03-28 (first published: 2012-03-23)
6,047 reads
Chad Miller
Reconciling SPNs
As part of troubleshooting Kerberos authentication for SQL Server I had to verify SPNs so I thought I’d blog about...
2012-02-20
2,465 reads
Sharing Profiles
A question came up in a class I was teaching: “How do you share your Powershell profiles across accounts?”
Well, there’s...
2012-02-11
799 reads
Sarasota IT Pro Camp
Join system administrators IT professionals and database professionals in addition to managers at all levels who work with Microsoft technologies...
2012-02-04
930 reads
Orlando IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.
2012-01-31
1,782 reads
Orlando IT Pro Camp
The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro...
2012-01-10
984 reads
Importing CSV Files to SQL Server with PowerShell
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off another guest blogger week (Nov 28th 2011) with my guest blog...
2011-11-28
3,558 reads
Some SQL Server Security Housekeeping
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using...
2011-11-14
1,658 reads
Delegated SQL Server Administration with Powershell
Providing delegated administration to groups that need to perform various security functions has always been a difficult task, but thanks...
2011-11-07
2,672 reads
Gaining SQL Server SysAdmin Access
I’ve seen this come a few times at work and I’m sure most you have experienced something similar.
Someone or an...
2011-10-22
4,196 reads
Blogs
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers