From the perspective of a Business Intelligence professional, there isn't that much difference between a Microsoft SELECT statement and an Oracle SELECT statement. Also, it sounds like you would coming...

Steve Jones - SSC Editor (3/9/2016)

---

Eric M Russell (3/9/2016)

---

It sounds similar to Microsoft Lync / Skype. It's useful for those situations where you need a quick ad-hoc group conversation between...

It sounds similar to Microsoft Lync / Skype. It's useful for those situations where you need a quick ad-hoc group conversation between team members. A lot of useful information can...

As you've already learned the hard way, deleting 600 GB of data is even more time consuming that selecting it 30x over, and yes it's transaction logging that's eating most...

I'm glad to hear that SQL Server 2016 will now support non-clustered indexes, primary keys, and foreign keys on Clustered ColumnStore tables.

adam.hoelscher (3/7/2016)

---

I work in the Healthcare and Group Benefits Consulting field in the United States. Just FYI for anybody reading: many employers conduct what are called "Dependent Eligibility Audits". These...

At least we have a choice. What gets me is when folks take the choice that costs them more money for basically the same level of service, and then they...

One of my ongoing projects is maintaining a PowerShell script to automate the A - Z installation of SQL Server on freshly provisioned virtual machine environments. It first does a...

If you are certain there is a 1-1 relationship between these columns, meaning they are all essentially attributes of one entity and not stand alone entities, then I'd lean in...

null

Also, let's not forget the HeartBleed vulnerability discovered a few years back in OpenSSL.

http://www.pcworld.com/article/2141740/is-open-source-to-blame-for-the-heartbleed-bug.html

Open Source means that the public can review the code to verify that the developers are not...

Half a GB of clickstream data per NetFlix user every day should raise some eyebrows. When I read about these PB and EB scale Big Data projects, I think about...

Microsoft is the IT equivalent of an 18 wheeled transport truck; it's definately in the slow lane when climbing a steep hill, but it's unstoppable on the flip side.

The best IDE tools separate logical design from the physical design while at the same time keeping them integrated into one seamless end-to-end process. For example a business analyst can...

Most of the algorithms we use today are based on proven statistical models that are a century or more old. However, for an algorithm to do it's job (make accurate...