dbareactions: When I turn on RCSI and the developers’ locking problems go away overnight

dbareactions:

When I turn on RCSI and the developers’ locking problems go away overnight

(Reblogged from dbareactions)
decodering: Ladda A UI concept which merges loading indicators into the action that invoked them. Primarily intended for use with forms where it gives users immediate feedback upon submit rather than leaving them wondering while the browser does its thing. For a real-world example, check out any of the forms on slid.es.

decodering:

Ladda

A UI concept which merges loading indicators into the action that invoked them. Primarily intended for use with forms where it gives users immediate feedback upon submit rather than leaving them wondering while the browser does its thing. For a real-world example, check out any of the forms on slid.es.

(Reblogged from decodering)
dbareactions: When the security consultant demoed SQL injection against our production web site

dbareactions:

When the security consultant demoed SQL injection against our production web site

(Reblogged from dbareactions)

.net website in iis7 not rendering correctly on one server but is fine on another

Ran into a strange one today when pushing a .net 4.0 web forms app out to iis7 on two different servers. On one server was working fine on the other however the pages were not properly rendering, and not all of the scriptresource.axd files were getting loaded up. Also errors were popping up in IE dev tools console similar to this:

SCRIPT5009: ‘WebForm_GetElementByTagName’ is undefined

Turns out according to this post by Scott Hanselman that there is a bug in the browser definition files that shipped with .NET 2.0 and .NET 4, namely that they contain definitions for a certain range of browser versions. This causes an issue with postbacks.

After installing the hotfix all problems were gone. I am guessing I installed an older release of the .net 4.0 framework on the machine I was having the issues with b/c this issue was supposed to be addressed in the Jan 2012 update… 

Here is the stackoverflow question and answer as well.

http://stackoverflow.com/questions/16839986/net-website-in-iis7-not-rendering-correctly-on-one-server-but-is-fine-on-anothe/16843055#16843055

dbareactions: When I find multiple stored procedures in the same database where the only difference between them is the order by clause. (HT @SQLprincess)

dbareactions:

When I find multiple stored procedures in the same database where the only difference between them is the order by clause. (HT @SQLprincess)

(Reblogged from dbareactions)

Coding Horror: A Visual Explanation of SQL Joins

thedailydev:

I think I might like this one even better than the purely graphical one, because it also has examples of the result tables generated by each query.

(Reblogged from thedailydev)

The Tech Notes: Moving TempDB files in SQL Server

thetechnotes:

To check what the existing TempDB files look like use this command:

USE tempdb

GO

EXEC sp_helpfile

GO

Once you know the file names you can use this command to move them:

USE master

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = ‘C:\SQLTempDB\tempdb.mdf’)

GO

ALTER…

(Reblogged from thetechnotes)

How to decode HTML characters in C# http://stackoverflow.com/questions/122641/how-can-i-decode-html-characters-in-c

CLIP: MyBucketz Aggregates And Categorizes Your Social Media And RSS Feeds

allisonstadd:

MediaBistro, 5/8/13

(Reblogged from allisonstadd)

Find your next job using mybucketz…

mybucketz:

You can now find jobs on mybucketz once you connect your LinkedIn account…just enter the job title (ex. accountant, software developer, etc..) on the “Feeds” screen in the “Search For” text box and select your LinkedIn connection. This will bring back the top 20 jobs relevant in your area and lets you go directly to the job posting on LinkedIn for more info if needed….

Check it out…

http://www.mybucketz.com/

(Reblogged from mybucketz)