SQL and NoSQL Database Features and Differences
In this tip we will talk about the features and main differences between SQL and NoSQL databases.
2019-04-10
SQL
Introduction to SQL for Cosmos DB
This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.
2019-03-25
219 reads
Resumable Online Index Create and Rebuild Operations
Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.
2019-03-21
1,738 reads
Introduction to SQL Server Security — Part 3
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
2019-03-11
Introducing SQL+ Dot Net
SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.
2019-03-07
2,775 reads
Empty Thoughts: Working with NULL
Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations.
2019-02-11
3,289 reads
Saving Data to Various Formats, Using SQL
You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.
2019-01-17
3,509 reads
Building RESTful APIs using Node JS, Express JS, and MS SQL Server
This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server.
2018-07-30
6,286 reads
2018-03-19 (first published: 2018-03-15)
354 reads
2017-12-29 (first published: 2017-12-27)
434 reads
Blogs
Query Performance Tuning with Filtered Statistics
Introduction I recently got a call from our DBA telling me that the CPU...
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Forums
Growing and Changing
Comments posted to this topic are about the item Growing and Changing
Azure Stretch Database, Part I: Getting Going
Comments posted to this topic are about the item Azure Stretch Database, Part I:...
Minimalistic SELECT
Comments posted to this topic are about the item Minimalistic SELECT
Ask SSC