Click here to monitor SSC

2013 October


Phil Factor

A Knights Tale

2 comments

There are so many lessons to be learned from the story of Knight Capital losing nearly half a billion dollars as a result of a deployment gone wrong. The Knight Capital Group (KCG N) was an American global financial services firm engaging in market making, electronic execution, and institutional sales and trading. According to the […]

25 October 2013 6:47 pm by
Tony Davis

What the Hekaton?

11 comments

Hekaton, the power behind SQL Server 2014′s In-Memory OLTP technology, is intended to make data operations run orders of magnitude faster on SQL Server. This works its magic partly by serving database workloads entirely from main memory, using memory-optimized table structures. It replaces the relational engine’s standard locking model with an optimistic concurrency model based […]

25 October 2013 11:09 am by
Ben Emmett

Clever memory usage through the years

1 comment

A friend and I were recently talking about the really clever tricks people have used to get the most out of memory. I thought I’d share my favorites, and would love to hear yours too! Interleaving on drum memory Back in the ye olde days before I’d been born (we’re talking the 50s / 60s […]

24 October 2013 5:03 pm by
Claire Brooking

Free eBook with SQL Server performance tips and nuggets

0 comments

I’ve often found that the kind of tips that turn out to be helpful are the ones that encourage me to make a small step outside of a routine. No dramatic changes – just a quick suggestion that changes an approach. As a languages student at university, one of the best I spotted came from […]

23 October 2013 3:48 pm by
Fatherjack

PASS Summit – looking back on my first time

0 comments

  So I was lucky enough to get my first experience of PASS Summit this year and took some time beforehand to read some blogs and reference material to get an idea on what to do and how to get the best out of my visit. Having been to other conferences – technical and non-technical […]

21 October 2013 1:41 pm by
Nigel Rivett

Powershell – script all objects on all databases to files

0 comments

<# This simple PowerShell routine scripts out all the user-defined functions, stored procedures, tables and views in all the databases on the server that you specify, to the path that you specify. SMO must be installed on the machine (it happens if SSMS is installed) To run – set the servername and path Open a […]

18 October 2013 9:03 am by
Varun Chatterji

AngularJS on top of ASP.NET: Moving the MVC framework out to the browser

2 comments

Heavily drawing inspiration from Ruby on Rails, MVC4’s convention over configuration model of development soon became the Holy Grail of .NET web development. The MVC model brought with it the goodness of proper separation of concerns between business logic, data, and the presentation logic. However, the MVC paradigm, was still one in which server side […]

16 October 2013 2:12 pm by
Tony Davis

PASS 13 Dispatches: moving to the cloud

0 comments

PASS Summit 13, Day 1 keynote by Quentin Clarke and we're hearing about “redefiniing mission critical in the cloud”. With a move to the Windows Azure cloud comes the promise of capacity on demand, automatic HA, backups, patching and so on, as well as passing responsibility to MS for managing hardware, upgrades and so on. […]

16 October 2013 1:39 pm by
Tony Davis

PASS 13 Dispatches: Memory Optimized = On

0 comments

I'm at the PASS Summit in Charlotte for the Day 1 keynote by Quentin Clarke, Corporate VP of the data platform group at Microsoft. He's talking about how SQL Server 2014 is “pushing boundaries” and first up is SQL Server 2014's In-Memory OLTP technology (former codename “hekaton”) It is a feature that provokes a lot […]

16 October 2013 12:59 pm by
Roger Hart

Windows Phone 8, possible tablets and what the latest update might mean

1 comment

Microsoft have just announced an update to Windows Phone 8. As one of the five, maybe six people who actually bought a WP8 handset I found this interesting. Then I read the blog post about it, and rushed off to write somewhat less than a thousand words about a single picture. The blog post announces […]

14 October 2013 2:28 pm by
Older posts