Saturday, January 31, 2009

Every so often, I have to do database administration activities, like restore a database (typically a DotNetNuke database downloaded from a hosted site).

I know the details are in the SQL BOL, but I usually have to hunt for them. Pinal Dave's site comes to the rescue with a good abbreviated rundown of the RESTORE commands.

Pinal Dave's site is packed with lots of useful database information and I would highly recommend it to up and coming DBAs. He is a regular columnist for SQL Server Magazine.

 

1/31/2009 6:01:50 PM (Eastern Standard Time, UTC-05:00) |  | Blogs | Microsoft MVP | SQL | SQL Server 2005 | SQL Server 2008 | SQL Server Magazine#
Tuesday, April 01, 2008

I have written a lot of SQL that involved date conversions. But I may be on a project that is offsite, and do not have access to a library of routines, so I end up scratching my head and looking on the Internet.

Lots of folks have done excellent write-ups on Transact-SQL data conversions. Here is just one that I found useful by Manuj Bahl:

Date and Time Manipulation in SQL Server 2000

 

4/1/2008 10:43:07 AM (Eastern Daylight Time, UTC-04:00) |  | SQL#
Search
Archive
Links
Categories
Admin Login
Sign In
Blogroll
 CTO 2.0
Antonio Chagoury
Dot NET Ramblings
Brian Noyes
 New Entry
 SharePoint Resources
Lamont Harrington
 Winsmarts
Sahil Malik
Themes
Pick a theme: