Reputation
524
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 17
Newest
 Informed
Impact
~32k people reached

  • 0 posts edited
  • 1 helpful flag
  • 47 votes cast
Apr
2
comment Can I install SQL Server Management Studio locally?
While I agree with your philosophy of SSMS >= the highest engine version you need to manage, we found that we couldn't edit a management package (don't hate me for it) on SQL2012 in SSMS 2014. It corrupted the file and SQL 2012 wasn't able to run it.
Mar
27
comment Change Data Capture not running when Mirror is Suspended
@AaronBertrand We're currently testing out SQL 2014 using AlwaysOn availability groups. We setup CDC and 3 servers - 2 for our primary site and a DR server. The 2 primary are synchronous replication and the DR is async. If any of the servers goes offline (primary or not) CDC stops collecting.
Mar
24
comment Manual Failover with AlwaysOn availability group
Also, we have considered hosting the file share elsewhere, however our internet connection runs through DR (don't ask, it just does) so if DR drops offline then a remote file share would as well.
Mar
23
asked Manual Failover with AlwaysOn availability group
Feb
19
awarded  Informed
Dec
23
awarded  Famous Question
Nov
14
comment Find out who ran a query using transaction log backups
Apex SQL Log worked a treat
Nov
14
accepted Find out who ran a query using transaction log backups
Nov
14
comment Find out who ran a query using transaction log backups
@Kin Apex SQL was perfect for this. If you want to make that an answer I'll certainly accept it.
Nov
13
comment Find out who ran a query using transaction log backups
@Kin, does Apex SQL Log work after the fact, or did we need to have it running at the time?
Nov
13
comment Find out who ran a query using transaction log backups
That's all gone a bit over my head. We've restored the database to the point in time right before the change happened. It happened last night (15 hours ago) so it's well and truly committed. The data has been fixed, but what we're trying to work out is what login was used to run the query.
Nov
13
asked Find out who ran a query using transaction log backups
Nov
4
awarded  Popular Question
Oct
27
comment Change Data Capture not running when Mirror is Suspended
Our link to DR was broken overnight and CDC data wasn't processed again. Still can't find anything on Google. Might need to go to Microsoft.
Oct
9
awarded  Notable Question
Sep
12
accepted Cube Processing vs Database Processing
Sep
12
answered Cube Processing vs Database Processing
Sep
10
asked Cube Processing vs Database Processing
Aug
20
revised Change Data Capture not running when Mirror is Suspended
added 35 characters in body
Aug
20
comment Change Data Capture not running when Mirror is Suspended
@mrdenny - sounds plausible. We are running the mirror as async normally as we don't want the latency we get with sync and the CDC data works as expected. Like I said though, the Log Reader being disabled sounds plausible