Role Bluecrest Capital: Difference between revisions
| (10 intermediate revisions by the same user not shown) | |||
| Line 19: | Line 19: | ||
[[Skills_Other_Technical#Powershell|Powershell]] for SQL Server | [[Skills_Other_Technical#Powershell|Powershell]] for SQL Server | ||
[[Skills_SQL_Server_DBA_Database_Administration#Performance tuning|server-side traces]]. SQL Agent jobs to run | [[Skills_SQL_Server_DBA_Database_Administration#Performance tuning|server-side traces]]. [[Skills_SQL_Server_DBA_Database_Administration#SQL Agent|SQL Agent]] jobs to run | ||
SSRS - SQL Server Reporting Services. Created a report based on an existing report template, to read from a different database table. | [[Skills_Business_Intelligence#SSRS|SSRS]] - SQL Server Reporting Services. SSRS tablix. Created a report based on an existing report template, to read from a different database table. | ||
SQL Profiler diagnosis of slow row-by-row cursor-based data load processes, and development of faster bulk loading code. | [[Skills_SQL_Server_DBA_Database_Administration#Performance tuning|SQL Profiler]] diagnosis of slow row-by-row [[Skills_SQL_Server_TSQL#Other|cursor]]-based data load processes, and development of faster [[Skills_SQL_Server_TSQL#Other|bulk loading - BCP]] code. | ||
Clear release and problem | Clear release and problem description documentation, including "before" and "after" configuration for ease of rollbacks. | ||
creation of linked servers | creation of [[Skills_SQL_Server_Development#Other|linked servers]] | ||
Creation of and assignment of permissions to new accounts | Creation of and assignment of [[Skills_SQL_Server_DBA_Database_Administration#Security|permissions]] to new accounts | ||
temp table workarounds for unexplained bad query results | temp table workarounds for unexplained bad query results | ||
Use of OPTION (FORCE ORDER) to change the query plan to be | Use of [[Skills_SQL_Server_DBA_Database_Administration#Performance tuning|OPTION (FORCE ORDER)]] to change the query plan to be in line with the query definition. | ||
Added database to permissions stored procedure | Added database to permissions stored procedure | ||
Parameterisation of dynamic sql to allow optimal query plans to be found and retained. | Parameterisation of [[Skills_SQL_Server_TSQL#Dynamic SQL|dynamic sql]] to allow optimal [[Skills_SQL_Server_DBA_Database_Administration#Performance tuning|query plans]] to be found and retained. | ||
Moved backup and restore scripts from master to new "msdba" database. | Moved backup and restore scripts from master to new "msdba" database. | ||
| Line 43: | Line 43: | ||
Auditing of failed logins to sensitive servers. Configuration of SSRS report for these. | Auditing of failed logins to sensitive servers. Configuration of SSRS report for these. | ||
Diagnosis of a view trigger preventing update to a critical view. | Diagnosis of a view [[Skills_SQL_Server_TSQL#Other|trigger]] preventing update to a critical view. | ||
Creation of SSRS database status report showing recent failed SQL Agent jobs, and backups that are not sufficiently current for business requirements. | Creation of SSRS database status report showing recent failed SQL Agent jobs, and backups that are not sufficiently current for business requirements. | ||
Resolved critical problem with missing indexes (on Protea) causing a partition switch to fail. This was to switch a table of newly loaded data into a main table. | Resolved critical problem with missing indexes (on Protea) causing a [[Skills_SQL_Server_Development#Partitions|partition switch]] to fail. This was to switch a table of newly loaded data into a main table. | ||
Specified and documented a SQL Server standard build, including step by step instructions how to install it using the SQL Server installer. | Specified and documented a SQL Server [[Skills_SQL_Server_DBA_Database_Administration#SQL Server upgrades|standard build]], including step by step instructions how to install it using the SQL Server installer. | ||
Created database mirroring failure monitoring, using SQL Agent jobs to insert datetimestamp values into tables, and track their progress across the mirror, raising an error if there is a delay. | Created [[Skills_SQL_Server_DBA_Database_Administration#Database mirroring and log shipping|database mirroring]] failure monitoring, using SQL Agent jobs to insert [[Skills_SQL_Server_TSQL#Datatypes|datetimestamp]] values into tables, and track their progress across the mirror, raising an error if there is a delay. | ||
MySQL backups. Use of mysqldump utility to backup a MySQL database, and take archive copies. | [[Skills_Other_Technical#MySQL|MySQL]] backups. Use of mysqldump utility to backup a MySQL database, and take archive copies. | ||
SQL Server performance dashboard reports installation & configuration. | SQL Server [[Skills_SQL_Server_DBA_Database_Administration#Performance tuning|performance dashboard]] reports installation & configuration. | ||
Batch file to run SQL code on several SQL Servers using OSQL. | Batch file to run SQL code on several SQL Servers using [[Skills_SQL_Server_Development#Other|OSQL]]. | ||
SQL code redesign for performance optimization. | SQL code redesign for performance optimization. | ||
Latest revision as of 18:01, 6 October 2024
Introduction
Bluecrest Capital contract from 1st November 2011 to 31st August 2012
Wrote backup and restore scripts
In more detail
Wrote backup scripts to run weekly full and daily differential backups.
Wrote restore scripts to restore the most recent backups generated by the backup scripts, to databases of different names on other servers.
This involved reading from file paths to detect the most recent backup files, and accommodating changes in the database file names for restore (the WITH MOVE option).
Scripts to back up and restore database permissions in the database being restored.
Transactional Replication of the Nemo database
Powershell for SQL Server
server-side traces. SQL Agent jobs to run
SSRS - SQL Server Reporting Services. SSRS tablix. Created a report based on an existing report template, to read from a different database table.
SQL Profiler diagnosis of slow row-by-row cursor-based data load processes, and development of faster bulk loading - BCP code.
Clear release and problem description documentation, including "before" and "after" configuration for ease of rollbacks.
creation of linked servers
Creation of and assignment of permissions to new accounts
temp table workarounds for unexplained bad query results
Use of OPTION (FORCE ORDER) to change the query plan to be in line with the query definition.
Added database to permissions stored procedure
Parameterisation of dynamic sql to allow optimal query plans to be found and retained.
Moved backup and restore scripts from master to new "msdba" database.
Auditing of failed logins to sensitive servers. Configuration of SSRS report for these.
Diagnosis of a view trigger preventing update to a critical view.
Creation of SSRS database status report showing recent failed SQL Agent jobs, and backups that are not sufficiently current for business requirements.
Resolved critical problem with missing indexes (on Protea) causing a partition switch to fail. This was to switch a table of newly loaded data into a main table.
Specified and documented a SQL Server standard build, including step by step instructions how to install it using the SQL Server installer.
Created database mirroring failure monitoring, using SQL Agent jobs to insert datetimestamp values into tables, and track their progress across the mirror, raising an error if there is a delay.
MySQL backups. Use of mysqldump utility to backup a MySQL database, and take archive copies.
SQL Server performance dashboard reports installation & configuration.
Batch file to run SQL code on several SQL Servers using OSQL.
SQL code redesign for performance optimization.