"Every business is an algorithmic business."

That's an interesting phrase that Microsoft's Joseph Sirosh has used. I find it interesting because of the change in Microsoft's thinking. They used to use...

I never really thought about who pays for a data breach. I assumed the company did, but your article Steve shows me its likely the insurance company that insures the...

Wayne, is this copy of The Mythical Man Month free for reading online?

NotaSQLperson (5/26/2016)

---

You have to weigh out what you really want in a career and life, if it is just a paycheck and self preservation then take the job that pays...

Recombinant (5/27/2016)

---

For a long time I have disagreed with bosses and organisations in some jobs but then got on OK in other jobs. Things came to a head 2 years...

OK, I'll copy it to the location you've given, but what permssions would I have to assign to the folder where it currently is, in order for it to work?

Wayne West (5/26/2016)

---

I was at one job for nine years and after some frustrating setbacks with no management support, I decided to quit. When I told my friends, they...

Stefan LG (5/26/2016)

---

Andy, as you have mentioned there are so many factors involved, and every person will have a different view.

I always use Herzberg’s two-factor theory as a starting point...

Jacob Wilkins (5/24/2016)

---

Pretty sure it requires sysadmin.

There's an active Connect item complaining about this: https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug.

The Microsoft engineer who responded initially said:

The minimum security requirement is sysadmin. This is by...

"Tables should have primary keys." I wish others believed/thought that way, because I see a lot of tables with no keys of any kind, let alone have a primary key.

quackhandle1975 (5/23/2016)

---

Full marks Rob, at least you understood the implications and made changes to resolve that. My issue is the in house devs who are developing with full sysadmin...

I've been added to the db_owner role in that database. It's our understanding that would be more than sufficient in order to make it possible for me to debug stored...

As a developer who was part of a team in the past that liberally hard-coded the 'sa' account and its password in lots of applications and all reports, I've got...

johnwalker10 (5/20/2016)

---

to fix this error create a new database role

CREATE ROLE db_executor;

then...

Thom A (5/20/2016)

---

You haven't accidentally changed your configuration at all have you? Each configuration will have a different TargetServerURL, so if you changed from Release to Debug, for example, you...