Is Software Engineering Dead?
Software engineering is seen as a dead end career choice, at least by some people. Steve Jones disagrees.
Snapshot Isolation Level in SQL Server - What, Why and How - Part 1
Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
Guide to MCITP: SQL Server 2008 BI Developer
A guide to the SQL Server 2008 Business Intelligence exams.
Time for Your Career
This week Steve Jones wants to know if you can find time for your professional development. Regularly improving your skills is an important part of your career in technology, and the poll this weeks asks what time you can make for improvement.
The T-SQL of CSV: Comma-Delimited of Errors
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.
Performance Test of New Date Manipulation Functions (SQL Spackle)
Performance test of new SQL 2012 functions DateTimeFromParts and Format
Teambuilding and Bonding
Steve Jones attended a day out from the Red Gate offices recently and he talks about the value of those experiences.
Export data to an earlier SQL Server version
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort.
Setup SQL Server on Amazon RDS
Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)
SQL Server on RDS
Amazon now offers SQL Server 2008 R2 in their RDS service. It's an easy way to get working with SQL Server with a minimal investment.
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
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers