893 reputation
313
bio website zetaproductions.co.uk
location London, United Kingdom
age 34
visits member for 1 year, 9 months
seen Apr 15 at 13:23

UK based SQL Server professional and enthusiast. I work with, and am passionate about all aspects of SQL Server including the Database Engine and the BI stack, especially SSIS, but my real passion is SQL Server Internals, with my favourite blogger being the legend that is Paul Randle.

Career wise, I am a gun for hire, specialising in OLTP and DataWarehouse performance and ETL. I have experience in BIG data (80TB), FastTrack, and exposure to PDW.


Jul
2
awarded  Curious
Sep
24
awarded  Yearling
Jul
29
awarded  Enlightened
Jul
29
awarded  Nice Answer
Jun
28
comment Transactional Replication times-out with Database Snapshot on subscription
@Kin - No. Essentially it is not a replication issue. More of a DataBase Snapshot issue that is impacting replication. There are an unusually high number of latches on Access Methods. Waits don't reveal anything interesting.
Jun
28
comment Transactional Replication times-out with Database Snapshot on subscription
@kin - Unfortunately this is not "politically" possible. Also, I an not convinced that it would help, as the issue is not with getting the data over the wire, it is actually the high volume IO vs the database snapshot.
Jun
27
comment Transactional Replication times-out with Database Snapshot on subscription
@Kin - it is when deletes are being transitionally replicated, not during the snapshot initialization. However, snapshot erplication is 8x faster without the snapshot
Jun
26
asked Transactional Replication times-out with Database Snapshot on subscription
Apr
23
comment Dictate edition during unattended install?
Thanks but as Aaron says above, there will be nothing in the registry to read at this point. My comment refering to registry was more about - If the version cannot be selected during the silent instal, can it be chaned post install
Apr
23
comment Dictate edition during unattended install?
@AaronBertrand It is the ISO. Volume licensing
Apr
23
asked Dictate edition during unattended install?
Dec
21
asked Distribution Agent running but subscription does not exist?
Nov
30
asked Transactional Replication not sending all commands
Nov
25
comment Running queries against multiple servers
@AaronBertrand the infrastructure concern is that what I am writing is essentially a different application, and from both seurity and architecture any link between apps should be loosly coupled, ideally through Biztalk. This is increased because an external team will be supporting the main app. I can convince SSIS (or PS as Thoas suggested) because it "kind of" fits this model, where as Linked Servers are synchronous and as far as infrastructure would be concerned, turn the main app into a landing zone. Additionally, I need a way to "plug-in" additional servers with minimal effort.
Nov
25
comment Running queries against multiple servers
@ThomasStringer Powershell script a great idea thanks
Nov
24
comment Running queries against multiple servers
@AaronBertrand & Thomas - I can't use linked servers because of unfounded security concerns. I may need to resort to SSIS I guess
Nov
24
comment Running queries against multiple servers
Thanks. I though about this, but I want to save the results to a table on the "Master Server". From what I understand, this will not work, baring in mind I cannot create linked servers. Is my assumption correct?
Nov
24
awarded  Student
Nov
24
asked Running queries against multiple servers
Nov
9
comment Why do we need to rebuild and reorganize Indexes in SQL Server
Yes, that is correct. You can actually use server agent to respond to low CPU usage on the server by starting a job. This job could contain your index rebuild scripts. Also, if you are in a 24/7 environment, I suggest you write a script that only reorganises or rebuilds the indexes that actually require it, rather than rebuilding all.