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

Payment and the Board

If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and...

Symbols

I just want to write the setup I went through for using debug symbols within SQL Server to resolve call...

Why my primary test environment is case sensitive.

Me: I think I’m going create a new playground instance.
Myself: Make sure you use a case sensitive (CS) collation when...

A View Is Not A Table

Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...

Overview of Published Articles – 2016Q1

Here is an overview of the articles I published in the first quarter of 2016.
R Services series:
SQL Server 2016 R Services:...