If you're wanting to search for object references across multiple mssql instances, then PowerShell could help with that. However, if you're working with database objects within a single instance, then...

The following will query the DDL text of all objects across all databases, returning details on any object that references a keyword you specify. This would include stored procedures, views,...

OK, so what is SQLServerCentral doing to URLs that link to SimpleTalk ?

Ronnie Jones (8/3/2016)

---

It's not so much that they should not, I'm just trying to verify when. Their access is good.

I've setup auditing for the DB/Table I need info on...

The more defensive you are about declaring foreign key constraints, check constraints, not null constraints, and right sized data types, then the less need you will have for defensive programming....

If the issue is that the user (or domain group) should not access a table, then that should be...

It's odd that none of the functions you just listed align with the title of Business Analyst. Not mentioned are: requirements gathering, system documentation, subject matter expertise, product management, etc.

Just shoot them an email and ask.

The role you've described is for an intermediate level BI / ETL Developer.

Nadrek (8/2/2016)

---

Eric M Russell (8/2/2016)

---

Nadrek (8/1/2016)

---

Eric M Russell (8/1/2016)

---

2016 can potentially be several orders of magnitude faster than 2008, if you also want to invest in re-architecting your database to...

Nadrek (8/1/2016)

---

Eric M Russell (8/1/2016)

---

2016 can potentially be several orders of magnitude faster than 2008, if you also want to invest in re-architecting your database to leverage things like Clustered...

Steve Jones - SSC Editor (8/2/2016)

---

Eric M Russell (8/2/2016)

---

I use 1Password as my password manager. However, for the logins I don't actually enter the complete password but will instead obfuscate...

I use 1Password as my password manager. However, for the logins I don't actually enter the complete password but will instead obfuscate a common prefix. For example, if the actual...

Eric M Russell (8/1/2016)

---

Rod at work (8/1/2016)

---

Steve, I don't have an answer to your question. However, your article has opened my eyes to the fact that what I've experienced over...

Rather than attempting to hack SSMS Object Explorer, maybe there is a SSMS add-in alternative that work in the way you want. Some people like to use RedGate SQL Search...