SQL and Skiing – SQL Saturday #183
This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a...
2013-01-30
1,497 reads
Blog Posts
SQL Server – Attach Database with MDF file only
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,717 reads
SSIS 6 Million Rows in 30 Seconds using standard laptop
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,753 reads
Are You A Technical Expert or Manager?
Expert or Manager? Why not both.
Are you a Technical Expert or a Manager? You certainly cannot be both.
At least that’s...
2013-01-29
965 reads
Are You Signed Up for 24 Hours of PASS–Business Analytics?
If you have not signed up for the 24 Hours of PASS-Business Analytics you should be. This is a great...
2013-01-29
1,367 reads
Clustering Concepts for the Common Man
SQL Server clusters are widely used, and widely misunderstood, which makes people like our good friend (and clustering MVP) Allan...
2013-01-29
1,441 reads
Cultural Anthropology and Business Intelligence–A Tribute to Dr. Thomas C. Correll
A tribute is an expression of gratitude or praise. Last year I started a series about individuals who have impacted...
2013-01-29
1,623 reads
Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files
It’s day 23 of my 31 Days of Disaster Recovery series, and today’s blog post is inspired from an email...
2013-01-29
1,582 reads
My view isn’t reflecting changes I’ve made to the underlying tables.
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change.
Over...
2013-01-29 (first published: 2013-01-21)
3,847 reads
New Year Aspirations – Christian Bolton – Author
As a former mentor Christian is used to me asking him all sorts of random questions, but this time it’s...
2013-01-29
1,535 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers