Click here to monitor SSC

2013 September

Phil Factor

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


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#


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


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


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


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


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


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

SQL Server Policy Based Management – Creating a custom condition


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


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

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


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

Blog archive