The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
An interview with the Exceptional DBA of the Year
Dan McClain was voted the Exceptional DBA of 2008 by the SQLServerCentral.com community. Learn a bit more about this talented professional in his own words.
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
Reporting Services: Read Data from SSAS and SQL Server in One Dataset
Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.
Administering your Windows Internal Database (MICROSOFT##SSEE) instance
Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database, more and more system administrators charged with managing WSUS and WSS are faced with the challenge of managing these databases. Since most of these system administrators are not full-fledged DBAs, how do they manage the Windows Internal Database?
Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation
Part 1 of this series discusses the prerequisites for SQL Server cluster installation. Subsequent installments will provide step-by-step examples of SQL Server 2008 cluster installation.
The Release Schedule
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
The Release Schedule
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
The Release Schedule
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
Adding a timestamp to files in SSIS - SQL School Video
Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.
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