Friday, May 20, 2011
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
http://www.red-gate.com/products/sql-development/sql-search/
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.
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
http://blogs.msdn.com/b/rickandy/archive/2011/05/02/securing-your-asp-net-mvc-3-application.aspx
http://blogs.msdn.com/b/rickandy/archive/2011/05/02/securing-your-asp-net-mvc-3-application.aspx
Subscribe to:
Posts (Atom)