help.net


Musing on .Net

News

Windows Phone Apps I recommend

FotoBank


FotoIreland



hit counters






Open source CMS


My blog

Irish blogs

Locations of visitors to this page Get Chitika eMiniMalls

.Net useful

Blogs I read

PocketPC

SQL

Usability

Browse by Tags

All Tags » SQL Server (RSS)
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. Read...
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. Read more...
Posted: Nov 22 2007, 12:36 PM by help.net | with 2 comment(s)
Filed under:
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! Read more...
Posted: Aug 22 2007, 02:58 PM by help.net | with 2 comment(s)
Filed under:
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. But for the typical daily maintenance nothing has been improved over SQL 2005. I still hate SQL Studio and nothing in this CTP has changed...
Posted: Jun 05 2007, 05:07 PM by help.net | with 8 comment(s)
Filed under:
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...
Posted: May 27 2007, 11:06 PM by help.net | with 1 comment(s)
Filed under:
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...
Posted: May 22 2007, 10:43 PM by help.net
Filed under:
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. However, SQL Management Studio is the worst piece of management code I ever used...
Posted: Apr 24 2007, 02:48 PM by help.net | with 6 comment(s)
Filed under:
Transferring data using SqlBulkCopy Class
Introduction : Transferring data from one source to another is a common practice in software development. This operation is preformed in many different scenarios which includes migration of the old system to the new system, backing up the data and collecting...
Posted: Mar 28 2007, 03:43 PM by help.net | with 1 comment(s)
Filed under: ,
Best practice when optimizing indexes on SQL Server 2005
Stefano Demiliani give here some good advice on SQL Server 2005 index optimisation. Read more...
Posted: Feb 20 2007, 01:11 AM by help.net | with 2 comment(s)
Filed under:
Sync for SQL Server
A bit pricey but another interestting good tool for SQL 2000 and 2005. Sync For SQLServer is designed for software developers or database administrators who are working with the Microsoft SQL Server database. It compares two SQL Server databases and determines...
Posted: Feb 01 2007, 09:35 AM by help.net | with 1 comment(s)
Filed under:
More Posts Next page »