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 […]
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.
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 […]
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 […]
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, […]
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 […]
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.
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 […]
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 […]