Double Compliance
Sometimes auditing for one certification might help you pass another, but don't count on it.
The Memory Cube
A new memory technology has the potential to dramatically speed up access for computer systems.
SQL Saturday #189 - Costa Rica
Join us at SQL Saturday Costa Rica on April 13, 2013 for a day of SQL Server Training and Networking.
SQL Server JOIN Hints
You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.
Insensitivity: A Good Technique?
This article explores the place of emotion among knowledge workers doing team-based design activities.
Generating Sequence Numbers Using the Sequence Object
The new SQL Server 2012 Sequence Object can be used to generate unique numbers that can be automatically incremented based on an increment value. Greg Larsen discusses the different features of the sequence object and how you can use it to generate sequence numbers.
New Custom Metric: Long Running Job
SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.
Development, Operations, or Accounting
Cloud services need to have a much higher quality of work than their in-house equivalents if corporations are to take them seriously according to Steve Jones.
Error logging with Bulk Insert
Bulk Insert statement has an important feature of error logging which is rarely used.
SQL Saturday #211 - Chicago
SQL Saturday is coming to Chicago, IL on April 13, 2013. Join us for a day of free SQL Server training and networking.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers