Rexiology::Work

Microsoft, Information Technologies...

Community

News

  • From Taiwan, living and working at Tokyo, Japan.




Recent Posts

Tags

Microsoft Sites

Other Sites

Blog pools

Bloggers

Archives

Site Info



Locations of visitors to this page




Logos & Chicklets


GeoURL


Rex's Certifications
Rex's Certifications


Creative Commons授權條款
本 著作 係採用
Creative Commons 授權條款



Browse by Tags

All Tags » Database (RSS)
SQL Server 2008 RTMed!!
crosspost from http://blogs.msdn.com/rextang for the long waiting, at 8/6 PST time, SQL Server 2008 finally RTMed! checkout press release here: http://www.microsoft.com/presspass/press/2008/aug08/08-06SQLServer2008PR.mspx download place here: http://msdn...
Forcefully detach mdf file in SQL Express...
crosspost from http://blogs.msdn.com/rextang [via http://www.mssqlonline.com/?p=14 ] when you want to force a detach of sqlexpress mdf file, while there are still other processes currently using it (or normally when there were still connections remain...
Forcefully detach mdf file in SQL Express...
crosspost from http://blogs.msdn.com/rextang [via http://www.mssqlonline.com/?p=14 ] when you want to force a detach of sqlexpress mdf file, while there are still other processes currently using it (or normally when there were still connections remain...
asp.net: checking session size in SQL Server ASPState DB...
crosspost from http://blogs.msdn.com/rextang by setting asp.net application to save session state into SQL Server database, not only can scale application out with multiple web servers, but also provided a way to investigate session usage. Saving session...
T-SQL: Convert Hex String to VarBinary...
crosspost from http://blogs.msdn.com/rextang Here is some conversion functions in SQL Server... To convert between int and hex values, by referring to this post : SELECT 'Int -> Hex' SELECT CONVERT(VARBINARY(8), 16777215) SELECT 'Hex ->...