283 reputation
112
bio website preetsangha.blogspot.com
location Auckland, New Zealand
age 47
visits member for 2 years, 6 months
seen Jul 28 at 9:40

I'm a engineer who loves to solve really meaty problems - the ones where you usually end up frying your brains doing so.

I'm also available for consultancy - please feel free to check me out on careers or email me directly on preetsangha@gmail.com


Jul
28
comment Transaction Log Shipping across multiple SQL Server versions
I want to avoid large backup and restore cycles which will be left to weekends and overnight if I can't achieve this.
Jul
28
comment Transaction Log Shipping across multiple SQL Server versions
thank you. this is not for backup purposes - those are done as per usual. I'm just using the the technology to get my reporting more up to date during the day.
Jul
28
comment Transaction Log Shipping across multiple SQL Server versions
We don't own the production servers as they are a third party product with their own upgrade cycles. We are another third party provider.
Jul
28
asked Transaction Log Shipping across multiple SQL Server versions
Jul
2
awarded  Curious
Jun
29
awarded  Citizen Patrol
Jun
29
comment Set Backup Compression on SQL Server 2008R2 on by default
Link only answers are discouraged. You should put the salient reasons and recommendations/guidelines in your answer.
Mar
13
awarded  Popular Question
Feb
11
accepted How should I configure these disks on a SQL Server for a BI configuration?
Feb
11
comment Can SQL Agent job notifications be sent to one operator for success and another for failure?
This was going to be my fall back solution. Thanks for the vote of confidence!
Feb
11
asked Can SQL Agent job notifications be sent to one operator for success and another for failure?
Jan
20
awarded  Popular Question
Dec
16
awarded  Popular Question
Nov
27
comment Connect to SQL Server from internet
SO is Stack Overflow.
Nov
27
comment Connect to SQL Server from internet
This should be on Server Fault or DBA not SO.
Nov
10
comment How to transfer the ownership of the dbo schema in SQL Server 2012
Thanks for this.
Nov
10
accepted How to transfer the ownership of the dbo schema in SQL Server 2012
Nov
10
revised How to transfer the ownership of the dbo schema in SQL Server 2012
added 42 characters in body
Nov
10
revised How to transfer the ownership of the dbo schema in SQL Server 2012
added 42 characters in body
Nov
10
revised How to transfer the ownership of the dbo schema in SQL Server 2012
added 54 characters in body; edited title