Creating ER Diagrams with MS Visio

Getting Started with MS Visio
As soon as you start Visio you will either need to identify a new drawing type (category) or select an existing file. For this example, select a new drawing with the Database category and the Database Model Diagram template.
http://www.sethi.org/classes/cet415/lab_notes/lab_03.html
OR
http://www.databasejournal.com/features/oracle/article.php/3529531/Database-Modeling-Using-Visio.htm

How to import and export binary LOB into and from SQL server

Part 1 - Insert image into database

CREATE TABLE Documents (DocID int, Doc varbinary(max))
INSERT INTO Documents (DocID,Doc)
SELECT 1,* FROM OPENROWSET(BULK N’C:\temp2\pic1.gif’, SINGLE_BLOB) as AXA
select * from dbo.Documents
Part 2 - Documents.fmt
9.0
1
1       SQLBINARY     0       0       “”   1     Doc                                       “”
Part 3 -Export image into gif of jpg file or any other format
–EXEC usp_ExportBinaryFiles 1,’C:\temp\’
–BCP “SELECT Doc FROM TRACES.dbo.Documents [...]

Reading the SQL Server log files using T-SQL

http://www.mssqltips.com/tip.asp?tip=1476

sys.dm_os_performance_counters Explained

http://rtpsqlguy.wordpress.com/2009/08/11/sys-dm_os_performance_counters-explained/
http://www.sqlmag.com/article/tsql3/making-sense-of-sysperfinfo.aspx

Using a Dedicated Administrator Connection

SQL Server provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.
By default, the connection is only allowed from a client [...]

Performance Counters 3

SQL Profiler
The SQL Profiler is an extremely useful tool for examining the actual SQL being run on a database and identifying candidate SQL for performance tuning.
It can also be used as an auditing tool for security purposes as it can be configured to include activities such as users logging in & out of the system; [...]

SQL Server 2008 Upgrade Technical Reference Guide

http://sqlblogcasts.com/blogs/ssqanet/archive/2008/12/05/sql-server-2000-to-2005-to-2008-upgrade-technical-reference-guide.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

SQL Server 2008 Service Pack 1 - SP1

Microsoft published SQL Server 2008 Service Pack 1 on 7th of April 2009.
You can download SQL Server 2008 Service Pack 1 using following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en
10.0.1600.22    RTM (Release To Manufacturing)
10.00.2531.00    SP1

Parameter Sniffing & Stored Procedures Execution Plan

According to the white paper, Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 published in the Microsoft Site:
“Parameter sniffing” refers to a process whereby SQL Server’s execution environment “sniffs” the current parameter values during compilation or recompilation, and passes it along to the query optimizer so that they can be used to [...]

SQL Server 2008 Pricing and Licensing

 SQL Server 2008 is available under three licensing models:
- Server plus device client access license (CAL). Requires a license for the computer running the Microsoft server product, as well as CALs for each client device.
- Server plus user client access license (CAL). Requires a license for the computer running the Microsoft server product, as well [...]