change control in SQL Server

what kind of management tasks/development tasks/support arrangements go through change control in your SQL Server environment? we are looking to ensure all changes that could pose an issue, i.e. performance/security/availability/reliability go through formal change control processes, but I was looking for some of the common sorts of tasks in SQL where you have to go through change control/approval, and then I wondered how we can identify recent changes made to the SQL Server, to use in checking their was a corresponding change control ticket. Any examples most welcome (as well as examples of standard low risk changes that you dont have to go through change control with).
LVL 4
pma111Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ChrisSenior Technical ArchitectCommented:
change control
creation of new DB's
deletion of DB's
changes to maintenance plans i.e. time it runs, how it runs - this would include backups, reindexes etc incase it conflicts
changes of any settings within SQL
Patching
adding of logins SQL/windows where a standard framework is not established i.e. new database new kind of rights - finance have datareader but not data writer and they want this level of access

incidents\services requests (means its recorded for audit but not formally going through CAB)
adding of logins SQL/windows where a standard framework is established i.e. established database and exisitng rights - finance have datareader access and a new member of the finance team needs this access

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
what sql server version\edition do you use?

The most popular way additionally to .sql files saving and creating object in some test DB
is TFS Team Foundation Server

How to: Use Source Control with SQL Server Management Studio
https://technet.microsoft.com/en-US/library/ms173550(v=SQL.105).aspx

more

Change Management and Source Control
by Grant Fritchey
https://www.simple-talk.com/sql/learn-sql-server/change-management-and-source-control/
SolarWinds® Network Configuration Manager (NCM)

SolarWinds® Network Configuration Manager brings structure and peace of mind to configuration management. Bulk config deployment, automatic backups, change detection, vulnerability assessments, and config change templates reduce the time needed for repetitive tasks.

pma111Author Commented:
thanks all

>changes of any settings within SQL

can you give some examples?
Jagdish DevakuSr DB ArchitectCommented:
There are few settings you need to do if you are using TFS.

The link is already share by EugeneZ.

https://technet.microsoft.com/en-US/library/ms173550(v=SQL.105).aspx

Or you can use some change requests tools:

If your organization uses Sharepoint, then the following link for Change Request Management template.

http://www.microsoft.com/en-us/download/details.aspx?id=528

Manage Engine is another good tool:
https://www.manageengine.com/products/service-desk/itil-change-management.html

Open-Project:
http://www.project-open.com/

You can also find some free open source tools online.

Thanks.
ChrisSenior Technical ArchitectCommented:
these are just some examples

memory allocation for the server\instance
change Processor settings like affinity
authentication methods
change tempDB setings, file locations
network settings for SQL i.e. ports, IP's configured in SQL Network Config
Jagdish DevakuSr DB ArchitectCommented:
To track the DDL changes in SQL Server you can have triggers to do it... below is the link which will help..

http://solutioncenter.apexsql.com/audit-sql-server-schema-changes/

Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.