Divide and Conquer - Performance Tuning
Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance
2014-04-08
8,533 reads
Articles
14 SQL Server Indexing Questions You Were Too Shy To Ask
The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.
2014-04-08
10,155 reads
SQL Saturday #289 - Orange County, CA
SQL Saturday is coming to Huntington Beach, CA on April 26 2014. This is a free day of training and networking for SQL Server Professionals - there are also 2 paid-for precons on April 25 presented by Jason Horner and Bradley Bell. Register for SQL Saturday Orange County while space is available.
2014-04-08
1,761 reads
Load Testing in a Big Data Environment
Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data?
2014-04-07
4,112 reads
Getting Started in SQL Server
Preparing for your first (or next) interview or job in SQL Server. A good introduction from Craig Farrell.
2014-04-04 (first published: 2010-12-09)
12,839 reads
High Performance Relational Division in SQL Server
Relational division is used in SQL to select rows that conform to a number of different criteria. Dwain Camps explains how to use it, and shows the performance gains.
2014-04-04
3,369 reads
SQL Monitor Custom Metric: Server principals with default database offline
This metric monitors whether a server principal’s default database is offline. When you create a SQL Server server principal (formerly referred to as a server login) it has a default database setting that is used to assist in a connection request when no database is specified.
2014-04-04
2,236 reads
Data Science Laboratory System - Distributed File Databases
Distributed File Databases manage large amounts of unstructured or semi-structured data. Buck Woody shows how to install Hadoop in your Data Science lab to experiment with an example of the breed.
2014-04-03
3,170 reads
How to recover a suspect msdb database in SQL Server
A SQL Server MSDB database is flagged as "suspect"... what can you do? John Grover has some suggestions
2014-04-03
3,669 reads
DEVintersection: Developers, ITHeros, Industry-experts Intersect Here!
Intersect with your favorite Microsoft experts in Orlando, Florida April 13-16, 2014 at this year’s most exciting tech conference: DEVintersection.com. Register with the discount code "RedSimple" for $50 off your registration.
2014-04-02
4,381 reads
Blogs
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,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
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