Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
Researchers craft molecule that works as flash storage
As features on chips get smaller, we're edging closer to where we bump up against basic physics, which dictates that the behavior of wiring will become unpredictable once the number of atoms involved gets small enough. As a result, there's been some preliminary work done on producing processor components out of single molecules, like carbon nanotubes.
Data as a Service: The Next “As a Service” Wave?
There is increasing demand to deliver data through platform-agnostic open-standard APIs so it can be consumed in a variety of ways, whether refined, aggregated, or combined with additional information. Are we heading towards a shared understanding of applications as data-providers, feeding other services such as BI, or even in the right circumstances, publishing it?
You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject, describing how the ordering can change due to an change in execution plan.
A New Free CA
Announcing Let's Encrypt, a new free certificate authority. This is a joint project of EFF, Mozilla, Cisco, Akamai, and the University of Michigan.
Recompilations, Part 2
With table variables, recompilations based on database schema changes can be avoided. In addition a table variable has no statistics. Therefore statistics don’t have to be maintained, and the second cause of recompilations just disappears. Both things sounds great at first, but we will find huge drawbacks when we look further.
SQL Server 2012 SP2 Cumulative Update 3
Microsoft has released SQL Server 2012 SP2 Cumulative Update 3, which is Build 11.0.5556. This CU has 34 hotfixes in the public fix list. If you are running SQL Server 2012, this is the build you should be planning to get installed, after you have done your testing and planning for the installation.