Click here to monitor SSC

Blogs


Tony Davis

Taming Transaction Logzilla

0 comments

A transaction log, if sized sensibly, is like a ring buffer. It will stay the same size however much data it holds, up to a point. It is when something goes wrong that the log can turn into a disk-space-devouring monster, and my heart sinks whenever I stumble across a forum or Q&A post advocating […]

24 April 2015 10:19 am by
Simple-Talk Editorial Team

Caption Competition 27 – Well, would you look at that

6 comments

Tinker, teacher, presenter, host? Who is this man and what is he pointing to? Caption this scene in the comments, the best one will win a $50 Amazon vouchers.

23 April 2015 2:26 pm by
Damon Armstrong

High Trust Certificate Error Adding App to Site in SharePoint

0 comments

I was deploying a SharePoint App-Model app in my development environment.  It went into the catalog just fine, but it failed when trying to add it to a SharePoint site.  It uses a remote web and has application install event receivers.  The helpful error message that came back just said that the event receivers failed […]

22 April 2015 1:33 pm by
Dennes Torres

Looking for outdated statistics

0 comments

Outdated statistics are a major cause of bad query plans in SQL Server’s. Even when we have ‘Auto Update Statistics’ on, this doesn’t solve the problem, because the formula for the number of modifications that triggers the ‘Auto Update Statistics’ is 20% + 500. If your table has 3 million rows you will need to […]

20 April 2015 3:08 am by
Louis Davidson

What Counts for a DBA – Responsibility

3 comments

Whose fault is it if a database is hacked and its contents appear on a hacker’s site? Sure, the hacker is the criminal, but could you, the DBA, have prevented the crime happening to your servers?  In the end, the odium that follows a data breach descends on the company who is storing the data, […]

16 April 2015 1:40 am by
Dennes Torres

How to query Included columns and more index metadata

0 comments

  I’m from the age when sp_help and it’s variants could give to us almost any information about the database objects. Today the server evolved, we have a lot of powerful DMVs to get all the information we would like. The sp_help procs are still there but sometimes they can’t give to us even some […]

13 April 2015 2:55 am by
Simple-Talk Editorial Team

Caption Competition 26 – They Promised Me A Jetpack

16 comments

In this breathless rush towards the future, there are bound to be a few mistakes along the way. This certainly looks to be one of them. Funniest caption for this scenario wins a $50 Amazon voucher.

9 April 2015 5:23 pm by
Phil Factor

The Database Neighbours From Hell

5 comments

In the Windows environment, there seems little safer for application design than a rather staid single-tiered architecture making ODBC/JDBC calls to the RDBMS. I can say this with years of experience in developing applications ranging from the dull but worthy, to the esoteric. However there is an interesting long-term cost to taking the easy route […]

9 April 2015 5:16 pm by
Rodney Landrum

From C to Shining C – My Son’s Journey

2 comments

My oldest son is turning 22 this week, on Wednesday.  I asked him what he wanted for his birthday and he said all he wanted was for me to sponsor his journey, Walk Across the World. He asked me to go check out the site he was putting together and what he plans to do […]

6 April 2015 10:49 pm by
Simple-Talk Editorial Team

Caption Competition 25 – Held for Inspection

19 comments

What wondrous magic is this? Something very small, or is he very large? Caption the scene with an ingenious quip in the comments and be in with the chance to win a $50 Amazon voucher.

26 March 2015 3:22 pm by
Older posts