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

Advice I Like: Rewards from Work

By

The greatest rewards come from working on something that nobody has words for. If...

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

By

Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...

Why your data still can’t answer a simple question 

By

Every organization I talk to has the same problem dressed up in different clothes....

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

Comments posted to this topic are about the item The day-to-day pressures of a...

Analysis Services Model w/ Direct Query and (Default Veritpaq)

By Archivist

Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...

Don't Panic

By Grant Fritchey

Comments posted to this topic are about the item Don't Panic

Visit the forum

Question of the Day

Identities and Sequences IV

When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?

See possible answers