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.
San Jose, CA - SQL in the City Seminar - Deployment Stairway
The day before SQL Saturday Silicon Valley, SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on March 14 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
Using hash values in SSIS to determine when to insert or update rows
A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU SALATIGA Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa...
Alamat Kantor BCA KCU MAGELANG Telp:0817839777
WhatsApp: 0817839777 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers