The SQL Server BI Quiz
From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.
2011-06-02
2,796 reads
Press Release
Red Gate extends freedom of mobile SQL monitoring
Red Gate has released SQL Monitor 2.3, providing improved data analysis and the ability to receive alerts through PagerDuty.
2011-06-01
1,002 reads
Nominations open for Exceptional DBA of 2011
The Exceptional DBA contest is running again in 2011 and nominations are now open. Please submit yourself or a colleague for a chance to win some great prizes and be recognized as an amazing data professional.
2011-05-25
532 reads
SQL Skills Immersion Event Wrapup
A look back at SQLskills Immersion training from Eric Stefani, who attended the week long class recently. SQLskills provides some amazing training, and is worth attending if want to become better skilled at being a DBA.
2011-05-10
2,395 reads
SQL Diag Configuration Tool
SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL Server. This tool is shipped with the SQL Server product. Howerver there is not an easy way to configure the tool - it requires the hand editing of an XML file, which is tedious and error prone. That is until now!
SQL Diag Configuration Tool (SDCT) is an intuitive, easy to use tool that will read existing sqldiag.xml configuration files, allow you to select your desired options and save those options to a new file.
2011-04-29
3,589 reads
SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available
You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.
2011-04-25
2,610 reads
SQL Server Webinar Series #9: Streamlining SharePoint Recovery
Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.
2011-04-21 (first published: 2011-04-12)
3,293 reads
Database Normalization Webcast
Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. Thur, Apr 21, 2011, 12:00pm EST.
2011-04-20
2,723 reads
Webinar: Business Intelligence Development using SQL Developer Tools
This webinar, presented by Noemi Moreno, BI Developer at Red Gate Software, will consist of a 30 minute software demonstration followed by Q&A. You will see SQL Developer tools in action, and how they can simplify and enhance your Business Intelligence applications. This takes place on Apr 19, 2011 from 4pm-5pm GMT.
2011-04-19 (first published: 2011-04-07)
5,115 reads
SQL Saturday #73 - Orange County, CA
A free one day training event on Apr 9, 2011 in Huntington Beach, CA. Come learn about SQL Server with a number of SQL Server experts.
2011-04-06 (first published: 2011-03-25)
3,225 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