Jeff Moden (8/5/2016)

---

The...

I know what it's like to inherit a database originally developed by an intern. Refactoring the datatypes is the best option, but not if a dozen applications and reporting systems...

chrisn-585491 (8/2/2016)

---

Also consider the risk of putting your data in the hands of someone with a political axe to grind. Many of the Internet social services, (Google, Facebook, Reddit, Twitter),...

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...