The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
Table-Valued Parameters in SQL Server 2008 let you pass many rows to a stored procedure without a temp table. I walk through the steps with a Department example.
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
Configure Database Mail in SQL Server 2008 in three steps: create a profile and account, configure email, then send email. Video and screenshots included.
SQL SERVER – Introduction to Log Viewer
The SQL Server 2005 Log Viewer shows SQL Server error logs, Agent logs, Database Mail and Windows event logs in one place, ready to filter and export.
SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations
Two convenient SQL Server 2008 features: inline assignment with DECLARE @idx INT = 0, and inline operations like SET @idx += 1. Fewer lines than before.
SQL SERVER – Create Database Error in Windows Vista
A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.
SQL SERVER – 2005 – Connection Strings For .NET
SQL Server 2005 connection strings for .NET, ODBC and OLE DB with SQL Native Client: standard security, trusted connection and named instance examples.