Thursday, May 19, 2011

A nice free addon for SQL management studio, SQL Search 1.0

SQL Server developers and DBAs use SQL Search to:

  • Find fragments of SQL text within stored procedures, functions, views and more
  • Quickly navigate to objects wherever they happen to be on a server
  • Find all references to an object

How to show time cost for one query in T-SQL?

      DECLARE @starttime DATETIME2 = SYSDATETIME(), @alltime datetime2 = sysdatetime();
      DECLARE @finishtime INT;

/* Your query is in here */

      SELECT @finishtime = DATEDIFF(millisecond, @starttime, SYSDATETIME());
      PRINT '(ms): ' + CONVERT(VARCHAR, @finishtime)

What do programmers really do?

What do programmers really do?
Programmers are translators of human ideas into the language of computers.

Securing your ASP.NET MVC 3 Application

You cannot use routing or web.config files to secure your MVC application. The only supported way to secure your MVC application is to apply the [Authorize] attribute to each controller and action method (except for the login/register methods). Making security decisions based on the current area is a Very Bad Thing and will open your application to vulnerabilities