Back Yourself Up
Ever thought about yourself as a resource that should be backed up to minimize your loss?
2018-09-05
89 reads
Hakim Ali
Birds of a Feather
What makes SQL Server professionals stick together? Can we draw any conclusions from this?
2017-07-10
121 reads
Two Approaches to Addressing Circular References in SSDT
Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation.
2017-06-12
11,876 reads
What Kind of DBA Are You?
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
2015-09-07
305 reads
A Complex Database Project in Visual Studio SSDT
One Way to Handle a Very Complex Database Project with Several Databases and Cross References
2015-05-19
11,967 reads
2013-07-26
604 reads
Tables and Clustered Indexes Part 2
A table does not so much 'have' a clustered index as a table 'is' a clustered index.
2013-07-22
6,507 reads
Universal Product Codes: a Database Primer
An introduction to Universal Product Codes with code to help you use them in your database.
2013-02-28
6,562 reads
Can a Table Really Have a Clustered Index?
A table doesn't so much "have" a clustered index as a table "is" a clustered index.
2012-12-24
8,356 reads
Code Reviews Must Be Brutally Honest
Today we have a guest editorial from Hakim Ali. Today Akim talks about why holding back out of politeness in code reviews may be a self-defeating practice.
2012-08-06
352 reads
Blogs
A DevOps Workshop Tomorrow in Atlanta
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Stop Wasting Time Rebuilding Indexes Every Night
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
Forums
Question on SQL Query with NOT condition
I have a record, in those the three columns where firstname / last name...
Execution Plan Operators
Comments posted to this topic are about the item Execution Plan Operators
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Question of the Day
Execution Plan Operators
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers