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

Blog

20
Sep

I was asked recently to setup Heterogeneous SAP replication from SAP ASE to SQL Server and then the task was extended to also replicate to an Azure Database. This can be complicated to setup and get working so I documented the procedure and updated our PDF downloadable instructions available from, http://www.dbxperts.co.uk/downloads/ A common issue with the […]

29
Dec

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 […]

20
May

If you want to backup your SQL Server databases you normally use the Maintenance Plan Wizard to generate an automated job to do just that. But what if you want to backup across multiple files to improve the backup performance ( on multi CPU servers) AND still included an automatically generated date/time stamp within the […]

20
Apr

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 […]

25
Jan

Since 15.7 sp1xx there has been a great new facility to increase and decrease log segments in an ASE database but did you know that you could end up with a row in the sysusages table that you cannot get rid of? Further research shows this to be a know issue with the use of […]

0 No comments
Read more
24
Jun

Sometimes we want to recreate an existing error class, for example, taking one from production into a new UAT environment. It is not really possible to do this but we can work out the modified error codes in the user defined error class and then manually recreate the class.  Run the SQL, in the RSSD, […]


Recent Posts
20
Sep
0

I was asked recently to setup Heterogeneous SAP replication from SAP ASE to SQL Server and then the... Read more

29
Dec
0

Detailed notes on reviewing existing  DBCCDB for use with ‘check storage’ DBCCDB review F... Read more

20
May
0

If you want to backup your SQL Server databases you normally use the Maintenance Plan Wizard to gene... Read more

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