Click here to monitor SSC

2013 September


Phil Factor

How to get SQL Railroad Diagrams from MSDN BNF syntax notation.

2 comments

On SQL Server Books-On-Line, in the Transact-SQL Reference (database Engine), every SQL Statement has its syntax represented in  ‘Backus–Naur Form’ notation (BNF)  syntax. For a programmer in a hurry, this should be ideal because It is the only quick way to understand and appreciate all the permutations of the syntax. It is a great feature […]

28 September 2013 9:39 am by
Jess Nickson

NHibernate and Stored Procedures in C#

0 comments

I was recently trying and failing to set up NHibernate (v1.2) in an ASP.NET project. The aim was to execute a stored procedure and return the results, but it took several iterations for me to end up with a working solution. In this post I am simply trying to put the required code in one […]

27 September 2013 12:35 pm by
Phil Factor

Getting to the Commissars

16 comments

Recently, I’ve been told, repeatedly, that few organizations have a clear and consistent idea of what they want from an IT project, and that businesses have scant understanding of the business domain, in other words the processes and data, for which a technical solution is being developed. From my own experience with countless IT projects, […]

26 September 2013 3:52 pm by
Rodney Landrum

4 Future Inventions We Will Wonder How We Lived Without

0 comments

I have always wanted to be a Science Fiction writer. I am enthralled by the invention and imagination of writers such as Douglas Adams and Robert Heinlen. One day I will transmogrify my technical writing into something much more prosaic, and produce a novel of my own. Much like in my day job, as a […]

26 September 2013 2:51 pm by
David Atkinson

SQL Support for OSS Projects

0 comments

We recently blogged about two new open source websites, OSS Zero to Sixty and OSSPerks. Set up by Nik and Anthony, founders of Glimpse, they’re two sites dedicated to helping anyone looking for help, tips, resources and tooling for open source projects. Since then, we’ve heard about all sorts of exciting things the open source […]

25 September 2013 2:46 pm by
Laila Lotfi

Jeffrey Richter’s Tip for Faster ASP.NET Applications

0 comments

It’s been a while since I’ve last posted on my blog, but last week I realised that I have tons I still want to share with you. But I’m not much of a Facebook or Twitter fan (I struggle a little bit with ultra-short-form writing), so I guess I’d better go back to good old […]

23 September 2013 2:43 pm by
Melanie Townsend

TribalSQL – A First for Everyone

0 comments

TribalSQL is coming out in October – 15 first-time authors each wrote one chapter on what they thought you should know about databases. This is a community project by MidnightDBA and Red Gate who have both donated quite a chunk of time to the project, and all royalties are being donated to Computers4Africa. Jen McCown […]

19 September 2013 5:41 pm by
Fatherjack

SQL Server Policy Based Management – Creating a custom condition

0 comments

I have recently been looking at Policy Based Management with a view to using it to rapidly review servers in our domain to ensure they meet our configuration requirements. One of our tests is that every server login must only have a default database that meets the following criteria: The database must be online. The  […]

16 September 2013 8:00 am by
Phil Factor

Methodology Agnostic

15 comments

I once went for an interview at one of those software houses in the east end of London, serving the many financial institutions around the City. It wasn’t an easy interview. I’ve forgotten all of the questions except one. “Have you ever used the Waterfall Methodology?” “As I take my shoes from the shoemaker, and […]

12 September 2013 4:42 pm by
Fatherjack

SQL Relay 2013 R2 – your second chance to get some free SQL Server training

0 comments

SQL Relay has historically been an annual event but 2013 sees a break in this tradition with a second chance for anyone in the UK to get a complete day of free SQL Server training at a choice of venues from Newcastle to Southampton. Branded as SQL Relay 2013 R2 this is a completely new series […]

9 September 2013 10:00 am by
Older posts