So instead of the traditional Scope Triangle of Time / Cost / Quality, we may need to now add Coffee.

Rather than SQL Injection (embedding SQL into the URL), it appears that a user is simply pasting javascript fragments into a text field, so it gets saved to your varchar...

There is a lot to be said for simply disabling the 'SA' account just to see if someone outside the DBA team is crass enough to actually complain.

kiwood (11/2/2016)

---

Eric M Russell (11/2/2016)If IT was providing executive management with reports indicating an unusual spike in the number of new accounts opened and fees generated, then they have done...

In the case of WellsFargo Bank, what's notable is how many people were involved and pervasive it was across practically all it's regional locations. I'm not sure that putting the...

To help (but not prevent) false positives, you can start by joining SYSTEM_SQL_MODULES.DEFINITION on a set of actual function names rather than attempting to parse the WHERE clause for what...

Rod at work (11/2/2016)

---

David.Poole (11/1/2016)

---

I read a blog post about a bloke in a coffee shop who was approached by an old man who turned out to have been one...

One big problem I have with conventional society is that we have way too many people in suits trying to hustle for money and not enough engineers, laborers, and teachers...

kiwood (11/2/2016)

---

I think to even suggest that the IT department could/should have prevented the mess at Well's Fargo is dangerous and perhaps unethical. Consider the news: people who pointed out...

Now that we have SQL Server running on Windows Core and Linux, some of you old-school DBAs will have to get acquainted with command line tools. 🙂

You have to choose to right tool for the job. Counting vehicles as they pass under a bridge on an eight lane interstate highway is very different than counting financial...

Did they mention anything about SSIS being ported to Azure PaaS ?

Gary Varga (10/31/2016)

---

I could...

In most shops, trying to argue with application developers on the issue of proper database modeling and SQL coding is a lost cause. You'll just end up earning a reputation...

OLAP tools like SSAS are excellent for specific types of data access patterns and are an order of magnitude better at solving these problems than relational and no-sql database platforms....