Introduction Microsoft announced in September 2018 that SQL Server 2019, which is now in preview, will have a Big Data Cluster deployment option. This is a Big-Data-capable SQL Server with elastic scale and extended Artificial Intelligence (AI) capabilities, mostly as a result of deep integration of Hadoop and Spark out-of-the-box. The new SQL Server Big […]
2019-09-09
4,511 reads
In this tip we will talk about the features and main differences between SQL and NoSQL databases.
2019-04-10
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
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
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
SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.
2019-03-07
3,169 reads
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
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
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
11,955 reads
2018-03-19 (first published: 2018-03-15)
373 reads
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By kleegeek
Resource pools are used to hierarchically partition available CPU and memory resources, and are...
Hi all, My need is to insert random value from predefined list of possible...
The University of Leeds
Today’s tip is to Immerse yourself in a new book, TV show, or podcast....
Ask SSC