Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
54 reads
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
54 reads
After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...
2013-03-21
52 reads
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
175 reads
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
491 reads
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
422 reads
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
74 reads
In this post I am going to walk you through creating a virtual environment from the ground up to play...
2012-11-19
51 reads
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
107 reads
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
41 reads
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
195 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item 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