Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

See the upside in a difficult situation that helped you learn something

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Moving away from an RDBMS

I've seen many developers want to migrate away from a relational database (RDBMS) in the last few years. Often this is because they feel some class of NoSQL database (document store, graph database, key-value store, etc.) is easier to work with. They feel that native JSON storage and serialization/deserialization is much easier for them than an object relational mapping. There is also the performance argument, as different systems have been shown to scale quite well by adding nodes, much as we add additional web servers to meet the workload.

CosmosDB is Microsoft's NoSQL offering, combining a few APIs with very high scalablity and low latency. They also offer different consistency models for different needs. In almost every Microsoft event that deals with data, there is some CosmosDB demo, and some are very impressive. The idea of scaling without pre-planning some tier of hardware is appealing. But is this something we'd want to use for our application?

I'm curious what you might think of this piece that looks at a relational model and how that can be implemented in CosmosDB. Data Platform MVP Leonard Lobel walks through a typical commerce application and maps this into various containers and documents, showing how you might migrate away from an RDBMS into CosmosDB.

I find this read interesting, and to be sure, it's a simple view of the application. I'm not convinced this makes sense, though I am sure it would work. I think this is more inefficient than a relational model, and it leaves out lots of the challenges of being able to query lots of data at once. However, perhaps I'm just jaded and set in my preferences for the relational platform.

Read the article, think about the topic, and let me know. Does a move to a CosmosDB structure seem like a good idea for any of your applications? Are there any great benefits, any big downside, or perhaps, just not enough of a difference to even consider a migration? Does this make you more or less likely to consider a non relational store for a future project? Let me know.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents

The Basics of iTVFs

Steve Jones - SSC Editor from SQLServerCentral.com

Learn the basics of inline table valued functions in this short article.

Handling System-named Constraints in SQL Compare

Additional Articles from Redgate

If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them.

Storage 101: Cloud Storage

Additional Articles from SimpleTalk

Throughout this series, Roberts Sheldon has discussed a range of storage-related topics, some of which he mentions only briefly. One of those is cloud storage, which now plays a vital role in today’s data management strategies. Organizations of all types and sizes now employ cloud storage to varying degrees, either to supplement their on-premises systems or to handle the bulk of their data. Because cloud storage has become so pervasive, this article focuses exclusively on that topic, describing what it is, how it works, and its benefits and challenges.

From the SQL Server Central Blogs - Thoughts As Pride Month 2020 Comes to a Close

Chad Crawford from LittleKendra

I’ve begun working on developing a couple of small habits this month, thanks largely to Andy Mallon‘s helpful advocacy. Becoming more consistent in sharing my pronouns My pronouns are...

From the SQL Server Central Blogs - Measuring Well Being

Steve Jones - SSC Editor from The Voice of the DBA

I need to write something more on this, but it struck me that this is something I wish previous employers had done, anonymously, and reported results back to others....

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Unique Clustered Columnstore Index

In SQL Server 2019, can I create a unique clustered columnstore index?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Starting multiple containers

I want to ensure that everyone in my team can easily start multiple docker containers in their environment, with customized configurations. What is the best way to allow my users to start multiple containers that are used for an application with one command when there are dependencies between containers?

Answer: Use docker-compose and a YAML file to define the container configuration

Explanation: The docker-compose application allows multiple containers to be configured in a YAML file, with dependencies, and start them with one command. Ref: docker-compose - https://docs.docker.com/compose/

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
Using two different backup products for each of data and log -   To shorten a long story, my organisation has decided to have a vendor perform daily full backups using "Backup Product A" whilst the DBA will perform transaction log backups using "Backup Product B". The recommendation to use 1 system overall was overruled. In the event a restore is required it will be the DBA's […]
SQL Server 2017 - Development
Update table and then executeJob in loop - I need to write a query which will first update the table, then execute the job and if the job is successful, again update statement. This would be a loop. this is how it looks DECLARE @dttm datetime DEClare @datetable table (dttm datetime) insert into @datetable values ('2017-01-01 00:00:00.000'), ('2018-01-01 00:00:00.000'), ('2019-01-01 00:00:00.000') DECLAre Upddate […]
Adding NOT NULL to column with existing rows causes page bloat - Hi, I'd like to know why the page count is almost exactly doubled for a table with existing rows, having updated the column in question with values so none are NULL (this step also causes double pages, but I understand why, fragmentation becomes 99% so i REBUILD clustered index), then running ALTER TABLE ... ALTER […]
SQL Server 2016 - Administration
How to change the Scan to Seek and optimize - Hello, Attached sample query and actual plan, I want to further optimize the query and change the scan to seek? Do I have to create an IDX or modify the query in this case?  Please let me know thoughts  
Compare sql-2012 and sql-2016 settings - Hi everyone, W are just doing a migration from sql 2012 enterprise  to sql 2016 standard. This involves migrating lots of sql jobs running on sql 2012. I would like to make sure that performance doesn't degrades after we migrate. I would like to check and compare all configurations ( Sever  as well as DB […]
is Clustered Columnstore index UNIQUE by default? - Or should I explicitly specify 'CREATE UNIQUE CLUSTERED COLUMNSTORE INDEX....' ? If I don't specify UNIQUE,  can a clustered index actually be non-unique..??
Failover Cluster Instance Share - Hi, I am using AlwaysOn Availability Groups in SQL Server 2016 with a primary and secondary replica. I have a Quorum file share witness on a separate file server. This file server needs to be rebooted, so I'm wondering what I need to consider before rebooting this box... Anyone have experience with this? Also, I […]
SQL Server 2019 - Administration
Limitation on a file size import - Is there a restriction of file size that can be imported into SQL? 5 gig, 10 gig???
Pintable into cache - Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented every day and it goes through the defragmentation process every week.Which means I am doing the same process over and again every week. Can I pin such tables in the memory permanently or for a specific period of time and write […]
SQL Server Newbies
stored procedure to delete user and login - I was trying these but it does not work: USE [MyDatabase] GO /****** Object: StoredProcedure [dbo].[sp_deletelogin] Script Date: 4.7.2020 3:29:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[sp_deletelogin] @szLogin varchar(50),@defaultdb varchar(50) as if not exists ( select 0 from sys.sql_logins where name = @szlogin) begin EXECUTE AS LOGIN='sa'; exec ('delete login […]
Reporting Services
Upgrade SSRS server but not DB engine? - I need to upgrade the SSRS report server so that it is compatible with Chrome/Edge. However the database server where the SSRS DBs live is not at a stage where I can upgrade it yet as there are 3rd party vendor DBs that need to be investigated. Is this possible? The report and DB servers […]
General
Beginner needing help - Removing post
Integration Services
Connecting To Quickbooks via SSIS - Hello everyone, Been doing some googling trying to find some info on connecting to Quickbooks desktop from SSIS.  Everything I'm getting back is third party options where I have to pay.  Trying to avoid that if I can.  Seems like some sort of ODBC driver or something should be available for this where I can […]
COVID-19 Pandemic
Daily Coping 6 Jun 2020 - Today’s tip is to think of something you’ve always wanted to do and never tried. http://voiceofthedba.com/2020/07/06/daily-coping-6-jul-2020/
Daily Coping 3 Jul 2020 - Today’s tip is to thank a friend for the joy they bring into your life. http://voiceofthedba.com/2020/07/03/daily-coping-3-jul-2020/
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -