There's a great quote I read, at the end of this article. It says: "...if you think that switching to NoSQL will just let you hand-wave away all of the challenges of running a database, you are terribly misguided." The context is that all too often people looking to move away from some of the hassles of working with RDBMS platforms, which includes working with the DBA, haven't completely thought through the issues.
I do think NoSQL has a place in the world. There are domains of problems that I'm sure Riak, MongoDB, and others, solve in a more efficient way than SQL Server, Oracle, MySQL, and other relational systems. I'm not sure what they are, and to some extent, I haven't seen good guidance on where particular platforms excel. Most of the articles and pieces on choosing NoSQL seem to be trying to sell me "why a particular platform can replace my other one", and telling me to add in things like transactions, but not explaining the drawbacks.
However in all platforms, we often forget that there are really two frames of reference that matter. We need quick ways to work with data, insert it, update it, query it, etc. This is the development frame of reference, and it often dominates discussions of platforms. For good reasons, as developers are expensive, but that's only part of the system. We also need to consider the operational portion of managing data and applications. When I have those needs to rebuild indexes in relational platforms, or the requirement to periodically merge/remove old versions of documents, or even manage clustered, horizontally scaled resources, we need operational maturity.
In some sense the DevOps movement is built around merging these two frames of reference into the minds of all those involved. I hope that movement continues to grow and mature, and we learn that developers and operational staff are both necessary, and both need to function in a symbiotic, harmonious fashion.
In this tip we have a very simple data flow using a source query with a predictable duration. The data flow takes longer to process all the rows and even larger buffers didn't make the problem go away. What can be the cause of this and how do we solve this? Koen Verbeeck explains. More »
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week... More »
Question of the Day
Today's Question (by Tom Thomson):
Which of the following editions of SQL 2014 suppotys the Buffer Pool Extension feature?
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: SQL Server 2014.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
Pick up your copy of this great book from MVP Glenn Berry at Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
How do you remove a memory-optimized table filegroup from your database in SQL Server 2014?
Answer: drop the database
The only way to remove a memory-optmized filegroup in SQL Server 2014 is to drop the database.
Monitoring Clustered Server
- Hi All,
Could you please let me know what are the events to be monitored for a Active/Passive Cluster?
Thanks in Advance.
Identifying what caused Corruption
- I had a database in suspect mode this morning.
Fixed it by:
-placing in emergency mode.
-set single_user mode
-dbcc checkdb(N'dbname', REPAIR_ALLOW_DAT_LOSS)
-Rebuild the log.
Password History Table
I have a table of users including: UserName, Password (comuted col), FirstName, LastName, Address and other details....
I have to keep...
The storage of VARCHAR(MAX) when null
- Hi all,
If I have a table
CREATE TABLE [dbo].[logg](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[Details] [varchar](MAX) NULL)
insert logg (Details) values('')
insert logg (Details) values(null)
Hanging WHILE loop
- Hello Everyone,
My name is Tom and I'm studying for my Data Platforms MCSE, its still early days so bear with...
Case statement with <> condition
- I have query something like this ..i haven't posted here original quary
[code="sql"] IF (@p_flag = 1)
FROM Test1 T1
INNER JOIN Test2 T2...
Error in Loading CSV file
- Hi All,
I am getting when loading data from csv file..
[Flat File Source ] Error: Cannot open the datafile "20140505_Sales_new.csv".
Divide column values
I have these two columns
'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)as MONEY),1), '.00', '') as Total_Amount,
'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Monthly_Amount,2)as MONEY),1), '.00', '') as Monthly_Amount
Now Monthly_Amount column should...
SSRS -- Error while subscribing for new role
- Hi all,
I'm getting below error while subscribing for new role in SSRS.
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report...
SSIS caching error
- I am running a pretty straight forward dataflow that is:
Source -> Lookup -> Destination
I am in the process of trying...
DEMO_CODE = 'DE1'
- Hi everyone.
I have these two records in [prj_demo_data] table:
[code="other"]prj_code demo_code decmo_vchar_data
1425 DE1 U
1425 RAP YES
1426 DE1 B[/code]
How do I select...
forming a dynamic query
- have a sp with 4 parameters the values of this parameters is obtained from application
currently i have
Percentage Calculation in Metrics Report.
- Hi All,
Measure value percentage value percentage
Failed 100 percent 1 200
Delivered 100 percent 2 200
Unknown 100 percent 3 200
Total 300 600
i have a metric...
group by clasue in mdx
- Hi Friends i have small doubt in mdx query.
table having data like below
table name : patieninformation
pn prcode dos Expected Payment
MS0000003 PT001 1/2/2013 29.72 0
MS0000003 PT001 1/21/2013 57.1 0
MS0000003 PT002 6/7/2013 26.69...
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.