Geeky Entertainment
As a break from work, this week Steve Jones wants to know what you wish for. Are there comic book, science fiction, or technological thrillers you'd like to see made into movies?
See Grant Fritchey and Steve Jones at SQL Intersection
Come see Grant Fritchey and Steve Jones (from Red Gate Software) and many more SQL Server experts while you enjoy spring in Orlando, FL at SQL Intersection.
Calculating Gaps Between Overlapping Time Intervals in SQL
There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a number of techniques around that work, but finding ones that scale well makes for a tougher, but interesting, challenge.
Fixing CREATE TABLE
Steve Jones has a problem with the inconsistency of the CREATE TABLE statement in SQL Server and has an idea on what to do.
Identify the Backup used to Restore the Database
This article will help us identify the backup which was used to restore the database. This may seem simple when the database backup is from the same server but the complications begin when the backup is not from the same server.
DBAs Checklist for Designing and Reviewing SQL Server System Architectures
In this tip, Sadequl Hussain will try to list a few areas DBAs need to cover when they are designing new systems or reviewing proposed solutions.
Caching
A SQL Server database can easily be seen as a bottleneck as all data must be retrieved from a single machine. However a caching strategy in your application and alleviate load and improve performance.
SQL Server Indexed Views: The Basics
Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren't there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They're great in certain circumstances but they represent a trade-off, and they come with considerable 'small print'. Jes Borland explains.
Lawsuits and Data Breaches
Steve Jones notes that a data breach resulted in a lawsuit. How long before that's a common practice, and should we be preparing as data professionals.
Blogs
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers