780 reputation
1618
bio website sblackler.net
location Bournemouth, United Kingdom
age 24
visits member for 2 years, 9 months
seen Mar 31 at 11:05

I am a self-taught programmer originating from the Isle of Wight. I have approximately 3 years commercial experience in developing LOB applications for a wide range of customers (local companies to FTSE 100). During this time, I have honed my development skills across a wide range of platforms and frameworks including C#, VB.net, T-SQL, Web Services and Android programming.

I am currently training towards my MCSA SQL Server 2012 qualification alongside my degree in Computing from Bournemouth University (Graduating 2013). During my time at Bournemouth University, I have built an extensive knowledge in core networking protocols and architecture including TCP, IP (v4 & v6), DNS, ARP, HTTP, EMAIL (SMTP, POP3 and IMAP), WiMAX (802.16) and WiFi (802.11).


Nov
10
asked When should a primary key be declared non-clustered?
Nov
10
comment Need help figuring out correct permissions for SQL Server Users
Thanks. I think I understand. I am going to test this and post back if I have any problems :)
Nov
10
comment Need help figuring out correct permissions for SQL Server Users
Thanks for the answer :) I am going to try this in a bit. Would you also recommend doing a Deny All then explicitly allowing the permissions you want, eg. SELECT/INSERT/UPDATE
Nov
10
accepted Need help figuring out correct permissions for SQL Server Users
Nov
10
accepted Is this Index checking logic ok?
Nov
10
asked Need help figuring out correct permissions for SQL Server Users
Sep
22
awarded  Critic
Sep
22
comment Is this Index checking logic ok?
because im trying to learn, i dont think anyone can learn by copy - paste - execute
Sep
22
revised Is this Index checking logic ok?
updated query to latest version
Sep
22
comment Is this Index checking logic ok?
@gbn, I can understand that. The aim of this was to see if I could get the best of all the scripts (except missing indexes) into 1 script/view
Sep
22
revised Is this Index checking logic ok?
added 124 characters in body
Sep
22
asked Is this Index checking logic ok?
Aug
31
accepted Strange behaviour with Computed Columns in SQL-Server
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
And do you know why the QO would use the non-persisted column in my example above?
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
Thanks for the answer Jack. If it persisted in the index, then how does the index know if the underlying value is changed?
Aug
29
comment Strange behaviour with Computed Columns in SQL-Server
For those that have the 70-433 book, the quoted text is at the top of page 111.
Aug
29
asked Strange behaviour with Computed Columns in SQL-Server
Aug
26
comment What are the performance implications of running multiple smaller DBs instead of a single larger DB on a server?
How big are the databases? How many concurrent users of the system are there?
Aug
25
comment SQL Server Join/where processing order
Thanks for the links. Once I get it clear how it work's I hope I will write better queries etc :)
Aug
25
comment SQL Server Join/where processing order
Thanks for the link. Once I get it clear how it work's I hope I will write better queries etc :)