Karen Watterson
|
|
Karen Watterson is a contributing editor for Windows IT Pro. She is a database and data warehouse design consultant and the editor of the SQL Server Professional newsletter.
Email address: karen_watterson@msn.com
|
99 results found for Karen Watterson, displaying items 1 - 20
|
 |
|
April 1, 2000 |
|
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.
SQL Server Magazine
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.
Windows IT Pro
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.
Windows IT Pro
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.
Windows IT Pro
|
January 10, 2000 |
|
Locating DTS Packages
SQL Server Magazine
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.
Windows IT Pro
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.
Windows IT Pro
|
December 10, 1999 |
|
Moving Passwords in Bulk
Here are tips for transferring encrypted passwords between servers in SQL Server 6.5 and 7.0.
SQL Server Magazine
|
November 17, 1999 |
|
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.
SQL Server Magazine
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.
Windows IT Pro
|
November 1, 1999 |
|
Application Roles: Not as Useful as They Could Be
The authors discuss how to customize users' security permissions.
SQL Server Magazine
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.
Windows IT Pro
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.
Windows IT Pro
Trends & Insights: Collaboration and KM
Read the tea leaves of key technologies--collaboration and KM.
SQL Server Magazine
|
October 1, 1999 |
|
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.
SQL Server Magazine
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.
Windows IT Pro
Trends & Insights: Shiloh Mounts an Offensive
For Microsoft BackOffice and SQL Server users, Shiloh means the next major release of SQL Server.
SQL Server Magazine
Microsoft Invests in Inprise
SQL Server Magazine
Promoting the SQL Server Brand
SQL Server Magazine
OLAP Client Wars
SQL Server Magazine
|
|
Register
