Click here to monitor SSC

2014 June

Rodney Landrum

How Losing Weight Caused Me to Lose My MS Surface RT in Vegas


My wife and I had just spent 3 terrifically hot days driving through the desert from Las Vegas to LA and San Diego. It was a couple of weeks ago today. I live in Florida and have to say I have not seen 109 degrees F (42.7778 C) in a very long time. I saw […]

29 June 2014 7:40 pm by

You go to the effort of writing a blog and then …


It’s hard work, some find it harder than others, but there are plenty of people making an effort to write down and publish content they want to share. Why then do some of those people having gone to the effort of creating the content fall at the last hurdle when presenting it online? I have […]

28 June 2014 9:44 am by
Simple-Talk Editorial Team

Caption Competition the Fifth


Update: Congratulations to Fatherjack who won this competition on July 7 with his caption “Little known fact: the ‘S’ in SQL used to stand for Semaphore.” Once again, we call upon our readers to amuse and enlighten us by providing funny captions to peculiar pictures. This week: When Trevor put his headphones on, he wanted […]

20 June 2014 11:56 am by
Ben Rees

Continuous Delivery for Databases – a Pipe Dream?


“I’m a DBA for a large healthcare firm here in the US. You’d have to put a gun to my head before I let my developers run automatic database deployments through to production without me checking the release first“. I had just explained our ideas for running continuous integration, automated testing and automated release processes […]

19 June 2014 7:39 am by
Daniel Rothig

New tools for SSDT and Database Projects: call for research participants


Deep in the dank underground laboratories of Red Gate Towers, ancient softwaremancers bend over the cauldron, pointy hats askew. Mixing three cloves of engineering, a spoonful of market insight, a generous helping of ingenious simplicity, and just a dash of cinnamon, new and exciting software comes to be. What will our next creation be? Our […]

18 June 2014 3:03 pm by

Checking if your SIMPLE databases need a log backup


Hopefully you have read the blog by William Durkin explaining why your SIMPLE databases need a log backup in some cases. There is a SQL Server bug that means in some cases databases are marked as being in SIMPLE RECOVERY but have a log wait type that shows they are not properly configured. Please read his […]

10 June 2014 10:43 am by
Tom Crossman

New features in SQL Prompt 6.4

1 comment

We’re pleased to announce a new beta version of SQL Prompt. We’ve been trying out a few new core technologies, and used them to add features and bug fixes suggested by users on the SQL Prompt forum and suggestions forum. You can download the SQL Prompt 6.4 beta here (zip file). Let us know what you think! New features Execute […]

6 June 2014 1:59 pm by
Simple-Talk Editorial Team

Caption Competition 4: Fist Full of Captions


Update: Congrats to rananjali who won with this week’s competition with a caption on migrations. Thanks to everyone who wrote in! Once again we ask: What’s going on here? The best caption wins a $50 Amazon voucher. Computer-y answers for preference, but don’t let a lack of electronics stop you from dazzling us with your bon […]

6 June 2014 1:12 pm by
Tony Davis

We have our standards, and we need them


The presenter suddenly broke off. He was midway through his section on how to apply to the relational database the Continuous Delivery techniques that allowed for rapid-fire rounds of development and refactoring, while always retaining a “production-ready” state. He sighed deeply and then launched into an astonishing diatribe against Database Administrators, much of his frustration […]

6 June 2014 9:29 am by
Phil Factor

Developing a SQL Server Function in a Test-Harness.


/* Many times, it is a lot quicker to take some pain up-front and make a proper development/test harness for a routine (function or procedure) rather than think ‘I’m feeling lucky today!’. Then, you keep code and harness together from then on. Every time you run the build script, it runs the test harness too.  […]

4 June 2014 5:51 pm by
Older posts

Blog archive