362 reputation
316
bio website
location Pittsburgh, PA
age
visits member for 2 years, 4 months
seen 1 hour ago

SQL Server BI Developer and DBA. Former application developer.


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
Feb
13
comment How can I search SQL Server for maintenance plans that execute specific tasks?
No, this works in 2012. AFAIK, there is only one deployment method for a maintenance plan - saving the plan, which stores it in msdb, no different than the prior versions. And the project deployment model is only an option for custom SSIS packages.
Feb
13
comment How can I search SQL Server for maintenance plans that execute specific tasks?
Please somebody help w/ the code formatting. I tried, and failed.