377 reputation
316
bio website
location Pittsburgh, PA
age
visits member for 2 years, 5 months
seen 25 mins ago

SQL Server BI Developer and DBA. Former application developer.


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
Mar
6
comment Dealing with measure groups of different granularity
When you say "that doesn't seem to allow me to use the Referenced dimension usage for other dimensions," what do you mean? What steps have you tried?
Feb
14
revised How can I search SQL Server for maintenance plans that execute specific tasks?
added 9 characters in body
Feb
14
comment How can I search SQL Server for maintenance plans that execute specific tasks?
I do have a question though...how is it possible to deploy an SSIS package w/ project model as an official maintenance plan?
Feb
14
revised How can I search SQL Server for maintenance plans that execute specific tasks?
added 201 characters in body
Feb
14
comment How can I search SQL Server for maintenance plans that execute specific tasks?
That makes sense. You can still make maintenance plans in SSMS without the wizard, and they will be deployed to msdb. But yeah, anything deployed via the project model would not apply to this solution. I'll edit my answer to note the limitations.
Feb
14
awarded  Self-Learner