http://www.sqlmag.com/authors/author/author/5581864/rsscomment/5581864en-USFri, 25 May 2012 11:19:50 GMTFri, 25 May 2012 11:19:50 GMThttp://www.sqlmag.com/article/data-access/putting-together-your-high-availability-puzzle#commentsAnchorMon, 03 Aug 2009 12:22:32 GMT
Wonderful article. Thanks. Take Care!]]>MarcosMon, 03 Aug 2009 12:22:32 GMThttp://www.sqlmag.com/article/data-access/putting-together-your-high-availability-puzzle#commentsAnchorhttp://www.sqlmag.com/article/consolidation/polyserve-database-utility-for-sql-server#commentsAnchorFri, 08 Feb 2008 05:34:59 GMT
Useful overview of PolyServe]]>EdFri, 08 Feb 2008 05:34:59 GMThttp://www.sqlmag.com/article/consolidation/polyserve-database-utility-for-sql-server#commentsAnchorhttp://www.sqlmag.com/article/san/split-mirror-san-and-nas#commentsAnchorFri, 04 May 2007 07:48:13 GMT
The main article (see link at the top) talks about Split-Mirroring.]]>DianaFri, 04 May 2007 07:48:13 GMThttp://www.sqlmag.com/article/san/split-mirror-san-and-nas#commentsAnchorhttp://www.sqlmag.com/article/san/split-mirror-san-and-nas#commentsAnchorThu, 03 May 2007 15:25:42 GMT
The article does not tell you a thing about what Split-Mirroring is.]]>DonaldThu, 03 May 2007 15:25:42 GMThttp://www.sqlmag.com/article/san/split-mirror-san-and-nas#commentsAnchorhttp://www.sqlmag.com/article/tsql3/sql-server-2005-management-tools#commentsAnchorWed, 20 Sep 2006 10:20:16 GMT
While I still use Enterprise Manager with our SQL2000 servers more often, I’ve had a decent amount of experience with SQL 2005’s Management Studio and can offer a few thoughts on it. I also spend a large amount of time developing SSIS packages in VS2005. In a nutshell, I agree with your take on Management Studio’s features, but I think it’s overall usability went down a few notches. Granted, that’s a subjective thing, but in general, the "number of clicks required to accomplish a given task" factor has gone up. It also seems that a majority of the UI is wasted... you spend most of your mouse time navigating through the Object Explorer in the left-hand pane eventually pulling up the properties dialog you need while the right-hand pane is mostly redundant/unused. Part of that is the explorer-style interface, but I was really hoping for more "task pad" style screens & forms. I’m just glad that sorting objects by create-date finally works!]]>CHRISWed, 20 Sep 2006 10:20:16 GMThttp://www.sqlmag.com/article/tsql3/sql-server-2005-management-tools#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/simple-log-shipping-in-sql-server-2000-standard-edition#commentsAnchorTue, 24 May 2005 01:11:20 GMT
erwerw]]>Anonymous User Tue, 24 May 2005 01:11:20 GMThttp://www.sqlmag.com/article/stored-procedures/simple-log-shipping-in-sql-server-2000-standard-edition#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/simple-log-shipping-in-sql-server-2000-standard-edition#commentsAnchorTue, 24 May 2005 01:10:17 GMT
This helps me only less for me this can be implemented more for me by explaining more on me....]]>Anonymous User Tue, 24 May 2005 01:10:17 GMThttp://www.sqlmag.com/article/stored-procedures/simple-log-shipping-in-sql-server-2000-standard-edition#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/simple-log-shipping-in-sql-server-2000-standard-edition#commentsAnchorFri, 29 Apr 2005 08:25:36 GMT
sds]]>Anonymous User Fri, 29 Apr 2005 08:25:36 GMThttp://www.sqlmag.com/article/stored-procedures/simple-log-shipping-in-sql-server-2000-standard-edition#commentsAnchorhttp://www.sqlmag.com/article/san/split-mirror-san-and-nas#commentsAnchorThu, 03 Jun 2004 02:38:43 GMT
Very informative and interesting article! But it doesn’t talk as much about NAS as it does about SAN. It would be better to have something which would talk about NAS as much as SAN in the same way as above giving a good comparison. Otherwise too, very informative article]]>sandeepThu, 03 Jun 2004 02:38:43 GMThttp://www.sqlmag.com/article/san/split-mirror-san-and-nas#commentsAnchorhttp://www.sqlmag.com/article/data-modeling/er-studio-4-02a#commentsAnchorThu, 11 Mar 2004 10:40:13 GMT
Excellent]]>Saim Thu, 11 Mar 2004 10:40:13 GMThttp://www.sqlmag.com/article/data-modeling/er-studio-4-02a#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/log-shipping-in-sql-server-2000-part-2#commentsAnchorTue, 08 Oct 2002 04:27:02 GMT
I would like to check if the information on step6 is correct. The statement claims that SQL 2000 BOL omits an important step when illustrating "resolving the logins on the secondary server" If I am correct, the sp_change_users_login procedure is embedded in the sp_resolve_logins stored procedure. Attached here partial code of sp_resolve_logins (line 101,102) EXEC (’EXEC ’ + @dest_db + ’.dbo.sp_change_users_login Update_One, ’ + @usrname + ’,’ + @lgnname) With the above information, the step is not missing. Please comment.]]>Frankie Ma Tue, 08 Oct 2002 04:27:02 GMThttp://www.sqlmag.com/article/enterprise-manager/log-shipping-in-sql-server-2000-part-2#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorFri, 25 Jan 2002 13:17:22 GMT
hmm... i’ve already set all this up in sql server 7 with the good’ole .sql files that come with (BORK), and even tho i have it all set up properly it doesn’t seem to be doing any thing. i’m thinking that you don’t necessarily run the .sql’s as a whole, but rather you go thru the code, and run blocks of it, changing variables as you go along. i’m about to take this course of action, cause i’m not quite sure what i didn’t do at this point. there really isn’t a whole lot of material out there (at least none that i have found) on the subject of the sql code. has any one done this with flying success? if so, i could use some info from a seasoned professional on the subject of sql 7 log shipping. if you could just walk me thru this one more time that would be great!! thanks in advance. cheers.]]>MikeFri, 25 Jan 2002 13:17:22 GMThttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorTue, 27 Nov 2001 18:08:10 GMT
Very well written. Clear. Concise. Step by step, without overly verbose descriptions. Thanks!]]>Tyler Olsen Tue, 27 Nov 2001 18:08:10 GMThttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorhttp://www.sqlmag.com/article/log-files/split-mirror-backup-and-restore#commentsAnchorTue, 27 Nov 2001 18:05:14 GMT
The article implies that the database is down during resynchronization. If that were true, there is limited benefit to this feature. How does the resynchronization process effect database read and write performance?]]>Don Urbanic Tue, 27 Nov 2001 18:05:14 GMThttp://www.sqlmag.com/article/log-files/split-mirror-backup-and-restore#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorTue, 17 Apr 2001 14:07:04 GMT
Has anyone had success implementing this? Although Ron doesn’t suggest using log shipping for reporting purposes, I’d like to use it rather than setting up some huge replication scheme. Thanks.]]>Randy M. Franklin, Jr. Tue, 17 Apr 2001 14:07:04 GMThttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorSun, 25 Mar 2001 17:28:47 GMT
If you don’t want to reconfigure all your clients in a failover situation, just use a function-specific Netbios alias if your clients connect using named pipes or a function-specific DNS alias if you use IP sockets. In a failover, you just change the alias to point to the new server. Clients should never refer to a server by name or IP number. It causes to many headaches in the long run.]]>Stephen Brain Sun, 25 Mar 2001 17:28:47 GMThttp://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0#commentsAnchorhttp://www.sqlmag.com/article/development/cast-workbench#commentsAnchorTue, 18 Jul 2000 14:53:56 GMT
I have used CAST Workbench and its tools while at my previous employer. It was far superior to any other tool we looked at in managing the vast number of tables, stored procedures, triggers and their dependencies, which we had in our massive development and testing environments. Although pricey at startup and implementing the system may require some outside help (Cast Services), the advantages that Cast tools offer the developer and DBA will far outweigh the weighty initial costs. Once implemented, Cast was easy to use and made managing large databases a dream.]]>Rich Ceruolo Tue, 18 Jul 2000 14:53:56 GMThttp://www.sqlmag.com/article/development/cast-workbench#commentsAnchor