GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to estimate savings...

SQL Server 2008 supports row and page compression. I havn't heard anything about improvements to the compression algorithm in 2014.

You can estimate the compression savings on a table using the...

Rod at work (11/2/2016)

---

David.Poole (11/2/2016)

---

Terry Pratchett described how the city of Ankh Morpork dealt with a plague of rats by paying a bounty on dead rats delivered. Despite this...

Sean Redmond (11/3/2016)

---

The horrifying thought is that Microsoft will start to include the coffee-factor into their licensing calculations. Enterprise Edition users are allowed unlimited cups of coffee and a better...

Rod at work (11/3/2016)

---

Eric M Russell (11/2/2016)

---

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...

That depends on how much budget our company has allocated to coffee.

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...