Today we have a guest editorial as Steve is on vacation.
I love Big Data twaddle. ‘Big data will become a key basis of competition, underpinning new waves of productivity growth, innovation, and consumer surplus’, ‘Big Data helps drive efficiency, quality, and personalized products and services, producing higher levels of customer satisfaction and experience.’, ’ In an era of dramatic technology changes, the rise of big data analytics has certainly been one of the most influential’, ‘Big Data: A Revolution That Will Transform How We Live, Work and Think’. Yes, it’s horsefeathers, and I could go on quoting this stuff for ages, giggling between breaths.
I love this caffeine-talk, but it is wrong to dismiss it entirely as the babble of over-excited marketeers. It is a great change to be able read so much enthusiasm within the industry. They are excited about ‘predictive’ technologies that enable us to find significant trends from the data we already have using techniques that are by no means new, and which have little to do with the products now heavily marketed as ‘Big Data’.
I reckon that we should capitalise on the buzz about big data, by steering it gently but firmly to reality. For years, we in the database industry have struggled to explain to businesses the great value of multivariate statistical techniques, regression and predictive modelling on data. Suddenly, the industry understands the value of this sort of magic but attributes it to the wrong wizard. We have the tools already. We don’t actually need huge datastores to keep all the data once we’ve done the preliminary aggregations. The most spectacular successes of statistical modelling have used relatively small data sets, but the right data, and the tools to provide these ‘insights’ have been around for years and are freely available. R and SQL Server fit together remarkably easily, and I imagine that there are only two things that have restrained us in the past. Firstly has been a previous lack of management enthusiasm for it and secondly has been our lack of training in statistical regression analysis and multivariate analysis. It is up to those of us who do business Intelligence to wise up to what is really fuelling this wave of enthusiasm and exploit it by showing the industry that it can be delivered without having to open the big wallet.
“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP. Download a 14-day free trial.
Free eBook: 25 Secrets for Faster ASP.NET Applications
Want to speed up your web application? Our new eBook has 25 tips for getting maximum performance from ASP.NET - download it free
Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there. More »
Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? More »
When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started. More »
SQL Server 2012 Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You’ll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You’ll learn to recognize bottlenecks and defuse them before the phone rings. You’ll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server 2012 Query Performance Tuning into practice today.
Running SSIS 2008 and SSIS 2012 on same server
- Hi guys, hope someone can help me out.
This msdn article: [url=http://msdn.microsoft.com/en-us/library/ms143731.aspx]http://msdn.microsoft.com/en-us/library/ms143731.aspx[/url] suggests that SSIS 2012 can be installed on the...
Using like over charindex to search for pattern
- We where using charindex to search for a string as shown below
WHERE ( Charindex('47a%$.abc',CAST(columnname AS VARCHAR(MAX)))>0 ) [/code]
I am planning...
Email Stop - SQL 2k8?
Email alert stopped automatically due to as below error messages, what could be reason?
The mail could not be sent to...
Alerts for Database Mirroring
I'm trying to get SQL Server to alert me via email when the Primary instance loses connection with Mirrored instance...
A way to shred an XML Deadlock report for easier reading...
- I'm not taking credit for this, I just took some code WayneS posted a couple years back here: [url=http://www.sqlservercentral.com/Forums/Topic955603-360-1.aspx]http://www.sqlservercentral.com/Forums/Topic955603-360-1.aspx[/url] and...
- i have table with name orders and field as order_number,order_amt,order_date,order_customer,order_saleperson
i want to write a query that selects all orders save...
select or count based on condition
- [font="Courier New"]I have a query that returns results similar to this:
Name-Order-Item - ItemShipDateTime
Joe - O23 - I11 - 2013-07-29 13:05:00
Jim - O24 - I11 - 2013-07-29 13:07:00
Detecting ALTER or CREATE PROCEDURE??
- Can't get this working - whinges about ALTER/CREATE statement syntax ?? Help?
IF (SELECT count(name) FROM sys.sysobjects WHERE (type = 'P') and name = 'SPNAME')...
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.