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
593 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,923 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,173 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
578 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
326 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
459 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,360 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,884 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers