For us, SSMS and SSDT are different tools that serve different purposes. We use both, all day, every day.

We use SSMS for system administration and general server management. SSMS also...

Eric M Russell (11/22/2016)

---

Idera has a collection of free tools, one of which is an Extended Event Profiler. I havn't gotten around to using it yet, but it sounds like...

Grant Fritchey (11/21/2016)

---

Assuming you're outputting to a file, you can just open the file and you'll be immediately viewing the live data. That may not be a lot easier, but...

Lowell (11/21/2016)

---

I've created views for all my Extended Events, so they are a little slow, but orders of magnitude easier to use.

yes the views shread the XML, but once written...

Sean, that's another great idea. I tried it this morning, and actually have everything modularized and tidy.

My view performs the necessary unions, and I only need to add ONE LINE...

Thanks guys, all good points.

I think the kicker here is that a user may have access to departments and/or offices and/or regions. It's the "ORs" that are killing the query.

I...

More great ideas... thank you...

Carol... great point about periodic/quarterly/year-end processes. This is something that has bitten me in the past, and certainly something I will need to clarify!

After the first...

Thank you Wayne, that is helpful and will be part of my toolkit 🙂 That covers the database system...

I was also hoping to hear basic ideas/approaches on the process...

This is good stuff... exactly what I need to troubleshoot a strange unique key violation with a MERGE.

Question though- why is the IDENTITY column of the type an INT, while...

Ah, happycat, that makes perfect sense. Looks like the object_id's for all my other tables were in sync between the two databases - but the object_id for the one table...

The plot thickens, a little.

I created a view on the server:

[font="Courier New"]CREATE VIEW MyView AS

SELECT * FROM sys.columns WHERE object_name(object_id) = 'MyTableName'

GO[/font]

If I then select from this view via...

Testing? We have end users available to do that. 😀

Actually, we do have a test team that will be hammering on the system - full regression testing for this release,...

Thank you for the feedback. I ended up writing an SMO app in c# that scripts out affected procs, modifies the param datatypes according to specs I have stored in...

ALZDBA - This db is primarily used by a web application, and I work close with the front-end team. They will definitely be key players in this project. The DRI...

Thanks for the tips Emily- fortunately it looks like most of the naming is consistent, though there are a few exceptions.

Grant, I think "go slow" is great advice. Parts of...