SQL Server Magazine

Questions, Answers, and Tips about Using SQL Server

Tips on determining the correct service pack build number, using the Database Consistency Checker (DBCC), and more.

Questions, Answers, and Tips About SQL Server

Stabilize nullability, monitor tables to find script triggers, make SQL Server and Oracle data compatible, implement custom application-locking schemes, and create indexes that use functions or expressions.

Questions, Answers, and Tips About SQL Server

Investigate how to install multiple instances of SQL Server, use the TOP statement with a local variable, use UDFs in SQL Server 2000, store extended properties, and more.

Questions, Answers, and Tips About SQL Server

Learn about the paging file's importance, SQL Server 7.0 evaluation version's hazards, build numbers, DBCC DBREINDEX and fragmentation, mysterious indexes, permissions problems, and performance tuning.

Locating DTS Packages

Questions, Answers, and Tips About SQL Server

Karen and Brian explore topics including DTS gotchas, the DTS ScriptPkg utility, FoxPro and SQlL server UDF support, and OLAP Services FoodMart data.

Questions, Answers, and Tips About SQL Server

Simultaneously manage SQL Server 6.5 and SQL Server 7.0, determine whether you can pipe output from Query Analyzer into a text file, and discover how to remove decimal points from entries in a character column.

Moving Passwords in Bulk

Here are tips for transferring encrypted passwords between servers in SQL Server 6.5 and 7.0.

SQL Server Security Model Changes

Changes that Microsoft made to the SQL Server security model have caused performance slowdowns for certain queries. Here's a workaround.

Questions, Answers, and Tips About SQL Server

Karen and Brian discuss User DSNs vs. System DSNs, scripts that let you view temporary table structures, enhancements in OLAP Services 7.5, how to disable update triggers, and SQL Agent jobs.

Application Roles: Not as Useful as They Could Be

The authors discuss how to customize users' security permissions.

Questions, Answers, and Tips About SQL Server

Karen and Brian discuss Win2K's effect on SQL Server users, security account delegation, NULL problems, compressed volumes, and SQL Server 7.0's TRUNCATE TABLE statement.

Questions, Answers, and Tips About SQL Server

Discover how to send large email messages via SQL Mail, read system sp code, and make Enterprise Edition use more memory, and learn about SQL Server 7.0's sysperfinfo table, SQL Server Site Index, the TOP operator, and SQL Server 6.5's sql.log.

Trends & Insights: Collaboration and KM

Read the tea leaves of key technologies--collaboration and KM.

SQL Server Savvy

SQL Server 7.0's new Index Tuning Wizard is one of the basics in a DBA toolbox, but here's a weakness we recently encountered.

Questions, Answers, and Tips About SQL Server

Learn about single-table backup and restore, SQL Server 7.0 options to remove databases between servers, a REMOVE FILE error message, clustered index performance problems, and more.

Trends & Insights: Shiloh Mounts an Offensive

For Microsoft BackOffice and SQL Server users, Shiloh means the next major release of SQL Server.

Microsoft Invests in Inprise

Promoting the SQL Server Brand

OLAP Client Wars