Top 20 worst performing queries --------------------------------- and thus you would see "similar" query text in the proc cache each with its separate compiled plans */ DECLARE @SQLString nvarchar(500)…
Read more →
Let us say you added a new user (called newuser) – and want to grant her access to your subfolder myproject/sourceYou would modify the Authz file – by…
Read more →
Publishing an asp.net website gives the following error.: The directory ‘/App_GlobalResources/’ is not allowed because the application is precompiled. All you need to do, if your site is…
Read more →
There isn’t a sports coach who doesn’t repeat these lines multiple times every day: Keep your eye on the ball This is true of any sport in which…
Read more →
These scripts are owned and developed by Ola Hallengren DatabaseBackup: SQL Server Backup DatabaseIntegrityCheck: SQL Server Integrity Check IndexOptimize: SQL Server Index and Statistics Maintenance Download Maintainance…
Read more →
T-Mobile – I never gave them much thought – until they came up with this cool Shakira world cup commercial. I might change my phone plan just because…
Read more →
To only view the conflicts (conflicting files) for pending checkins in TFS 2013, try the following: View TFS Conflicts Only Go to Team Explorer Select Pending changes In…
Read more →
The [Authorize] attribute kept throwing a ‘login’ popup even though the user was logged in via windows authentication.The problem is that the [Authorize] attribute uses the following line…
Read more →
LINQPad, the most popular LINQ tool out there , does not convert SQL statements into their equivalent LINQ syntax. However, a free tool called Linqer does just that.…
Read more →
For each page, on the ‘edit page’ page in the dashboard, click the ‘screen options’ near the top right. Check the ‘discussion’ box there; scroll down to below…
Read more →