Technical Article

Automatic Deployment of Scripts from your Frontend

Bundle SQL Deploy when you distribute a new version of your application to clients and all your database changes will happen automatically. Simply save database changes from Enterprise Manager, SQL Analyser or Visual Studio .NET as scripts (as most developers already do) and this utility enables automatic data version upgrades. Designed for Winforms, Webforms, VB, ASP and Access applications (and more), SSW SQL Deploy means you never have to worry when deploying applications again!

SQLServerCentral Article

Is Windows 2003 Really Faster?

Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.

Technical Article

IMP Index Manager

Integrate high performance index- and search functionality in your SQL database.
Essentially, IMP Index Manager is a set of tools (search engine, administrative interface, etc.) to make it very easy to add search engine capabilities to SQL Server 2000. Easy to implement, and lightening fast performance. (Not Reviewed)

Technical Article

Murach's VB.NET Database Programming with ADO.NET

If you're a VB.NET programmer who wants to learn database programming with ADO.NET, here's a new book that presents all the skills you need in a logical progression from the simple to the complex. Along the way, you'll learn how to use the classes, properties, methods, events, and techniques that have made this subject so hard to master. And when you're done, you'll have a reference that you'll use on the job every day. (Publisher Provided Description, not reviewed)

Technical Article

Customers Don't Know What They Want

This article on the JoelonSoftware site discusses project management and customer expectations. It has a great discussion of why non-technical users place so much value on what they can see (the GUI) while developers place so much value in what can't be seen (yeah, the code!). It's actually more interesting than that, take a look!

Blogs

The Book of Redgate: No Politics

By

In today’s world, this might mean something different, but in 2010, we had this...

The Burrito Bot: AI-Powered Search in SQL Server 2025

By

A while back I posted about a couple of side projects that I’ve been...

SQL Server Journey (Part 1)- Enterprise Database 2016

By

Continued thinking about my Journey blog where we have to look back at the...

Read the latest Blogs

Forums

Identities and Sequences II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identities and Sequences II

Using PostgreSQL as a NoSQL Store and a Search Engine

By sabyda

Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...

Is Your Time "Free"?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Your Time "Free"?

Visit the forum

Question of the Day

Identities and Sequences II

In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?

See possible answers