Click here to monitor SSC


Dennes Torres

Identify Object Name from Page ID


Sometimes, while searching the root cause of database problems, we face page IDs and need to find to which object that page belongs. We can find this information using DBCC Page, but it’s a manual procedure, we need to execute this command and look the text result to find the object id. This would be […]

6 July 2015 7:49 am by
Tony Davis

The Railmap Towards Easier Query Tuning?


Recently, I’ve been getting more and more engrossed in SQL Server Execution plans for various reasons, including editing the forthcoming third edition of Grant Fritchey’s book. There are certain infographics that ‘speak’ to everyone. They represent highly complex concepts clearly and unequivocally. Unfortunately, the SQL Server graphical execution plan is not one of them. I […]

3 July 2015 9:52 am by
Simple-Talk Editorial Team

Caption Competition 32 – A Moment Of Levity


We all feel groundless sometimes, but this fellow more than most. What caused his current woes? The funniest answer wins a $50 Amazon voucher.

3 July 2015 9:50 am by
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
Older posts