|
|
-
|
|
Specialise or a generalise? It all depends on how you define these terms.
A SQL Server DBA may be considered to be a specialist by a Enterprise Architect but a generalist by a SSIS expert.
The DBA is currently in great demand and based on predictions re: User Devices and Database Servers<a ......
|
|
-
|
|
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this post outlines the system I use to manage the DBA scripts across the database server environment
1) Develop a script library covering the essentials ......
|
|
-
|
|
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires consideration of various factors.
Reasons for maintaining different environments
Part of well audited database server system includ......
|
|
-
|
|
The current DBA trend is increased database management requirements and less DBAs to manage.
Many factors are responsible, such as:
1)Global trends and predictions for increased data requirements
2)Automation
3)Economic pressure to decrease size of IT departments
You can see why for many DBAs ......
|
|
-
|
|
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate some ideas you could use
For acceptance into the SQL Server environment, I’ve developed some scripts that scan the T-SQL code for some items in this check......
|
|
-
|
|
A couple of years ago, I heard some new terms: “10x developer” and “2x developer”.
A 10x developer seemed to complete tasks almost instantly. A 2x developer took a
long time to complete a task. These terms can also be applied to other jobs such
......
|
|
-
|
|
I've compiled a list of the questions that I get asked most frequently. If you have a question that I haven't answered or you need a more detailed answer, you can comment on the blog or contact me. Please read through to see if I've answered it already. FAQs were lasted updated on 13th August 201......
|
|
-
|
|
The purpose of the article is to list my top 10 DBA tips to concentrate on in developing the competitive edge. There are of course many more DBA and related technolgies skills.
1) Read everything, across all platforms. Download SQL Server 2008 Books Online and read it all
2) Develop some extreme......
|
|
-
|
|
When requesting SQL Server troubleshooting, don’t send messages such as “users are complaining of sudden slow performance “ or “this was OK yesterday, but is suddenly very slow”. Usually it’s insufficient to solve the problem. It’s not impossible, but the p......
|
|
-
|
|
I’m writing a Operational DBA job description – for an internal vacancy. The main requirements are listed below. Without getting into the specifics of the organisation – there is: 1 Database Architect\Senior DBA, 1 DBA and 1 Data Architect in a Enterprise Production environment su......
|
|