About Jeremiah

I'm a senior database administrator with Cass Information Systems, a SQL Server MVP, director-at-large with PASS, and I also help out with my local chapter and the Application Development virtual chapter.

You can learn more about me or contact me directly.


Google Reader
Google Profile
delicious

An Introduction to SQL Server System Databases

SQL Server 2008 (and 2005) contain five special databases: master, model, tempdb, msdb, and mssqlsystemresource (aka Resource). These databases are used by SQL Server for its own maintenance and management.
master
The master database contains all of the system level information for SQL Server – all of the logins, linked servers, endpoints, and other system-wide configuration [...]

October 19th, 2009 | Tags: , , , | Category: SQL, SQL Server, SQL University, syndication | 7 comments

My First Microsoft Connect Item

I finally feel like a real SQL Server professional! I’ve submitted my first Connect feedback to Microsoft for a new feature of SQL Server: BOL for mobile devices.
This is a dream I’ve had since I first got my grubby little paws on my iPhone. Every day since then I’ve dreamed of having a copy of [...]

April 18th, 2009 | Tags: , , | Category: SQL Server, nonsense, syndication | 3 comments

Links for the Week of 2009.04.10

SQL Server
A Web Based Search for Books Online Buck Woody provides links to macros for MSDN search that will give the search bar in your browser the ability to search online inside Books Online. This has become my go to method for searching BOL. It’s much faster than opening the desktop BOL client and the [...]

April 10th, 2009 | Tags: , , , , , | Category: SQL, SQL Server | 2 comments