Additional Articles


Technical Article

SQL Bible

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. (Not Reviewed)

2003-07-11

947 reads

Technical Article

Microsoft SQL Server 2000 Weekend Crash Course

The big day is Monday. The day you get to show off what you know about SQL Server 2000. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL Server. Or maybe you just like a challenge. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to get right to work on a SQL Server 2000 databases.(Not Reviewed)

2003-07-04

793 reads

Technical Article

SQL Server DTS Best Practices

This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.

2003-06-24

4,068 reads

Technical Article

Free BCP GUI

Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.

2003-06-19

1,922 reads

Technical Article

myLittleAdmin for MS SQL and MSDE released !

myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.

2003-06-17

1,164 reads

Technical Article

SQL Database Audit Tool released to beta

LockwoodTech has released a new sql tool that analyzes the SQL Server transaction log to passively audit a SQL Server database. You can track inserts, updates, deletes and full row level detail of past transactions (even before the tool was installed). Client supports powerful filtering, grouping and sorting of audit data.

2003-06-16

37 reads

Blogs

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

FDD 2023 – Session Materials

By

You can find the slides for my session at Future Data Driven summit at...

Quick Filtering in SSMS–#SQLNewBlogger

By

I saw someone limit the databases they see in SSMS, which isn’t something I...

Read the latest Blogs

Forums

Central Management Server (CMS) on AlwaysOn for Failover Process

By sunshine-587009

Good afternoon! Is there any type of documentation or process for failing over a...

Convert Binary or Hex field to show text information

By kakovatos7

Hi all, I have an SQL database table with events, and within it a...

Write https request to azure blobstorage

By Charmer

Hi All, I have been trying to download a csv file which is produced...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers