Contents tagged with SQL Server
-
Evolutility lightweight framework for heavy lifting
Evolutility is a generic web UI for database applications. With it you can build CRUD (Create, Read, Update, Delete) web applications simply by providing the metadata describing your application UI and database mapping. No hand-coding is required.
-
Free SQL Server tools that might make your life a little easier
This is really great, finally a place to list all the free SQL tools exisitng around.
-
SQL Agent: A Job Scheduler Framework
An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service.Back up your SQL Server Express and much more! -
SQL 2008 CTP is here but it's not really exciting
OK sure this is good news for playing around with the future SQL 2008. Some stuff are going in the right direction.
-
Top 15 free SQL Injection Scanners
While the adoption of web applications for conducting online business has enabled companies to connect seamlessly with their customers, it has also exposed a number of security concerns stemming from improper coding. Vulnerabilities in web applications allow hackers to gain direct and public access to sensitive information (e.g. personal data, login credentials).
-
SQL Server 2005 Paging Results
With SQL Server 2005 it is now a lot easier to use paged queries than in previous versions. I will be using NorthWind db (mostly) so you can also use the examples I have provided. I will keep the examples simple; anything complex will only cause confusion. I will start with "traditional" methods such as
SELECT
,TOP
, and then move onto the specific SQL Server 2005 paging examples. -
Mr Microsoft can you fix SQL Studio please!
I want to start but saying I don't want to sound too negative about SQL 2005, because the core features of this version are performing very well compare to SQL 2000.
-
Transferring data using SqlBulkCopy Class
Introduction:
-
Best practice when optimizing indexes on SQL Server 2005
Stefano Demiliani give here some good advice on SQL Server 2005 index optimisation.
-
Sync for SQL Server
A bit pricey but another interestting good tool for SQL 2000 and 2005.