Setting Up SQL Server: People Still Need Help

Erik points out a few things that SQL Server should offer to configure by default.

SQL Server DBA On-Boarding Checklist

How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one?

Memory

SSIS for Multiple Environments

In this article, Zach Mattson shows us how you can set up SSIS to handle multiple application environments and easily move packages from development to QA to production.

Set standard database options

Ensure all your databases have standardised options by running this script weekly.

Finding all occurenses of a field in a databaes

HI. Can someone tell me of an easy way to locate all the occurences of a particular field name in all tables of a particular database? For example: I'm looking for the field named 'first_name'. I want to know all tables that this field resides in a particular database.Thanks, Juanita 

RE: ACCESS VIOLATION

Nonetheless, such AV should be reported to MS tech support because it is a bug. Microsoft will most likely not charge you with it if you can prove it is a bug. SQL Server should error out nicely with "Constraints Violation". Unreported bugs will not be fixed and will propagate to the next version and […]

cant get textbox repeat with data region

Has anyone had any experience of making"Repeat report item with data region on every page" work for a textbox in reporting services by any chance? Basically in the body of the report I have a table with data and some textboxes outside and above the data region to display more of a header information, which I'd like to show on everypage […]

RE: Why would SA not have all Rights?

What service account do you use to start SQL Server and Agent services? Is it in local administrator group?

RE: permissions to start sql server agent

You always have the option attacking this via other methods: 1) In Windows 2000, you can set the service to restart itself (services.msc). This is the easiest approach. 2) You can have a monitoring process that looks for SQL Server and SQL Server Agent and makes sure they are running. If they aren't, it restarts […]