SQL Server Backup File Confusion - Log Shipping
I saw a post recently where a person working with SQL Server had log shipping setup. They were asking if...
2010-08-03
932 reads
Blog Posts
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would...
2010-08-03
442 reads
A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,989 reads
August Question: What types of continuing education do you use to keep up with being a DBA?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-08-02
606 reads
PASS Update #40 (Elections)
Last week I made it through the first screening of candidates for this years Board of Directors election. Seven of...
2010-08-02
353 reads
SQL Saturday #28 - Two Weeks Away
It’s a little less than two weeks until SQL Saturday #52 in Baton Rouge. I attended last year, and thoroughly...
2010-08-02
359 reads
SQL Saturday 28 Baton Rouge and Ask the Experts
The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks! Have you registered?
I’m honored...
2010-08-02
607 reads
SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
652 reads
SSWUG Ultimate Virtual Conference October 20-22, 2010
I will be presenting four sessions for the SSWUG Ultimate Virtual Conference that will be held online October 20-22, 2010....
2010-08-02
789 reads
What Are You Afraid to Ask?
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
597 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers