We are dealing with more and more data all the time, and in more and more formats. As noted in this piece, companies are receiving data in new formats, from a variety of sources, and the traditional relational database isn't always the best fit for the processing, storage, and management of the information.
However SQL Server isn't just a relational database. It handles unstructured data well, with the Filestream and Filetable enhancements to varbinary columns. We can even read into this unstructured data with iFilters that we install on our instances. In fact, I'll be talking about these filters at DevConnections on Wednesday.
SQL Server has StreamInsight for complex event processing, allowing you to handle very quick streams of data that could overwhelm your OLTP architecture. If that's not enough, there are connectors that allow you to integrate with other data processing architectures, like Hadoop.
With all the various subsystems like SSIS (ETL), Reporting Services (exports to other formats), Service Broker (messaging), spatial data, and more, I think SQL Server is an amazing hybrid database platform in and of itself, without any extra charges for the various features (like some other platforms). That's not to say you shouldn't use any other platfoms. If they work, use them and integrate with SQL Server, but if you don't have other databases in place, I'm not sure you need to look past SQL Server for many of your needs.
SQL Server Live! provides comprehensive education on SQL Server database management, data warehouse/BI model design, Big Data analytics, performance tuning, troubleshooting and coding against SQL Server. Find out more
"A real time saver" Andy Doyle, Head of IT Services
Andy and his team saved time by automating backup and restores with SQL Backup Pro. Find out how much time you could save. Download a free trial now.
5 ways to code effortlessly
Discover the different ways you can make writing, exploring, and refactoring SQL code refreshingly effortless with SQL Prompt 6. Download a free trial.
Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implementation of such a requirement. More »
SQL in the City is coming to Pasadena on October 9. Register for a full day of free SQL Server training the Red Gate way. Top tips and best practices for SQL Server database development and administration will be presented by SQL Server MVP experts, including Steve Jones and Grant Fritchey. You’ll also see Red Gate tools in action and have the chance to network with other data professionals. More »
Richard Morris interviewed Michael Stoop, a database developer at Calvi, Europe's leading provider of Telecom Invoice Management software. The discussion focused on how Calvi transformed their database delivery process to accommodate massive database growth, statutory regulations, and developments in their application. Here's their story. More »
Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.
Maximize your performance on the exam by learning how to:
Create database objects
Work with data
Troubleshoot and optimize queries
You also get an exam discount voucher—making this book an exceptional value and a great career investment.
Yesterday's Question of the Day
(by Steve Jones):
What is the data type used for a column that stores FILESTREAM data?
The data type used for FILESTREAM data is the varbinary type. Specifically, you would declare the column as varbinary(max) and include the FILESTREAM attribute.
how to solve this
- two tables
Write a query that would return teachers who’s students had highest overall percent correct on...
Error in attaching Adventureworks 2012 database
- hi i have problem in attaching Adventure works 2012 database
Attach database failed for Server '..........\MSSQLSERVER2012'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Serve
SQL Server Database Backup Monitoring
- Hi SQL Masters,
Do you have a script that will determine if the backup failed/succeeded?
Database Name Status Log Date
--------------- ---------- --------------
synch two tables
I have two tables one is users and the other is frap_users ,Both contains some common attributes which are required...
Need Help on Fastest Search Logic
I have two tables named "Table1" and "Table2".
id bigint, product_name nvarchar(1000),quantity int
records count on Table1 : 25000( may increase in...
I have written a query and the output for the query is
Run Date Fiscal Year Posting Period Port Fuel Oil Price Gas Oil Price
20061031 2006 10 FOS NULL 578.5
20061031 2006 10 FOS 275 NULL
20061031 2006 10 FUJ NULL 592.5
20061031 2006 10 FUJ 276 NULL
20061031 2006 10 GEN 273 NULL
20061031 2006 10 GEN NULL 568.5
20061031 2006 10 HOU 262 NULL
20061031 2006 10 HOU NULL 537.5
- Dear All
Currently I am getting following result sets
Registerno SubjectCode SubjectName Qno Marks
12402223 171906 Quality And Reliability Engineering 1 4
12402223 171906 Quality And Reliability...
Is this Correct Use of Dynamic SQL???
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
ALTER PROCEDURE [dbo].[SearchBiography]
calculate database size
how can i calculate database size with this information:
Processed 8192240 pages for database 'DBOLTP', file 'rm' on file 1. ??
Default Selection (Report)
- Hello SQL Gurus
I am currently working on a report that a default selection used to select customers. I use Visual...
SSRS 2008 R2. Print Reports In sequential order
- Hi All,
I have 2 reports with following layout
State..........................sales amount-----------------Number of items.......................Average Sales
I need help Please :(
- I have a table name Employee Logs
table consist of EmpID, Empname,Logdatetime.
I can generate the first in and last out by...
TempDB best practices - Doubt
- Hello guys,
I have two doubt:
-- 1 script:
SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],
cpu_count/hyperthread_ratio AS [Physical CPU Count],...
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.