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

2016-04-20

500 reads

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

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

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

2016-04-20

740 reads

Notes From the April 19, 2016 Pinellas SQL Meeting

by Andy Warren

SQLAndy

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

2016-04-20

523 reads

Why my primary test environment is case sensitive.

by Kenneth Fisher

SQLStudies

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

2016-04-20

416 reads

Symbols

by Arun Sirpal

All About SQL

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

2016-04-20

231 reads

The SQL Server reports

by Igor Micev

Si vis pacem, para sql

SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version.SQL folks in general,...

2016-04-19

1,767 reads

The standard SQL Server reports

by Igor Micev

Si vis pacem, para sql

SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version. SQL folks in general, usually don’t take them as handy, or maybe...

2016-04-19

57 reads

The standard SQL Server reports

by Igor Micev

Si vis pacem, para sql

SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version. SQL folks in general, usually don’t take them as handy, or maybe...

2016-04-19

30 reads