TSQL Challenge 18 - Generate text formatted month calendars
Can you generate a calendar with T-SQL? Take this month's challenge.
2009-11-30
3,924 reads
Press Release
The WorkTamer Conference
The Worktamer conference is coming to a series of cities in Canada in early 2010. If you're near Vancouver, Toronto, or Montreal, read about this one day event to help you boost your professional development.
2009-11-19
291 reads
TSQL Challenge 17 - Creating cross rows references with inline hyperlinks
Here is a real world scenario I came across on the MSDN forums. The forum poster wanted a method to dynamically create HTML hyperlinks, for keywords/phrases , within the description of the current column text. Enter this challenge and see how your T-SQL skills match up.
2009-11-16
2,633 reads
2009-11-06
26 reads
The ADO.NET Managed Providers team wants to hear your opinion
Take this survey and help out the Managed Provider team at Microsoft.
2009-11-05
795 reads
Top Ten Reasons to Attend the 2009 PASS Community Summit
There are some good reasons to think about attending the 2009 PASS Community Summit.
2009-10-22 (first published: 2009-03-24)
4,544 reads
SQL Bits IV
Coming to Newport in the UK on Nov 19-21, be sure to register and attend if you are nearby. A few days of great SQL Server training.
2009-10-21 (first published: 2009-09-21)
1,904 reads
Data Cleansing with the SSIS Data Flow
A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.
2009-10-21 (first published: 2009-10-19)
5,648 reads
Ask SQLServerCentral
We have expanded our forums with a new Question and Answer site based on the StackOverflow codebase. Please feel free to visit.
2009-10-12 (first published: 2009-10-09)
861 reads
The SQL Connectivity Team wants your opinion
Take this survey from the SQL Server developer team at Microsoft.
2009-10-06
898 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