SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.
2006-07-17
2,156 reads
This is the second of a two-part article that explores the language features of SQL Full-text Search (SQL FTS), an component of SQL Server 7 and above that allows fast and efficient querying of large amounts of unstructured textual data. Part I dealt with index time language options, covering how words or tokens are broken from the text stream emitted from the iFilters and stored in the index.
2006-07-14
2,945 reads
In Part I and Part II of this series, we saw how to install the SQL Server 2005 Data Service component. In this section of this series, I am going to illustrate how to install SQL Server 2005 Database Services and SQL Server Analysis Services on a host machine using an .ini file.
2006-07-13
1,880 reads
2006-07-12 (first published: 2004-02-26)
376 reads
In this section of this series, I am going to illustrate how to install SQL Server 2000 Database Services on a server using various command line switches.
2006-07-12
1,946 reads
n SQL Server 2005, XML becomes a first-class data type. Developers can make minor remote modifications to stored XML documents easily, taking advantage of new support for XML schema-based strong typing, and server-based XML data validation.
2006-07-10
3,010 reads
This article will continue where the last one left off. We will import MOM 2005 Management Packs and Reports and begin monitoring SQL Server 2005.
2006-07-07
1,668 reads
SQL Server Integration Services checkpoints enable you to start a package from where it failed. This helps you avoid having to re-run a 6 hour package over again. Learn how to use this valuable feature with this quick how-to video. Free registration required.
2006-07-07
1,285 reads
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
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers