The simple truth of the matter is that if the users are members of SYSADMIN role, then they own your database. Your organzation doesn't have one or two DBA's, it...

mohan.bndr (7/24/2013)

---

Thanks all you guys for responding,but I believe in the older version of SQL Server (200 and below) can only possible.... am i correct ? and for SQL 2005...

Are you sure you personally are a consultant?

If you're paid a salary by your employer, then you're no more a consultant than the receptionist is, even if your...

You can call your process whatever you want, but what really matters are requirements, ticketing of tasks and bugs, source control, peer review of code, seperate dev / qa,...

Steve Jones - SSC Editor (7/19/2013)

---

djackson 22568 (7/18/2013)

---

Unmentioned in the article is an issue the industry needs to address, which is that a lot of vendors develop software that requires...

jdbrown239 (7/18/2013)

---

Thanks

Thanks Sean that worked. I also found that substring worked too.

update XDDDepositor

SET XDDdepositor.WBeneName = Vendor.RemitName,

XDDDepositor.WBeneAddr = SUBSTRING( Vendor.RemitAddr1,0, 35),

XDDDepositor.WBeneAddr2 = SUBSTRING( Vendor.RemitAddr2, 0 , 35),

XDDDepositor.WBeneCity = Vendor.RemitCity,

XDDDepositor.WBeneState = Vendor.RemitState,

XDDDepositor.WBeneZipPostal...

In addition to protecting login credentials of accounts, another layer of security is at the firewall configuration level with IP blocking. That way, even if someone finds a sticky note...

The best service that data professionals can do for the benefit of mankind is to keep the database locked down and secure.

Obviously this concept of data philanthropy, sharing corporate data with the world for the good of hunamkind, should be left up executive management. Please run it past your boss first.

Based on news stories, it seems to me that the vast majority of data breaches, and the ones that the most massive in scale, are the result of inadequate role...

anon_tyrant (7/15/2013)

---

RDP is the real tool, laptop is only needed if you need to connect somewhere besides home or work. I finish up work at 5, go home and...

I have a beefy desktop sitting under a rarely used desk, and I VPN into that from a laptop. Thanks to VPN, the laptop is a cheap $350 model and...

phonetictalk (7/9/2013)

---

I'm surprised (or I'd be surprised) that there isn't a way to automatically audit Excel sheets for these sorts of mistakes. I know Excel will highlight if a formula...

In addition to formulas not being replicated properly, another problem is when a cell that appears to contain a numeric value is treated as text by Excel, because it contains...

Somewhat related... Oracle has a feature called "Flashback" that leverages the transaction log to query the state of data for any table at a point in time using the "AS...