Migrating data from one SQL Server database to another can be challenging. Steve Jones has a new series that looks at various techniques that he's used to move data into a new database. This one looks at how you can quickly take Excel based data and insert it into a new database without using DTS.
2004-07-08
10,537 reads
Setting up SQL Server server-side traces is not the easiest task in the world. Quantum Software Research has built a product that is an MMC add-in to manage these traces. Author Dale Corey takes a look at this product and how well it works with SQL Server 2000.
2004-07-07
9,837 reads
Dark Horse CRM is an enterprise-class Customer Relationship Management application that allows companies to better develop and maintain customers. Visit www.darkhorsecrm.com for more information and to download the free version of Dark Horse CRM that runs on Java, Apache Tomcat, and MSSQL or PostgreSQL.
2004-07-07
3,877 reads
SQL Server Express 2005 is a new product that has been released (in Beta) as a followon to the MSDE product. A number of new features as well as complementary products for all of the .NET development tools are now available. Read on for a quick summary of what this new product line is all about.
2004-07-02
14,199 reads
Using sysforeignkeys to discover SQL Server circular relationships. Have you ever tried this? Most of us probably haven't, but Jeffrey Yao often needs to reverse engineer databases for his clients. Here's a followup to his first article where he presents another of his techniques for doing a little detective work in your databases.
2004-06-30
7,113 reads
SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan.
2004-06-29
19,335 reads
SQL Server has an abundance of third party tools, more being developed everyday. Indepth for SQL Server allows you to monitor the performance and activity on your SQL Server. New author Hiram Khakharia looks at this product from Veritas.
2004-06-25
5,022 reads
A key service pack has now been released for Microsoft SQL Server Reporting Services. This one adds key enhancements and fixes many bugs.
2004-06-25
1,937 reads
The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype.
2004-06-24
14,024 reads
How many of you dig into Windows XP extensively? Working with hardware and the OS isn't something that many DBAs deal with these days. Most companies have an admin to work on servers, hardware, workstations, etc. But sometimes you need to help yourself out. Steve Jones had to work to get his laptop back after an XP disaster. Read on and hopefully this will help you one day recover your system.
2004-06-23
5,904 reads
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
i have sqlexpress on rds, is there any way i can get notifacation that...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers