Reputation
402
Top tag
Next privilege 500 Rep.
Access review queues
Badges
7 18
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 98 votes cast
Aug
18
awarded  Notable Question
Aug
12
awarded  Yearling
Aug
5
awarded  Constituent
Jul
28
awarded  Caucus
May
21
awarded  Popular Question
Feb
4
awarded  Notable Question
Dec
1
comment How can I dynamically back up all SSAS databases on a given instance?
All it takes is someone renaming the database, and then the Id and Name are out of sync. richardlees.blogspot.com/2009/06/…
Dec
1
comment How can I dynamically back up all SSAS databases on a given instance?
Nice approach! However, I think you still risk the script breaking if the databaseid is not the same as the databasename. I've come across that scenario enough times for a number of customers that I need to account for it.
Sep
24
awarded  Autobiographer
Sep
15
awarded  Enthusiast
Aug
30
accepted How can I search SQL Server for maintenance plans that execute specific tasks?
Aug
9
accepted How to find when change tracking was enabled?
Aug
8
comment How to find when change tracking was enabled?
The customer didn't know CT was enabled, they don't even know if they have any current use/business need for the CT, and I wanted to let them know when it was originally enabled (which was almost 4 years ago). It may help them investigate its original purpose, and whether they can turn it off. The tables being tracked have heavy daily production DML processing.
Aug
8
revised How to find when change tracking was enabled?
formatting
Aug
8
answered How to find when change tracking was enabled?
Aug
8
comment How to find when change tracking was enabled?
That would only work if Change Data Capture was enabled. It is not - only Change Tracking is enabled. Change Data Capture <> Change Tracking. technet.microsoft.com/en-us/library/cc280519(v=sql.105).aspx
Aug
7
asked How to find when change tracking was enabled?
Jul
2
awarded  Curious
Jun
13
awarded  Popular Question
Mar
28
awarded  Popular Question