TSQL Challenge 18 - Generate text formatted month calendars
Can you generate a calendar with T-SQL? Take this month's challenge.
Converting a File with Parent-Child Records in SSIS
Convert a file with multiple record types that have a parent child relationship.
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
Deploying Reports on Windows 7
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
How to simulate transparent data encryption (TDE) with SQL 2000 and 2005
Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.
Increase Your Value as a Professional in the Technical Industry
It has never been so important to enhance your employability as it is today. Job security can never be taken for granted. Employability, increasing your professional value, means far more than just collecting qualifications, as Dr Masha Petrova explains: It also involves communicating, writing, and participating in communities.
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers