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,605 reads
Blog Posts
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,889 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,358 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
574 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
460 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
522 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
896 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,664 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
688 reads
A SQL Server Hardware Nugget A Day – Day 12
In Day 12 of this series, we will be talking about AMD Opteron Processor Numbering. Advanced Micro Devices (AMD) has...
2011-04-12
770 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
Alamat Telp BCA KCP Foresta (+62) 838-4945-0961
Wa:083849450961 Kavling Commercial Foresta Lot I-1, Lengkong Kulon, Pagedangan, Kab. Tangerang, Banten, Lengkong Kulon,...
Alamat Telp BCA KCP Pedurungan (+62) 838-4945-0961
Wa:083849450961 Jl. Brigjen Sudiarto No.294, Palebon, Kec. Pedurungan, Kota Semarang, Jawa Tengah 50273
Alamat Telp BCA KCP Mranggen (+62) 838-4945-0961
Wa:083849450961 Jl. Raya Bandungrejo No.102, Bandung, Bandungrejo, Kec. Mranggen, Kabupaten Demak, Jawa Tengah 59567
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers