Deploying Databases From Visual Studio Team System Database Edition
With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.
2009-06-24
5,311 reads
Deployment Process
Fast Project Rollbacks
When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.
2008-10-22
3,940 reads
Virtualization for Database Development
The trials and tribulations of our first attempt using Virtual Servers
2008-04-08
7,510 reads
RE: Replication - Adding new objects
I see options for "No", "Yes" and "Yes (Not For Replication)". The "Yes" is used.Randy
2005-04-08
RE: DTS: Export to Excel: "Spreadsheet Full"
The maximum worksheet size in Excel is 65,536 rows by 256 columns, so it sounds like you have hit that limit. However, you can of course have multiple worksheets within a workbook. This is a hell of a lot of data for a spreadsheet to handle. Perhaps the time has come to consider a database […]
2004-11-08
2004-11-04
Backup rights and privelege
I'm planning to delegate some of my admin work to my colleague like the maintenance of the backup. I've already made his user a member of db_backupoperator role within the database he will be maintaining, and made him also the role as the db_owner of the msdb database. My problem was when I test his […]
2004-10-31
1 reads
RE: SQLH2 Performance Collector
The performance collector needs to run under a profile setup for US dates. "28/10/2004 10:03:49 Status: Perf records loaded: 0" This line indicates that no records were loaded, that would be why you can't find any Have you opened the file itself and checked the contents?
2004-10-31
2004-08-04
User account question/error
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-06-21
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers