How Two PASS Chapters Join Forces to Run One SQLSaturday In Orlando

We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40...

Loading Data into Clustered Columnstore Index with SSIS

I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...

Microsoft’s Commitment to Azure

For several years, many of us who were involved with working in Azure from the early days, were concerned that...

Promotions and Conflicts of Interest

I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board...

Speaking at 24 Hours of PASS – The Evolution of Data Platform

As announced a couple of hours ago, a new edition of the famous online webinars 24 Hours of PASS will...

A Speaking Sabbatical

Lately I’ve been thinking about taking a break from doing presentations. Not sure what triggered it – maybe just a sense...

JSON in SQL Server 2016 – The Good, The Bad, and The Ugly

Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see...

MongoDB – Insert,Update,Upsert and Delete Examples – CRUD

In MongoDB we have to use either insert() or save() method to add the document to a collection

Insert Single document
> db.employee.insert( 
    {"employee_id":1101, 
    "name":"Prashanth", 
    "sal":90000, 
    "dob": newDate(1983,2,3,5,20), 
    "department": 
        [ 
            'DB Amdin','DB Developer' 
        ], 
    "Location":"New York"});
Insert Multiple...

Notes From the April 19, 2016 Pinellas SQL Meeting

I drove to Clearwater (and back) yesterday to attend and present to the Pinellas SQL group. Misc notes from the...

Partition Switching #TSQL2SDAY #77

 
The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does...