| A community of more than 1,600,000 database professionals and growing |
| | | Yet Another Database The "yet another" moniker is used throughout technology. YAAF, YARN, YAML, and more ways that people talk about yet another way to solve some problem or build a platform. That's one of the amazing things about technology is that we, as a group, are not satisfied with the way things are done. Someone is constantly looking to find a better solution and advance our technology choices in a new direction. In the database world, we've seen changes as well. Relational databases were the obvious, or perhaps just dominant, choice for most of my career. At some point I saw object databases, XML databases, then streaming databases, none of which gained much popularity. The last few years have seen document databases, graph databases, key value databases, and more. We categorize databases as row-store or column-stores now. There are probably other types I'm forgetting. There are also categorizations of OLTP, OLAP, operational, ODS, data warehouses (DW), etc. that people use. I ran across a piece called "Why you need another database", whose opening line is "Do you really need yet another database?" The answer is, sure, you need an analytical database, but I think the piece is a bit behind the times. Lots of people have built an analytic database in the form or a relational DW, an SSAS cube, or perhaps some other type of NoSQL store (Hadoop is popular) that allows analysis of data away from an operational, every day OLTP system. I would guess many of you have some separate reporting copy of data that allows analysis separately from your online system. This could be a copy of your production database, a data warehouse receiving regular loads, a read-only AG replica, or something else. Some of you might perform analysis in your primary OLTP system, with enough spare capacity to handle the reporting load. There are multiple ways in which you may decide to implement an analytical database, but I do agree that most businesses ought to have some way of analyzing the data they collect. The questions in the piece (structure, size, analytics), are good ones, and no matter what your platform, architecture, or technology, make sure that you build something that meets the needs of your organization as a whole, not just the technologists that prefer one decision over another. 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 ( 3.4MB) 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 | | | | Free SSMS add-in: SQL Search Redgate SQL Search is a free SSMS add-in that lets you find fragments of SQL across multiple objects and multiple databases. Once installed, SQL Search appears on the SSMS toolbar, allowing you to quickly navigate to objects wherever they are on a server. Download SQL Search now. |
| | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
| | | | Not enough hours in your day? The SQL Toolbelt lets you reduce the time spent on SQL Server development and administration. Cambridge University developer David Spaxman, for example, says: “I’m saving 10-12 hours a week using the SQL Toolbelt.” Learn how you can double your productivity, speed up deployments and protect your data. Download a free trial. |
|
|
|
| | | | | Mike McQuillan from SQLServerCentral.com See how the OVER() clause was used in a live system to fix overlapping field version numbers. More » |
| | Additional Articles from SimpleTalk SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by arranging for each user connected to the database to see a snapshot of the rows of the tables at a point in time, No changes made by the user will be seen by other users of the database until the changes have been completed and committed. It is conceptually simple but does the user always see the correct version of a row under all circumstances? Shel Burkow explains. More » |
| | Press Release from SQLServerCentral.com A free day of training on Monday, October 24 in Seattle this year. Join MCMs, MVPs, and Friends of Redgate for a free day of training. More » |
| | Daniel Janik from SQLServerCentral Blogs Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting... More » |
|
|
| | | Today's Question (by Steve Jones): I've got these queries. Which of these will work for my insert statement? -- query 1 INSERT dbo.Employee ( id, name, salary ) VALUES ( 4 -- id - int , 'Kendall' -- name - varchar(200) , 12 -- salary - numeric(10, 4) ) -- query 2 INSERT dbo.Employee ( id, name, salary ) VALUES ( 4 -- id - int , (SELECT firstname + ' ' + lastname FROM dbo.Employees WHERE EmployeeID = 3) , 12 -- salary - numeric(10, 4) ) -- query 3 INSERT dbo.Employee ( id, name, salary ) VALUES ( SELECT EmployeeID , firstname + ' ' + lastname , salary FROM dbo.Employees WHERE EmployeeID = 3 ) -- query 4 INSERT dbo.Employee ( id, name, salary ) VALUES ( (SELECT EmployeeID , firstname + ' ' + lastname , salary FROM dbo.Employees WHERE EmployeeID = 3 ) ) -- query 5 INSERT dbo.Employee ( id, name, salary ) VALUES ( (SELECT EmployeeID FROM dbo.Employees WHERE EmployeeID = 3) , (SELECT firstname + ' ' + lastname FROM dbo.Employees WHERE EmployeeID = 3) , (SELECT salary FROM dbo.Employees WHERE EmployeeID = 3) ) |
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: T-SQL. 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 | | With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and analysis cover all you need to know to create complete BI solutions with these powerful new tools. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | Darko Martinovic from SQLServerCentral.com There are situations when it is necessary to determine the age of the patient in the form yy mm dd. Or when it is necessary to determine the length of service of employees. Also in the form yy mm dd. The natural solution for this is .Net coding. But sometimes it is necessary to achieve a solution through T-SQL. This script serves it. 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. add the topic poll - [url=http://staffmobility.eu/sites/default/files/falcons_vs_seahawks_live_stream_online_tv_coverage_nfl_2016_free_week-6.pdf] Falcons vs Seahawks Live Stream[/url] Newbie here... Wishing to learn SQL and SSIS/SSRS/SSAS - Hi all, A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to... US since Wilma struck - [url=http://www.colorado.edu/disabilityservices/sites/default/files/webform/foxseattle-cowboys-vs-packers-live-stream-16-oct-2016-centurylinkfield-video-gamecast.pdf]Cowboys vs Packers Live Streaming[/url] marketing messages - That’s what makes content marketing so intriguing in today’s [url="https://youtu.be/R7lhpaP6cKA"]car crashes[/url] environment of thousands of marketing messages per person per... migrating sql server 2005, 2008 and 2012 to 2014 on new server new storage - Hi all, Its a new build and we have to migrate clustered sql servers instances. In old, sql server is 2005,2008... Blocking by Insert - Found the below query causing blocking from different SPID. declare @0 bigint,@1 bigint,@2 varchar(50),@3 bit,@4 varchar(50),@5 datetime2(7),@6 varchar(50),@7 datetime2(7) INSERT [dbo].[Transaction] ([TransactionId], [ConId],... these segments furthermore pay a section - these segments furthermore pay a section in building your immense muscle tissues. Here are those parts which are essentially here... Error - Cannot generated SSPI context - I got this error from an Access frontend application connecting to the SQL 2014 via ODBC linked tables. [Microsoft][ODBC SQL Server... finding the current ID value compared to the IDENTITY value - Hi I need to find the current identity value compared to the current column value of tables with identity fields - in... Restarting SQL Server Instance from SSMS Error - Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by... Log_Reuse_wait_desc - Experts, Our DB is in Full recovery mode . The total DB size is 25GB and 15GB is log file . We are... Database Mail Error - INSERT permission was denied on the object 'sysmail_attachments_transfer', - I got a very strange error in Database Mail, which used to work, sending out emails with attachments (pdf). The error... does following query needs union or using cases/isnull/coalace will do. - hi. all first cols are pk of the table. either #i or #j will have entery for #a table's record. like aid... apply, although stations are allowed to play - [url=http://www.colorado.edu/disabilityservices/sites/default/files/webform/fox-cowboys-vs-packers-live-stream-nfl-week-american-football-watch-16-oct-2016-tv-coverage.pdf]Cowboys vs Packers Live Streaming[/url] rules conference organized by Rutgers, Princeton - [url=http://www.colorado.edu/disabilityservices/sites/default/files/webform/hq-seahawks-vs-falcons-live-stream-nfl-week-american-football-watch-16-oct-2016-tv-coverage.pdf]Seahawks vs Falcons Live Streaming[/url] Performance question for migration purpose - [url=http://staffmobility.eu/sites/default/files/falcons_vs_seahawks_live_stream_online_tv_coverage_nfl_2016_free_week-6.pdf] Falcons vs Seahawks Live Stream[/url] has been mentioned as a potential site - [url=http://www.colorado.edu/disabilityservices/sites/default/files/webform/chiefs-vs-raiders-live-stream-nfl-week-american-football-watch-16-oct-2016-tv-coverage.pdf]Chiefs vs Raiders Live Streaming[/url] has been mentioned as a potential site - has been mentioned as a potential site SQL Cluster Migration - Hi there, I have the task of migrating two 2-node SQL 2008 R2 clusters on to new hardware. Currently the plan... Generic connection manager setting - Hi Sir,Madam, we are doing our SSIS jobs in one of the AWS server and we are copying/ moving into other... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
