I'm trying out a converted form of our database with In-Memory-Tables and it is not easy. Especially the severe limitations on the natively-compiled procedures.

For example, several SPs take XML from...

Hi Sandeep,

Many thanks for this script. I have just the spent the last hour deep in BOL, sys.objects, sys.key_constraints and friends, trying to identify which tables in the DB have...

@call.copse

I am of the understanding that EF is perfect for simple and extremely quick queries that call no more than 2 tables and returned a few fields at most. This...

Hi Steve,

By code, I assume that you mean SQL. I am in no position to judge how efficient the C-sharp code in our application is.

As a DBA, I like...

The main problem is that our best interests are not your best interests.

The developers have discovered Entity Framework and they say that it lets them code faster. I'm sure that...

I have several answers to this based on the careers of people I have seen:

1. You become the super-DBA — you master as much of your chosen RDBMS...

What irks me is that there seems to be race to use eveyrthing that can be used up as soon as possible.

Much to my chagrin, the developers are the ones...

There are actions we DBAs can take to prevent unauthorised intrusion and some we can't. We can't ensure that the server room remains unbroken into. Nor can we ensure that...

It is clear here that meetings mean different things to different rungs on the corporate ladder.

As a DBA, if I call a meeting, then it is technical in nature....

There are several points being made here.

Firstly, the mindset of many a developer, especially those that learn by trial-and-error, is that the thing being built is never finished and errors...

I'm not a fan of the Cloud.

Ever since Edward Snowden confirmed my suspicions that the NSA and other spy agencies are trawling and capturing as much data as they possibly...

For me, the idea of a sabbatical concerns the learning of something new and returning back with a new skillset and outlook

I had more envisioned someone who had been working...

Idea for a sabbatical, if you can afford it, if you have the contacts and if you can, go work for a company someplace very different to where you are...

A lot of it depends on why the system is buggy in the first place and the relative strength of the DBA within the organisation.

It might be that the management...

My pet irk about the developers concerns indexes and stored procedures.

We have a system with about 200 SPs and it seems that the developers have followed SQL Server's suggestions for...