Monthly Archives: February 2014

Are PCs Dying? Of Course Not, Here’s Why

Reports of the PC’s demise have been greatly exaggerated. We’ve all heard that everyone’s just buying tablets and throwing out their keyboards and mice. But, if you live in the real world, you see people using PCs every day. The … Continue reading

Posted in SQL Server | Tagged | Comments Off on Are PCs Dying? Of Course Not, Here’s Why

Microsoft Launches OneDrive For Business, Formerly SkyDrive Pro, With New Design

Microsoft Launches OneDrive For Business, Formerly SkyDrive Pro, With New Design A week after officially rebranding SkyDrive as OneDrive, Microsoft has updated the official iOS app of its popular cloud storage service’s business edition to reflect the name change and … Continue reading

Posted in Microsoft, OneDrive, SQL Server | Tagged | Comments Off on Microsoft Launches OneDrive For Business, Formerly SkyDrive Pro, With New Design

creating a Date Dimension table

Frequently, I have to create a ‘Date Dimension’ table for complex date logic. This is the first script I found on the internet.. that actually works.  Lots of other scripts required SQL 2008 or SQL 2012 notation..  most other scripts … Continue reading

Posted in SQL Server | Tagged | Comments Off on creating a Date Dimension table

Transaction Isolation Levels

Great article on transaction isolation levels.. had to share. http://www.reddit.com/r/Database/comments/1wd7kz/best_explanation_of_transaction_isolation_levels/

Posted in SQL Server | Tagged | Comments Off on Transaction Isolation Levels

Results of the SQL Performance Quiz: 60% fail

Great quiz on SQL indexing. http://use-the-index-luke.com/blog/2014-02/results-three-minutes-sql-performance-quiz

Posted in SQL Server | Tagged | Comments Off on Results of the SQL Performance Quiz: 60% fail

Google Cloud SQL debuts, following Amazon's RDS lead

Two and a half years after offering a limited preview, Google has finally opened up Cloud SQL, its managed database service, to all comers. What’s more, it includes a service-level agreement — a sign Google wants users to think of … Continue reading

Posted in SQL Server | Tagged | Comments Off on Google Cloud SQL debuts, following Amazon's RDS lead

Put Big Data Playtime to Bed

If you’re an on-the-job analytics professional, you may feel the pressure starting to build. Big data playtime is over, and real work needs to get done — now. It’s a bit of a “big data shakeout,” in the words of … Continue reading

Posted in SQL Server | Tagged | Comments Off on Put Big Data Playtime to Bed

Big Data Hype Is So 2013

In a recent episode of Robin Williams’s sitcom “The Crazy Ones,” a client of his advertising firm forces him to bring on a “quant,” or quantitative analyst. Williams’s character has no idea what a quant is, but his daughter explains … Continue reading

Posted in SQL Server | Tagged | Comments Off on Big Data Hype Is So 2013

Big-Data Über Alles

I’ve been on public record for decades criticizing the tendency, every few years, to declare a paradigm shift in data management, a “the world will never be the same” kind of change demanding “fundamentally new ways” of doing things that … Continue reading

Posted in SQL Server | Tagged | Comments Off on Big-Data Über Alles

WordPress.com has REMOVED their primary app from the Windows Store. WHY?

Dear Friends / Customers / CoWorkers; I have been having a love affair recently. After a dozen years committed to the database industry, I have fallen in LOVE with WordPress. I still have a lot to learn about WordPress.  I … Continue reading

Posted in SQL Server, Windows | Tagged | Comments Off on WordPress.com has REMOVED their primary app from the Windows Store. WHY?