Code I’d Hate To Live Without: T-SQL Tuesday #104
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...
2018-07-19 (first published: 2018-07-10)
3,646 reads
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...
2018-07-19 (first published: 2018-07-10)
3,646 reads
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...
2018-07-16
1,081 reads
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...
2018-07-13 (first published: 2018-07-02)
2,004 reads
This crossword puzzle is based on the contents of the Stairway to AlwaysOn.
2018-07-11
169 reads
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,169 reads
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,388 reads
When I think of the public role I often think of the guest database principal (user) at the same time....
2018-06-25
280 reads
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...
2018-06-22 (first published: 2018-06-12)
2,397 reads
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just...
2018-06-18
792 reads
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time...
2018-06-15 (first published: 2018-05-30)
2,909 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
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