336 reputation
17
bio website
location Nottingham, United Kingdom
age 31
visits member for 4 years, 6 months
seen Dec 4 at 16:28

An enthusiastic and driven self-learner with strong foundations in Windows support and T-SQL and an interest in SQL Server internals. Focused on expanding knowledge and strengthening acquired skills.

Database Administration: Experienced installing, configuring and administering SQL Server 2005 and 2008(R2). Good understanding of execution plans and what influences the query optimizer’s[sic] decisions. Installed and tested SQL Server Denali CTP1. Limited use of MySQL with Wordpress and Xbox Media Centre.

Development: Experience developing and refactoring SQL objects and Queries with a set based approach. Comfortable writing reports and basic Integration Service packages. Able to read through pages written in ASP.Net(C#), Classic ASP and Java Script to determine what queries are passed to SQL Server. Also have basic understanding of PowerShell.

Operating Systems: Experience installing, configuring and administering Windows XP, 7, Server 2003 and 2008(R2) as well as Ubuntu Server and OS X. Knowledge of ESXi and other VM-Ware products. Networking: Good understanding of TCP/IP, DHCP and DNS. Comfortable creating DNS records in MS DNS Server and have basic knowledge of MS ISA Server.

Communication: Strong written and oral communication skills. Led training sessions and wrote accompanying documentation. At ease discussing both technical and non technical topics with clients by phone, email and face to face.


Sep
24
awarded  Autobiographer
Apr
25
answered Distributed MS SSAS database?
Nov
22
awarded  Commentator
Nov
22
comment EXEC() syntax error using ODBC
Does indeed sound like this is the case, you can also use the QUOTENAME() function to place @TableName in square brackets.
Nov
16
answered Option do not show schema names in SQL Server Management Studio
Sep
22
comment log file problem after query execution
If the log file does not shrink you can refer to log_reuse_wait_desc in sys.databases to determine what is preventing the shrink operation
Aug
10
answered Can connect to SQL Server remotely by port number but not by instance name
Aug
3
answered Cannot connect into WindowsXP on VMWare Fusion by IP
Jun
23
awarded  Yearling
Nov
24
answered MSSQL Certification 70-432
Nov
24
comment MSSQL Certification 70-432
I used the MS Press book which had quite a few mistakes and required extra reading to cover some areas. Also end of chapter questions where out of sync with the chapter content. Haven't used the book that mrdenny worked on but it's got to better than the MS one.
Aug
24
comment Index rebuild stored procedure fails while calling temporary table
How did you get on with this?
Aug
20
awarded  Citizen Patrol
Aug
16
comment Index rebuild stored procedure fails while calling temporary table
Just re-read your question and think this may not be relevant. Still leaving up just in case.
Aug
15
answered Index rebuild stored procedure fails while calling temporary table
Aug
12
comment Migrate SQL Server
Much better answer :)
Aug
12
comment Migrate SQL Server
Data files/Backups do not vary with architecture
Aug
12
answered Migrate SQL Server
Aug
12
comment Automatically add user to newly created database
I might be wrong but won't this add the user to all new databases on the instance too, just as adding to Model would?
Aug
12
revised How to set FK to all tables in SQL Server 2005?
added 57 characters in body