If you simply want to check all of the user-developed objects, use this for the "c" cursor:

declare c cursor for

...

When it comes to PCI and financial data, there can be no compromise in data security S&P. BYOD is not a player here. Consultants' devices must be configured to our...

I'm in the financial industry. We've purchased a data warehouse solution that allows us to maintain critical and sensitive data on-site. If MS continues their push to the cloud, I'll...

"While we considered changing to a bigint, this was a third party product and they did not want to allow us to alter the schema."

There's your problem. Perhaps testing the...

We use three different monitoring solutions outside of SQL Server: one that monitors activity against the database instance, one that gathers event logs, and one that monitors changes to critical...

I support our physical access system. We have a policy that badges must be displayed and used individually for access (no "piggybacking"). Lost cards are deactivated on notification (and are...

"Developers, developers, developers."

Agreed, but there's two sides to the technology house. MS's gutting of TechNet (or at the very least making it less accessible to those without deep pockets) is...

So, is Yahoo going to drop offshore resources? Or do they have a facility in Bangalore where they can gather their employees?

Steve, it sounds like a good time for an in-depth treatment of SQL Server's in-memory capabilities ;^)

In the environments I support, auditing is required by regulation. I have rudimentary tracking enabled via trigger on a subset of sensitive fields. Additionally, I use the default...

We just went through our required annual DR exercise. Databases were restored to a geographically-separated alternate location and applications were recovered at that site. I'm not in an industry where...

"Now if I could just find the time to take advantage of it ...."

Amen. Especially when you care about work/life balance and its effects on your health.

I'm not an enterprise DBA, but I support a couple of applications with off-farm SQL instances. SQL has been rock-solid for the duration of my tenure; most middle-of-the-night calls result...

The Blues Brothers' cop car. At night. Wearing sunglasses.

But for now, an HHR panel. Economical. Standard. Throwback, but modern.

And, alas, discontinued.

So we shouldn't expect another outage for, oh, three years or so. Sounds good to me.

Redundant failover architecture should include the management...