SQL Server 2008

Using Model to Change Default Database Settings

During a Twitter conversation today Malik Alamin (Twitter) asked about the Autogrow settings on his databases. The conversation naturally progressed to the question of how you change the default behavior and set all newly created databases to have user defined settings. Brent Ozar (Blog | Twitter) was able to point us in the right direction [...]

0 comments More…

Book Review: Microsoft SQL Server 2008 – Implementation and Maintenance – Self Pace Training Kit

A few months ago I reviewed my training plan for 2009 and realized I needed to update my certifications and take the SQL Server 2008 – Implementation and Maintenance Exam 70-432. While I felt I had enough experience and knowledge to take the exam I wanted to ensure I would be comfortable with all of the areas covered by the exam. I turned to my training plan on Microsoft’s Learning site and purchased the recommended book by Mike Hotek (Twitter)

4 comments More…

MS Access ODBC Connetion Timeout Error

There are some of us unfortunate DBAs out there that are forced to support MS Access connections to our database. I am one of those poor souls.

I manage a Microsoft Dynamics NAV database with over 26,000 tables. When one of our users was trying to create a linked table in Access 2007 he was presented with a ODBC–call failed Timeout expired (#0) error.

9 comments More…

SQL Server Trace Flags

During a recent project to deploy Microsoft Dynamics NAV I ran into an error that required me to set the trace flag 4616. In a my previous post, Microsoft Dynamics NAV Trace Flag 4616, I covered the error and how to set the flag. This post will dive deeper into trace flags. Trace flags are [...]

0 comments More…

Microsoft Dynamics NAV Trace Flag 4616

Connecting to a Navision Database on a new server will generate an error about the trace flag 4616 not being set. Below are the instructions on how to correct this error. The trace flag is a global flag that is set on the entire SQL server instance through the advanced properties tab in the SQL [...]

6 comments More…