Click here to monitor SSC


Ben Emmett

Redgate’s support for Visual Studio 2015


Microsoft have now publicly announced that they will release Visual Studio 2015 (along with .NET 4.6 and TFS 2015) on July 20th. Redgate is a SimShip partner for the launch, and has already completed most of the work to provide full support for Visual Studio 2015 in all our tools. We’re really excited about all […]

30 June 2015 10:33 am by
James Duffy

Locking objects in SQL Source Control


If you share a database with other developers, chances are you’ve encountered a situation like this: 1. Alice starts editing an object. 2. Meanwhile, not realizing Alice is working on the object, Bob unwittingly edits and saves the same object. 3. Alice, not realizing Bob was working on the same thing, saves her changes. Presto: […]

29 June 2015 3:10 pm by
Dennes Torres

How to use ObjectProperty to locate problems in tables


There are plenty of very useful object properties that can help us to find problems in our databases. We can use object properties to find tables without primary key, tables without clustered index and much more information. Object properties simplifies our queries, without them we would need to do much more complex queries over DMV’s […]

22 June 2015 4:14 am by
Tony Davis

We Don’t Need Any More Heroes


Where do I start? It’s a question each of us asks when faced with any learning goal, whether it’s how to play ‘Stairway to Heaven’ on a guitar, or how to deploy a database. The answer, as any teacher will tell you, is to work out where you are now, in terms of skills and […]

17 June 2015 10:27 am by
Simple-Talk Editorial Team

Caption Competition 31 – The Amazing-ish Race


These olde-timey vehicles wait for nothing – except your comments. Tell us what’s going on here – as ever, the one that tickles our collective funny bone just so will win a $50 Amazon voucher.

17 June 2015 10:16 am by
Damon Armstrong

Incorrect Client ID in SharePoint App Package


Interesting issue today.  I was attempting to install a SharePoint app today and ran into the following error: 8fff7a1f-f0ea-4d73-8c7d-aa97279b6d20 Stack trace:   at Microsoft.SharePoint.SPUser.get_UserToken()    at Microsoft.SharePoint.Lifecycle.SPAppLifecycleEventCalloutTask.CallRemoteEventReceiver(Uri url, SPAppInstance instance)    at Microsoft.SharePoint.Lifecycle.SPAppLifecycleEventCalloutTask.CallRemoteEventReceiver(SPAppInstance instance)    at Microsoft.SharePoint.Lifecycle.SPAppLifecycleEventCalloutTask.Deploy()    at Microsoft.SharePoint.Administration.SPAppTask.DeployOperation()    at Microsoft.SharePoint.Lifecycle.MonitoredTaskExecution.DoTask()    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)    […]

16 June 2015 3:20 am by
Melanie Townsend

Change Scripts Research


How do you use change scripts for your database deployments?  This is the question Redgate’s SQL Source Control team is trying to answer. They’re conducting research to understand not only SQL Source Control users, but anyone who uses change scripts for database deployment so they can make the best improvements to their product as possible. […]

15 June 2015 1:21 pm by
Rodney Landrum

A Very Quick Post on SQL Server 2016 Dynamic Data Masking


*** Update – Just wanted to say that dynamic data masking has the potential of being a great feature and one I have been wanting for years. That point did not come across in the expediency of writing this post. **** I have a mere 5 minutes before I shutdown and deallocate my SQL Server 2016 […]

10 June 2015 7:18 pm by
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 comments below and, as ever, the funniest entry wins a $50 Amazon voucher.

4 June 2015 2:43 pm by
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 design center told me that throughout each development cycle, in adding to a component-testing program with test-rigs and simulations, they would drive each newly-designed automobile down “Dunmore Lane”. This local road was infamous for its […]

4 June 2015 2:39 pm by
Older posts