Canvas Demos and Tutorials

A great demo of the canvas element Canvas Ajax Demo ?http://ajaxdraw.altervista.org/ Details on the use of the canvas element. Canvas Tutorial https://developer.mozilla.org/en/Canvas_tutorial/Using_images

SQL Injection Attack Demo

A SQL Injection Attack is one of the many security issues that must be address when designing and developing applications that access a database.  The injection vulnerability is potentially present on pages or forms where the user must enter a value to be submitted to the server. If the user input is not properly validated …

SQL Injection Attack Demo Read More »

Transact-SQL

SQL Formatting Trick

I learned a very useful T-SQL script formatting trick today. I often talk about formatting and commenting for the “person from mars” which is usually “you” coming back to look at your code 3 years from now having forgotten everything you ever knew about this project and learned better ways to do everything that was …

SQL Formatting Trick Read More »

What is SQL Server

If you are reading this post you have of course heard the term DataBase… Depending who you are and what you do for a living that term may or may not mean anything to you. If you are a DBA (DataBase Administrator) look away! This post is not for you. lol This post is intended …

What is SQL Server Read More »

SQL Server Bulk Updates and Locking

When doing a large update of a table in a SQL Server database you may gain some performance by locking at the Table level instead of allowing SQL Server to do Page or Row level locking. This can be accomplished using Table Hints. Table hints override the query optimizer default plan for the executed query. …

SQL Server Bulk Updates and Locking Read More »

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

This is an error that you get when you try to view the built-in reports in SQL Server 2008 when the database compatibility is set to anything less than 2005(90). To fix this and make the built-in reports work: Right click on the database Select properties On the options tab change the compatibility level to …

Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Read More »

Auto File Growth by Percentage of file size

In SQL 2000 and before setting auto file growth to a percentage meant that the file would grow by 10% of the initial file size (regardless of how large the file had grown since its creation). In SQL 2005 and later the growth by percentage setting is based on the “current” file size and not …

Auto File Growth by Percentage of file size Read More »

Fix for SharePoint Search error: The search service is currently offline

psconfig -cmd upgrade -inplace b2b -wait Fix is in the comments by “maxmorgan” on the link below http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2009/02/24/the-search-service-is-currently-offline-visit-the-services-on-server-page-in-sharepoint-central-administration-to-verify-whether-the-service-is-enabled-this-might-also-be-because-an-indexer-move-is-in-progress.aspx

Shopping Cart