full
image
#d9d9d9
http://www.dbxperts.co.uk/wp-content/themes/smartbox-installable/
http://www.dbxperts.co.uk/
#26ade4
style2
Remote Database Management Services
0844 500 8150

About

 

 

The DBX Team

Garrett

Garrett

Managing Director and Database Administrator

Garrett has over 20 years experience as a database administrator and specialises in Microsoft SQL Server, SAP ASE and SAP Replication server.   Garrett has spent most of his IT career in the financial industry for large insurance companies and investment banks like AIG, HSBC & Aegon.  As the Director of DBXperts he is the direct reporting link with all our customers.

 

Bob

Bob

Database Administrator

Bob trained on ASE and Repserver early on his career in the 90's and has never looked back.  As well as enjoying working with both products, Bob is a great advocate of shell scripting and enjoys using those skills to achieve the many associated goals relating to database and replication support.  Having worked in the banking and related financial sectors, change management is second nature as is his care and attention to detail and ability to spot potential problems before they happen. Outside of work, Bob enjoys reading and travelling and spending time with his family.

Alan

Alan

Database Administrator

 

Microsoft SQL Server database Administrator with over 15 years of experience working with household names like Thomas Cook & Premier Foods.  Alan has extensive knowledge of SQL Servers more advanced features and functions.

Paul

Paul

Database Administrator

Paul is a certified Sybase & SQL Server DBA with extensive experience managing production databases in the Financial Sector.  He is an approachable team player specialising in all versions of ASE, Replication Server, Sybase IQ and Microsoft SQL Server with a proven ability to implement change, resolve problems and improve performance in the database environment

 


DBX Blog Posts
13
Sep
0

Reasons not to grant db_owner DBO can do some nasty stuff:-  CHANGE RECOVERY MODEL  BACKUP DATABASE  ALTER ANY SYMMETRIC KEY TURN ON/OFF AUTOSHRINK  ADD FILE AUTO_UPDATE_STATISTICS SET RECURSIVE_TRIGGERS DROP DATABASE SET OFFLINE   If you must create database objects, view showplans/dynamic tables or more but do not want to give away ‘the keys to the […] Read more

20
Apr
0

Audience: Managers/Non-database technical staff/RDBMS (database server) Beginners. Sometimes an application can misbehave.  It is normal for processes inside an RDBMS system to occasionally get blocked by another process which is currently updating data, and this normally goes unnoticed as it is usually short-lived and clears once the update activity finishes and the locks are released.  However, sometimes […] Read more

29
Dec
0

Detailed notes on reviewing existing  DBCCDB for use with ‘check storage’ DBCCDB review First, find out what ASE recommends you set the minimum values to using > sp_plan_dbccdb <dbname> Then, we work through these values and we pay attention to the settings below. check size of dbccdb check size of dbccdb_cache check scan ws value […] Read more

04
Mar
0

NO ROWS Function ‘rs_get_textptr’ for ‘sometable’ returned no rows,  table example:- create table test_tab( cola int not null, colb_txt text null) This occurs with columns containing text columns.  The problem is you forgot sp_setrepcol.  The default for text/image is always replicate and so not null is assumed.  So you need to run sp_setrepcol to set […] Read more

paged
Loading posts...
link_magnifier
#6E787E
on
fadeInUp
loading
#6E787E
off