 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | What is NoSQL? Unless you've been highly disconnected or working heads down for the last 5 years, you've probably heard of NoSQL databases. You might have had developers ask to use one. Even if you might never have actually dealt with one, sticking inside your SQL Server comfort zone, you've probably heard of them. Recently I was watching someone talk about CosmosDB, which I think is a great platform. I've actually be looking for a project to use and experiment with the platform, and I think Microsoft has truly built an attractive platform that might get lots of people to consider Azure for distributed applications. CosmosDB essentially implements a number of alternative database APIs, many of which are thought of as NoSQL platforms. So, what does NoSQL mean? Plenty of people view this as No SQL Allowed, but that's not really correct. This moniker was used to mean "Not only SQL", with the intention that there are perhaps other ways to store and query data. Graph databases and document databases seem to be the most common ones that are discussed. Key-value stores and in-memory databases, such as Redis, are other very popular data stores. There are plenty of other choices for a place to keep your data. If you examine the rankings of database engines, you will find over a 100 different databases in use. The top ten are mostly relational stores, as are most of the top 20. There are plenty of other types in the list, and NoSQL databases are certainly gaining popularity. While I don't think they will replace the use of an RDBMS for many applications, I'd expect that we will see more applications built with backing from multiple data stores. There are very useful NoSQL databases out there, and you might consider spending some of your learning time working with one. If you're in the Microsoft space, CosmosDB makes the most sense, and this will allow you the opportunity to work with a few different types of NoSQL APIs. If you're worried about costs, you can use the local emulator on your own system for free. I don't anticipate NoSQL taking over a majority of my job anytime soon, but I do think it's worth understanding how the different stores work and where they might help you solve a problem. Especially if you're optimistic and believe your application might scale up dramatically in the future. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
| | ADVERTISEMENT |  | | NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial |
|  | | SQL in the City Summits - New York, London & Chicago This October, Redgate are inviting those interested in learning how their business can benefit from implementing Compliant Database DevOps to attend one of our SQL in the City Summits. If you manage SQL Server databases, or manage a team of people who do so, Redgate’s SQL in the City Summit is the conference for you. Find out who’s presenting and register for a Summit near you today.
Register now |
|
|
|
| | |  | Thom Andrews from SQLServerCentral.com Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL. More » |
 | Additional Articles from SimpleTalk In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well. More » |
 | Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the same time, however, the increasing pace of business means developers need to create and release code in much shorter DevOps timescales. Steve Jones discussed ways to solve this conflict More » |
 | Dharmendra Keshari from SQLServerCentral Blogs With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It... More » |
| | Kenneth Fisher from SQLServerCentral Blogs Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the... More » |
|
|
| | | Today's Question (by Steve Jones): If I run this statement in SQL Server 2017, SET FIPS_FLAGGER What are the options for the values I can use as a parameter? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SET Options. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I am writing a trigger that is going to take action if either of two columns are changed. I want to use the UPDATE() function for these columns. What will this return for my code to use?
Answer: A Boolean value of true for changes or false for no changes Explanation: The UPDATE() function returns a Boolean value. This is used in an IF or CASE statement to program your trigger. Ref: UPDATE() - click here
» Discuss this question and answer on the forums |
|
|
| | | Jonny Wallman from SQLServerCentral.com This is my little Replace-trick, just because I dont like the Replace(Replase(Replace(Replace string I've seen in a bunch of stored procedure and functions. First off all you should have a Codebase where you can insert all of your functions, mine is called Codesnippets but you can call i wathever you want. More »
|
|
|
| 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 on Linux without domain join - Hi, is it possible, to work with sql server and windows authentication without a domain join. Our linux admins won't join... Importing multiple .xls files in bulk - Hello, Is it possible to import multiple xls files in bulk concurrently, and if so how? I would like to somehow automate / create tables via...
How to split a | delimited string into multiple columns in a query? - Hi, I have the following query: SELECT rc. AS , cd. AS , CASE WHEN CHARINDEX(':', cd.Name) <> 0 THEN & Duplicate records - Hi All: I appreciate your help with this situation: After creating a union between 2 tables in a CTE, there are some contracts...
Remove TDE - Hi, is the resinstalling sqlserver removes the TDE? Thank you!! SQL Server Agent stopped - Event ID 17052 - I've had back to back Saturdays where our SQLServerAgent (Test Instance) has stopped with an Event ID of 17052. The... SSMS failing to install on windows 10 - Ssms keeps hanging on the isolated VS step and fails with error 80070643 What does your backup process look like? - Hi, I'd be interested to hear how most of you have your backups set up. I know a lot of it...
Joins clarification - Let's say I have Table A and Table B. Table A can join onto Table B because both tables have a... SSRS Report version compatibility issue with 2016 to 2012 - Hi Every one, I hope, you are doing good. I am facing a challenges in SQL Server Reporting Services when uploading...
Urgent:Transaction Rollback - Hi Experts, We have a procedure in database A which is inserting 10 millions records from a table in a database... Problem Converting DATE. Trying to Purge Data Oldest than 30 days from Performance Counter Table where date column is char (24) - Hello Acttually i have a regular MSFT performance monitor counter running, which counters are being collected into a SQL Server table. Because... Database logs file size, is normal to have a data log file bigger in size than the data files. - I am starting with the database support to a SQL Server database, this database has two data files and one...
Selecting a VP from an organizational hierarchy - Hello SQL Gurus! I currently have a CTE that if I plug in the VP, it will show all the employees... Count the amount of times values appear in the database - Hello, I have a table of "jobs" which I need to export to an online accounting software. What I need to...
Copy all objects (tables, views, functions, stored procedures) from one DB to another DB - I need to copy some selected objects (tables, views, functions, stored procedures) from one DB (Order) to another DB (OrderHistory) Which... Huge number of tables - Hi all, I've inherited a situation where we have a business critical system with gigantic number of tables, 240,000 - yes, nearly...
Looking for an idea how to construct this T-SQL Select Statement - I have 3 Joined tables in a following select statement: Select A.AgentID, B.AgentSupervisorID, HADDR.AgentAddress From TableA A Join TableB B on <...>...
DATEADD YYYYMM - This gives me last month, can't figure out next month. DECLARE @yrMo
Converting decimals to HH:MM:SS - Hi, I have read a lot of post about this subject and as yet can't find a solution that works... |
|
| This email has been sent to newsletter@newslettercollector.com. 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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
|