Reputation
445
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 6 17
Impact
~36k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Mar
4
comment Not able to create SSISDB catalog
Easy way to see if SSIS is installed - go to SQL server configuration manager and see if "SQL server integration services" is running
Dec
13
awarded  Nice Question
Dec
3
comment VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping
OK I did disable the windows service (on the machine that runs SQL instance) now, will monitor. Previously it was VEEAM which broke the log shipping, but this time it was not VEEAM
Dec
3
asked VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping
Nov
15
awarded  Popular Question
Nov
1
awarded  Notable Question
Oct
23
awarded  Notable Question
Oct
7
awarded  Famous Question
Sep
22
accepted Identify sequence of events based on certain rules
Sep
22
comment Identify sequence of events based on certain rules
Thanks Andriy, I included auto identity for simplicity, but am using row_number for enumeration. are you referring to partitioning, which is effectively what Im attempting - to partition by groups?
Sep
22
comment Identify sequence of events based on certain rules
hi, if any of those events occur, then the event nr does not increment please. Type1 immediately Type10 (no event in between -stay on current event nr). Type 10 not immediately followed by Type1 (stay on current event nr) . Not more than 5min between 10 and 1 (stay on current event Nr) If I can get an idea of what you can recommend then I can sort out the dates based on your recommended approach but I have no clue where to start please
Sep
22
asked Identify sequence of events based on certain rules
Sep
21
awarded  Yearling
Aug
7
accepted Read GPS Coordinates into LineString from Table
Aug
6
asked Read GPS Coordinates into LineString from Table
Aug
5
awarded  Popular Question
Aug
3
awarded  Notable Question
Jul
28
awarded  Caucus
Apr
15
accepted Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary
Apr
15
comment Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary
Hi, OK so I'm just confirming please : because the Monitor Server : Log_Shipping_Primaries isn't updated - thats why the secondary server is failing? This is a standard feature of Log Shipping and cannot be changed via a setting? Thanks