fn_fixeddrives() : an alternative for xp_fixeddrives
The idea is to create a SQLCLR table valued function that returns all information on drives in a UNIX df-like style.
2010-09-21
9,876 reads
David Baffaleuf
Turn on CHECKSUM after an upgrade
When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.
2010-07-20
7,213 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Pandanaran Telpon/wa:0821°8168°291
BCA KCP Pandanaran Telpon/wa:0821°8168°291.No. 101 A, Jl. Pandanaran, Mugassari, Kec. Semarang Sel., Kota Semarang,...
BCA finance TLP/WA 0821-697-7701
FC8R+CHV, Jl. Syeikh Baing Yusuf, Nagri Kaler, Kec. Purwakarta, Kabupaten Purwakarta, Jawa Barat 41119
BCA KCP Wahid Hasyim. Tlp:08218168235
Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers