Total SQL Analyzer Review

Often times, a DBA is asked by clients to document their entire server. This usually includes jobs, database objects and DTS packages. What an utterly boring task it is for a DBA to document the properties of each column, table, and database. FMS's new Total SQL Analyzer to the rescue, freeing up time for people who are tired of creating mountains of documentation.

New Year, New Gear

Start the new year right with a new operating system or book. Be the user who enriches the SQL Server community the most and receive the top price of a full version of Windows XP (a $299 value!). Any SQLServerCentral.com user who helps to build the SQL Server community by submitting a script, posting in the forum or posting an original FAQ is eligible (US and Canada residents only for the first prize in this contest).

Simple OLE DB Provider for XML

The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.

Introduction to ADO Part 4 - Combining It All

In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started.

Microsoft SQL Server 2000 Security

This document introduces the new security features of Microsoft SQL Server 2000. New features are outlined, and a detailed discussion is provided about how to best implement security in a Microsoft Windows 2000 domain environment. Source code examples are included for developers who want to implement the security model immediately.

Blogs

Letter To My Father

By

We spread my Fathers ashes over the past weekend. It was one of the...

My Organizer's Notes and Goodbye after #SQLSatBR 2019

By

Some 2019 tips for other SQLSat organizers from my last year as lead organizer...

Query Store stores dates as UTC

By

One of the powerful aspects of Query Store is the ability to directly query...

Read the latest Blogs

Forums

SQL Server 2016 Archive Strategy advice.

By destino

Greetings. I’m after some advice. I’m helping a colleague with a SQL Server 2016...

Let’s Start with Architecture

By pamelamooney1966

Comments posted to this topic are about the item Let’s Start with Architecture

Database Auditing

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Auditing

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers