gkruse (2/20/2015)

---

I currently have a dedicated desktop PC (not a server) running SQL 2008. I have a dozen OLAP Cubes running with Analysis Services and two SQL databases that...

And this[/url]

Absolutely not. You can have a...

Have a read through Chapter 3 of http://www.red-gate.com/community/books/accidental-dba

sql-lover (2/19/2015)

---

But in cases where the application or design uses a single user which of course, already has SELECT permissions against that table or column and Dev already uses same...

spaghettidba (2/18/2015)

---

Unfortunately no. I would have loved to attend and meet you (at last!).

I'll be speaking...

Because you're protecting it against people who don't have proper permissions.

Consider, all HR people have access to the Employees table but only the HR head for each department should be...

Suspended with what wait type?

Since they're stored procedures, not ad-hoc...

Question 2 isn't a question, so it's kinda hard to answer.

Trace or extended events will let you see the order that locks are acquired and released.

rodjkidd (2/17/2015)

---

That would be me then! 😀

Currently working out if I want to go out a day...

Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/

No, because a checksum doesn't need to be base64 encoded.

Base64 is used for converting binary values to text.

Again, what are you trying to do here? What's the point of this?

A checksum is numeric, it doesn't require Base64 encoding.

Something like

Select Deptid,Dept_name,location, checksum(Dept_name) from department

Couple steps back... What are you trying to do?