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
Performance tuning often seems like it can be more of an art than a science. However there are a number of fundamentals that can help you tune most of the queries that you will write or have issues with their performance. Don Peterson brings us a look at how he tuned a query in the real world to avoid a conversion that can cause a query to run slower.
2006-07-13
11,872 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
Reporting Services has proven itself to be an amazing platform on which to develop all types of reports. Author Asif Sayed brings us some .NET code for using Reporting Services to return data recursively in a report.
2006-07-12
14,689 reads
In this video demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube. Free registration required.
2006-07-12
1,597 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
Our first SSIS class in July is sold out, but we've got another in August and one in October as well.
2006-07-11
5,062 reads
How much time do you spend developing your career? Are you actively looking to improve your professional skills? Andy Warren takes a look at how you can focus yourself and a few ideas for your employer as well.
2006-07-11
7,191 reads
In this quick video, Brian shows how to use SSIS to make a simple transformation occur of your data. He aggregates and sorts the data before writing the data to a flat file. After you watch this video, you will know how to use the Data Flow task inside of SQL Server 2005 SSIS. Free registration required.
2006-07-11
1,669 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
hi , a new user wants to be able to add sql agent jobs...
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers