Following Build last week, I wanted to try running Universal Apps on a Raspberry Pi 2, but the setup instructions mention having to provision the SD card from a physical Windows 10 machine. It must be physical because the OS needs raw access to the SD card, and only Windows 10 is able to flash […]
There is a very important reason to always use the schema name in the queries. For example, the following sintax can be a problem: select * from customers The solution is to use the schema name in the query: select * from dbo.customers The reason is simple: SQL Server does cache the query plan for […]
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 […]