Spinach and Database Development- SQLSatExeter Keynote
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we...
2015-04-30
1,100 reads
SQL DBA With A Beard
Instances and Ports with PowerShell
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...
2015-04-22
1,381 reads
Checking SQL Server User Role Membership with PowerShell
SQLDBAwithTheBeard:
Please go and check the New SQL Bloggers posting here https://twitter.com/search?q=%23sqlnewblogger There are some brilliant new and older bloggers adding great value...
2015-04-24 (first published: 2015-04-14)
5,505 reads
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to...
2015-04-07
783 reads
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...
2015-03-31 (first published: 2015-03-21)
6,904 reads
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
551 reads
Triggering a System Center Configuration Manager deployment task
A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....
2015-03-02 (first published: 2015-02-18)
6,516 reads
Show AutoGrowth Events with Powershell to CSV
This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...
2015-02-25 (first published: 2015-02-15)
6,259 reads
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB....
2015-02-09 (first published: 2015-02-01)
7,661 reads
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office,
not a creature was stirring not even old Maurice.
With merriment going on...
2014-12-23
533 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers