TSQLScripts.com – The Rebirth and the Script of the Week
About two years ago I started www.TSQLScripts.com, and initially the response was great. Within two weeks I had received about...
2009-08-26
614 reads
Blog Posts
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
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
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