DBEzze is a freeware product that can look into a database and generate XML structural or data output. It can also generate INSERT statements from a table, view or stored procedure. This freeware product is available for download from SQLServerCentral.com members only.
2002-03-06
105 reads
Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers.
2004-12-31 (first published: 2002-03-05)
40,190 reads
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
2002-03-04
11,081 reads
So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.
2004-12-23 (first published: 2002-02-21)
39,333 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,406 reads
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
2002-02-18
9,897 reads
One of our readers needed some help with altering a table with DMO, so Andy has a code sample and some comments in general about how to add objects using DMO. It's good code and a very quick introduction to how objects work. Worth reading!
2002-02-14
4,769 reads
In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.
2002-01-30
6,892 reads
One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.
2004-11-19 (first published: 2002-01-28)
50,617 reads
This white paper outlines the following:
-The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition.
-The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition.
-A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.
2002-01-25
1,822 reads
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
Comments posted to this topic are about the item Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers