Confessions of a DBA – Part 3
After reading this confession, I am sure almost every DBA is going feel a churn in their stomach. They are...
2011-04-14
2,052 reads
Blog Posts
Get all SERVERPROPERTY values for SQL Server
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
13,291 reads
Optimising SQL Server for Sharepoint 2010
I attended the SharePoint Best Practices Conference this week in London. As a complete newbie, this event was superb - a...
2011-04-14
1,879 reads
Performance Tuning: Start to Finish
The very first ever SQL Rally is taking place in a little less than four weeks in Orlando Florida. It’s...
2011-04-14
1,347 reads
Powershell Day 14
Day 14 Tools and more info As Powershell is a global language and its open to explore. So many great...
2011-04-14
567 reads
Re-Blogging Posts
Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. ...
2011-04-14
448 reads
A SQL Server Hardware Nugget A Day – Day 13
For Day 13 of this series, we will cover Intel Turbo Boost Technology. This is not like the the old...
2011-04-13
503 reads
Andy Leonard’s great idea: SQLPeople events
Not too long ago, Andy Leonard (blog|twitter) dreamed up the idea to create the SQLPeople community. The community is forming...
2011-04-13
874 reads
DBCC TraceOn – some processes are global.
Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...
2011-04-13
2,653 reads
Powershell Day 13
Day 13 Other XML: Powershell support XML, as XML is a language which works great for windows, and it’s like...
2011-04-13
681 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