SQLCE Workshop III - Getting started with 3.5 Beta
Part 3 of his series looking at SQL Server Compact Edition, then embedded version of SQL Server. This time we look at the new version that's in beta.
Toward Integrity Part 4
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
Creative Ways to Use the TOP Clause
Gregory Larsen discusses how to use the TOP clause to help solve requests where you want to restrict the number of records returned based on a record count.
CTEs and Trees
Some new interresting points about trees and CTE in SQL Server : transforming a tree from auto reference to interval model (nested sets), calculating levels in interval model, creating a view of auto ref from an interval model, hierarchical numbering of items, and more. This article includes more examples based on his previous work.
SQL Stored Procedure to Log Updates, Independent of Database Structure
How many DBAs need a solution to track those changes made for multiple systems? Auditing is becoming more and more prevalent in all systems and having a good solution can really make your DBA job interesting. New author Keren Ramot brings us his technique that works indepedent of the database structure.
The December Energy Update
Steve Jones takes a look at what's happening in the world of alternative energy, including cleaner nuclear power and energy from motion.
Kimball University: Handling Arbitrary Restatements of History
How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.
Optimize T-SQL data types in SQL Server
To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.
Automated Monitoring Database Size Using sp_spaceused
Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that.
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