Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-26
1,571 reads
Blog Posts
Would You Like to Do Technical Reviews of Articles for PASS’s SQL Server Standard?
If you haven’t heard yet, PASS has started commissioning articles to be published in the new PDF version of the...
2009-08-26
706 reads
Writing Technical Articles - A Few Simple Tips
A few simple tips that I've learned over the years. Keep these in mind as you write your next article.
That...
2009-08-26
1,036 reads
Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes...
2009-08-25
1,104 reads
Database Mirroring Across Domains, Using Certificates.....
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring...
2009-08-25
6,524 reads
Examing database shared locks using sys.dm_tran_locks
If you’ve worked with Microsoft SQL Server for any length of time, you’re probably already aware that SQL Server uses...
2009-08-25
683 reads
Featured Blogger: Alexander Kuznetsov
I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog...
2009-08-25
718 reads
Kalen Delaney Joins The SQLSaturday Advisory Council
Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we...
2009-08-25
570 reads
New Book
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
561 reads
PASS Board Nominations
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
663 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
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