2005-07-28
1,878 reads
2005-07-28
1,878 reads
2005-07-15
1,738 reads
2005-07-07
1,856 reads
One of the most useful tasks in SQL Server 2000's DTS environment is the Dynamic Properties task. Author Kathi Kellenberger brings us a look at how this task can help you accomplish an unusal import task.
2005-06-20
14,689 reads
One of the lesser used features of SQL Server 2000, but the capability to restore your databases to a particular point in time can be a valuable skill. Kathi Kellenberger takes a moment to explain how this feature works and how you can use it in your environment.
2005-06-14
17,823 reads
Searching data is an essential part of SQL Server applications, especially text searching. While Full Text Search in SQL Server 2000 works, it lacks some important features that Turbo for SQL Server can handle. Read this review of the product and see if this is a way you can enhance the search functions in your application.
2005-06-01
7,455 reads
SQL Server 2000 has a rock solid backup process and one that many people have relied upon for years. However with the growth in database sizes and the constant load on many database servers, a third party backup utility is almost required in many environments. Kathi Kellenberger takes a look at Red-Gate Software's SQL Backup 3.0 and how it performs in her environment.
2005-04-27
12,397 reads
One of the strengths and powers of the SQL Server platform over others is the shear number of things that are available free from Microsoft besides the relational platform. DTS, Reporting Services, SQLAgent, and more are included with the product. One of the newer utilities is SQLH2, a performance monitoring tool that is reviewed here by Kathi Kellenberger.
2005-03-28
18,574 reads
SQL Server 2000 and Access databases are two technologies closely linked with the new Access ADP format using SQL Server as the basis for the code. Access Projects are also a way to closely link the two products together and take advantage of each to produce an application very easily. Author Kathi Kellenberger brings us part 3 of her Access series with a look at Access Projects.
2005-02-24
10,022 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item I Love Editorials
Hi everyone I have a 1000 plus line query and I am getting an...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers