Simple Talk Editorial Team Caption Competition 30 – Hang Time These two certainly look like fast chums! But what’s going on? It’s up to you to tell us in the... 04 June 2015 1 min read
Tony Davis Test Driving Your Database In any engineering project, you can’t avoid testing your product against reality. A friend who once worked at a car... 04 June 2015 3 min read
Ben Emmett Beta support for ASP.NET 5 DNX projects in ANTS profilers This post was about beta releases of ANTS Performance Profiler 9.2 and ANTS Memory Profiler 8.7. You should ignore it,... 04 June 2015 2 min read
Dennes Torres Send SQL Server query results to Excel through email Dennes Torres explains how to send SQL Server query results to Excel. It seems easy, but there is a catch!… 01 June 2015 3 min read
Phil Factor UWP: The Platform Formerly Known as Metro Three years ago, I listened to a keynote at a developer conference. The man from Microsoft beamed confidently at the... 21 May 2015 3 min read
Simple Talk Editorial Team Caption Competition 29 – Ladies of the Lake What a beautiful idyll! What a beautiful crossbow! What a lovely day for a caption competition. The funniest comment left... 21 May 2015 1 min read
Dennes Torres Using Optimize for ad-hoc workloads SQL Server caches the executio plan of our queries, not only stored procedures, but also ad hoc queries. However, when... 10 May 2015 3 min read
Louis Davidson Classic Music, Attractions, and Presentations: Presenting on Database Design at SQL Saturday Atlanta 2015 This next two weeks are going to be awesome. May 11, I get to see the Who for probably the... 08 May 2015 3 min read
Jason Crease The Brian Keller VM – Try out Microsoft’s ALM stack easily Why do I need this? Microsoft sells a range of tools to support a project from ideation to release and... 08 May 2015 4 min read
Tony Davis The Art of the Author When tidying out an old cupboard a few weeks ago, one after another I casually tossed outdated, dusty technical books... 07 May 2015 3 min read
Simple Talk Editorial Team Caption Competition 28 – The Eyes Have It A strange glimpse of a dark, ovoid future? A warning from the past? You decide! Best caption wins a $50... 07 May 2015 1 min read
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... 03 May 2015 3 min read
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... 30 April 2015 3 min read
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... 24 April 2015 3 min read
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,... 23 April 2015 1 min read
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... 22 April 2015 2 min read
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’... 20 April 2015 3 min read
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... 16 April 2015 3 min read
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.... 13 April 2015 4 min read
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... 09 April 2015 1 min read
