Automating installations with SQL Server 2000 is easy because it creates a setup.iss file that you can use as input, but Microsoft removed this feature from SQL Server 2005. Learn an undocumented SQL Server 2005 feature that provides similar functionality to setup.iss.
2006-07-06
1,777 reads
Software developers constantly need to learn about new technologies, products and methodologies. Think about what sort of programming you were doing 5 or 10 years ago. If you have been developing software that long, you will, no doubt, be working on very different systems now than you were then.
2006-07-05
2,472 reads
This article adds some handy reporting capabilities to the new load testing tool in Visual Studio 2005 Team System.
2006-07-04
1,459 reads
Enter to win a Ms Pacman/Galaga arcade machine when you download and register a free version of Microsoft Visual Studio Express Editions (free learning resources included).
2006-07-03
1,647 reads
The benefits and drawbacks of GUIDs as primary keys are generally known. Despite the drawbacks, some people use them to fulfill specific business requirements (the IDs are unique across multiple servers).
2006-06-30
2,858 reads
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.
2006-06-29
3,858 reads
Use Linked Reports to provide multiple "versions" of a single source report, as a mechanism for restricting consumer groups to their respective data in accordance with a "need to know."
2006-06-28
2,200 reads
If I had a penny for every person who said "usability is just common sense", I'd have a pretty reasonable stack of pennies – maybe 30 or so. Clearly I'm not going to be able to retire on this, but at least it demonstrates that many people have misconceptions about how usable interfaces are designed.
2006-06-27
2,601 reads
This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb
2006-06-26
3,001 reads
The latest GotW award goes to Glenn Johnson, .NET trainer and author of Programming Microsoft ADO.NET Applications:
2006-06-23
3,168 reads
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers