In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking
Read More...
Good news for the Development DBAs to have a fature of searching for a particular object within the SQL database. The newest feature to SQL Server 2008 version will be 'object search'! Until now even for me I used to refer to ThisArticle to search for
Read More...
By now you might have seen on blogs and documentation that there are new datatypes introduced in SQL Server 2008, they are: DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type with variable precision DATETIMEOFFSET - timezone aware/preserved
Read More...
As you have seen since SQL Server 2005 release the sample databases are not included and as I mentioned in SampleDBs blog you have to download from the SQL Server Samples Web site. Also SQL 2008 BOL will no longer include the databases & applications,
Read More...