What is the Best Way to Test SQL?
Over the past five or so years, encouraging progress has been made with regard to testing .NET application code...I wish I could say that the same progress had been made with testing SQL.
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install. One of the things I always says is the greatest thing about SQL Server is any idiot can install it. The other thing I also say is the worst thing about SQL Server is any idiot can install...
Sending E-mail from SQL Server 200X
From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.
Windows Server Virtualization: Hyper-V, an Introduction
For SQL Server and Exchange Server, Windows Server Virtualization is going to be increasingly important as a way for the administrator to allocate hardware resources in the most efficient way, provide more robust services, and deploy services. Jaap Wesselius starts his new series on Hyper-V by explaining what Hyper-V is, how it relates to Windows Server 2008 and how it compares to ESX, Virtual Server and Virtual PC.
Automating tests for T-SQL code
Learn how you can write test automations for T-SQL code using T.S.T. New author Ladislau Molnar has a great project on Codeplex that can help improve your testing.
Creating Indexed Views - SQL School Video
An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.
Documenting Database Code: Structured Headers
When you're doing any database development work, it won't be long before you need to seriously consider the documentation of your routines. Should we, as a community, propose a common standard for T-SQL headers, and the information that should go into them?
Copy Only Backup for SQL 2005 and SQL 2008
Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?
Execute SQL and Bulk Insert Tasks in SSIS
Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.
Tips on Getting Hired – Part 4
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake of thinking it will always be easy. Equally, finding a good job is harder still. Some more tips for you to consider: Leverage your recruiter. They know..
Blogs
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
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...
Forums
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers