http://www.sqlmag.com/authors/author/author/5777317/rss/5777317en-USFri, 25 May 2012 08:33:35 GMTFri, 25 May 2012 08:33:35 GMThttp://www.sqlmag.com/article/systems-administrator/questions-answers-and-tips-about-using-sql-server
By Karen Watterson
Tips on determining the correct service pack build number, using the Database Consistency Checker (DBCC), and more.]]>Karen WattersonSat, 01 Apr 2000 00:00:00 GMThttp://www.sqlmag.com/article/systems-administrator/questions-answers-and-tips-about-using-sql-serverhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8492
By Karen Watterson
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.]]>Karen WattersonThu, 30 Mar 2000 15:26:10 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8492http://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316
By Karen Watterson
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.]]>Karen WattersonWed, 08 Mar 2000 09:47:38 GMThttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316http://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8146
By Karen Watterson
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.]]>Karen WattersonWed, 09 Feb 2000 12:02:32 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8146http://www.sqlmag.com/article/dts/locating-dts-packages
By Karen Watterson
Locating DTS Packages]]>Karen WattersonMon, 10 Jan 2000 00:00:00 GMThttp://www.sqlmag.com/article/dts/locating-dts-packageshttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7953
By Karen Watterson
Karen and Brian explore topics including DTS gotchas, the DTS ScriptPkg utility, FoxPro and SQlL server UDF support, and OLAP Services FoodMart data.]]>Karen WattersonThu, 06 Jan 2000 10:17:30 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7953http://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792
By Karen Watterson
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.]]>Karen WattersonFri, 10 Dec 1999 11:16:38 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792http://www.sqlmag.com/article/security/moving-passwords-in-bulk
By Karen Watterson
Here are tips for transferring encrypted passwords between servers in SQL Server 6.5 and 7.0.]]>Karen WattersonFri, 10 Dec 1999 00:00:00 GMThttp://www.sqlmag.com/article/security/moving-passwords-in-bulkhttp://www.sqlmag.com/article/quering/sql-server-security-model-changes
By Karen Watterson
Changes that Microsoft made to the SQL Server security model have caused performance slowdowns for certain queries. Here’s a workaround.]]>Karen WattersonWed, 17 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/quering/sql-server-security-model-changeshttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7612
By Karen Watterson
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.]]>Karen WattersonMon, 15 Nov 1999 10:08:26 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7612http://www.sqlmag.com/article/systems-administrator/application-roles-not-as-useful-as-they-could-be
By Karen Watterson
The authors discuss how to customize users’ security permissions. ]]>Karen WattersonMon, 01 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/systems-administrator/application-roles-not-as-useful-as-they-could-behttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7506
By Karen Watterson
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.]]>Karen WattersonFri, 29 Oct 1999 10:47:14 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7506http://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309
By Karen Watterson
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.]]>Karen WattersonTue, 05 Oct 1999 13:19:38 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309http://www.sqlmag.com/article/sql-server/trends-insights-collaboration-and-km
By Karen Watterson
Read the tea leaves of key technologies--collaboration and KM.]]>Karen WattersonFri, 01 Oct 1999 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/trends-insights-collaboration-and-kmhttp://www.sqlmag.com/article/performance/sql-server-savvy
By Karen Watterson
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.]]>Karen WattersonFri, 01 Oct 1999 00:00:00 GMThttp://www.sqlmag.com/article/performance/sql-server-savvyhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225
By Karen Watterson
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.]]>Karen WattersonTue, 14 Sep 1999 13:03:03 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225http://www.sqlmag.com/article/sql-server/trends-insights-shiloh-mounts-an-offensive
By Karen Watterson
For Microsoft BackOffice and SQL Server users, Shiloh means the next major release of SQL Server.]]>Karen WattersonWed, 01 Sep 1999 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/trends-insights-shiloh-mounts-an-offensivehttp://www.sqlmag.com/article/internals-and-architecture/microsoft-invests-in-inprise
By Karen Watterson
]]>Karen WattersonWed, 01 Sep 1999 00:00:00 GMThttp://www.sqlmag.com/article/internals-and-architecture/microsoft-invests-in-inprisehttp://www.sqlmag.com/article/training-and-certification2/promoting-the-sql-server-brand
By Karen Watterson
]]>Karen WattersonWed, 01 Sep 1999 00:00:00 GMThttp://www.sqlmag.com/article/training-and-certification2/promoting-the-sql-server-brandhttp://www.sqlmag.com/article/visual-basic-vb/olap-client-wars
By Karen Watterson
]]>Karen WattersonWed, 01 Sep 1999 00:00:00 GMThttp://www.sqlmag.com/article/visual-basic-vb/olap-client-wars