Database Version Control

Coding Horror

http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html

http://www.codinghorror.com/blog/2008/02/get-your-database-under-version-control.html

Walkthroughs (Creating and Updating Version-Controlled Database Schemas) http://msdn.microsoft.com/en-us/library/aa833298(v=VS.90).aspx Data Generation / Static Data 1. http://leon.mvps.org/StaticData/ 2. http://msdn.microsoft.com/en-us/library/aa833237(v=VS.80).aspx

SQL Server

SQL Server 2008 - Trouble exploring databases node with newly created user. Grant new user rights for each of the databases with no rights http://connect.microsoft.com/SQLServer/feedback/details/424329/the-server-principal-testuser-is-not-able-to-access-the-database-msdb-under-the-current-security-context https://www.orcsweb.com/blog/desiree/the-server-principal-a-is-not-able-to-access-the-database-b-under-the-current-security-context-microsoft-sql-server-error-916/ http://blogs.msdn.com/b/euanga/archive/2006/05/04/585513.aspx

How to identify your SQL Server version and edition? SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') http://support.microsoft.com/kb/321185

How To: Reset Identity column in SQL Server DBCC CHECKIDENT('Customer', RESEED, 0) http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

List All the Tables for All Databases sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' http://blog.sqlauthority.com/2009/04/26/sql-server-list-all-the-tables-for-all-databases-using-system-tables/

SQL Documentation BI Documenter - http://msdn.microsoft.com/en-us/magazine/ee335714.aspx SQL Doc - http://www.simple-talk.com/sql/sql-tools/database-documentation-using-sql-doc/ Code project - http://www.codeproject.com/KB/database/sqldoc.aspx

Error: Saving changes not permitted Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-–-fix-management-studio-error-saving-changes-in-not-permitted-the-changes-you-have-made-require-the-following-tables-to-be-dropped-and-re-created-you-have-either-made-changes/

SQL Server Performace

Tip of the Day #5 (SQL Server memory usage) http://blog.colinmackay.net/archive/2008/07/20/2996.aspx

SQL Server queries with DMVs for examining bottlenecks *** http://searchsqlserver.techtarget.com/tutorial/SQL-Server-queries-with-DMVs-for-examining-bottlenecks

Using COALESCE to Build Comma-Delimited String

http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string

Download details: Microsoft® SQL Server® 2008 Express with Advanced Services http://www.microsoft.com/downloads/en/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SqlMag article: SQL Server 2008 Express Editions http://www.sqlmag.com/article/sql-server-2005-express/sql-server-2008-express-editions.aspx

SQL Server :: Storing Images and BLOB files

1. Insert BLOB 
   

   INSERT INTO BLOBTest (BLOBName, BLOBData)  
   

    SELECT 'First test file',    
   

     BulkColumn FROM OPENROWSET(Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB 
   

 

http://www.databasejournal.com/features/mssql/article.php/3724556/Storing-Images-and-BLOB-files-in-SQL-Server-Part-2.htm

 

1. Export BLOB 
   

   bcp "select datei from Person.Address WHERE
   addressid=1 " queryout "c:\TestOut.doc" -T -n -Slocalhost\AdventureWorks
   

http://www.sqlservercentral.com/Forums/Topic487470-338-1.aspx