New Domain - My blog has a new domain name gethynellis.com
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
610 reads
Gethyn Ellis
SQLServerPedia – Awards 2010
The results of the SQLServerPedia Awards 2010 are out....I was nominated in two categories and I won the "New to...
2010-11-10
1,091 reads
Post 100 – A Year Gone (not quite)!
I wasn’t going to make a special effort for the one hundredth post on my blog, I was intending to...
2010-11-05
776 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
595 reads
What’s in a Full Backup?
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it...
2010-11-04
682 reads
TSQL2SDAY #12 - Why are DBA Skills Necessary?
WOW this is the 12th TSQL2Sday albeit this month’s is week early because of the PASS summit next week, so...
2010-11-02
628 reads
Movember – Team IPMO
Some friends of mine decided to support the Movember charity this year. I would try and explain what Movember is...
2010-11-01
712 reads
Bulk Insert Permissions
In order to be able to execute bulk operations you need to certain level of privilege both on the database...
2010-10-28
32,653 reads
What I Did This Weekend
About two weeks ago my good friend and former colleague Justin Hostettler-Davie -JHD (Blog | Twitter) asked me via my wife...
2010-10-18
776 reads
SQL Server Recovery Models
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you...
2010-10-12
1,944 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers