SQL Server 2008 R2 Update for Developers Training Kit
It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of...
2010-02-05
591 reads
Blog Posts
SSRS Commonly Required Date Expressions
Reporting Services has many expressions that can manipulate date fields. These expressions can be used just about anywhere in SSRS...
2010-02-05
5,890 reads
They Took Our Name!!
I’ve heard imitation is a form of flattery, and I guess that’s true. Today I got an up close and...
2010-02-05
375 reads
Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008
I had a little bit of excitement with one of my production servers couple of days ago, that I thought...
2010-02-04
3,140 reads
February Question: What is one of your best practices for making full backups and transactions log backups of your production databases?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-02-04
576 reads
I think it’s a hole
The other day I was trying to help someone that had removed the BUILTIN/Administrators logins from their instance without first...
2010-02-04
817 reads
oPASS Meeting Reminder – February 9, 2010
Our next meeting is February 9, 2010, We’ve got Ronald Dameron coming to speak this month on Database Hardening using...
2010-02-04
325 reads
PASS Update #23
January has been a slow month for me as far as PASS involvement, I show about 10 hours logged for...
2010-02-04
452 reads
Searching for Objects or Text Strings Using SQL Search
As a DBA, at one time or another, you will need to quickly find an object within a database, such...
2010-02-04
4,326 reads
SQL Server Default Trace
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...
2010-02-04
3,879 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers