Restrictions On A System Database

2016-02-29 0 Comments

SQL Server System Databases

As many of you know, the [model] database is used as a template for newly created databases on SQL Server. I don't tend to make too many changes to [model]. I'll set file parameters for autogrowth. I may set the RECOVERY MODEL. I may even go so far as to add a USER, for example. That's about as far as it goes, unless there's a specific business need on a particular instance.


My Favorite Answer

2016-02-14 0 Comments

What's my favorite answer? I know what you're thinking: "It depends." That's a great answer, but it's not my favorite (it's a close second, though).

SQL Server Certification Path

2016-02-07 0 Comments

One of my recent goals was to finish up my MCSA certification for SQL Server. After finishing 70-461 and 70-462, I only needed to pass one more test: 70-463: "Implementing a Data Warehouse with Microsoft SQL Server 2012".