I've never had trouble finding a new opportunity. My struggle is finding something that appeals to me. There are a lot of organizations out there that just don't get database...

Isn't that what the various hacker organization are doing; shaming our goverment and political organizations into implementing better security practices? 😎

Of course, it's best to use domain authenticated accounts or have your job supply the password externally at runtime. That way you don't end up with passwords embedded in your...

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.