Click here to monitor SSC


Ben Emmett

Setting up Windows 10 IoT Core on Raspberry Pi from a VM


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

3 May 2015 2:46 pm by
Dennes Torres

Why you should always use schema name in queries


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

30 April 2015 2:22 am by
Tony Davis

Taming Transaction Logzilla


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


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


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


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


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


  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


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


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
Older posts