http://www.windowsitpro.com/authors/author/author/3671043/rsscomment/3671043en-USSun, 27 May 2012 03:26:54 GMTSun, 27 May 2012 03:26:54 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/backup-completed-error-message-143112#commentsAnchorThu, 24 May 2012 18:11:05 GMT
Kevin, May I please say AMEN! It may be useful to see those completion messages when you have a manageable number of databases but on systems with numberous db's, that trace flag is invaluable. Three of the servers I manage have 150+ databases each and it is impossible to zero in on a real issue in the error log with thousands (I mean thousands- daily backups plus hourly tran log backups = thousands of entries!) of these benign messages filling up the error log! Thank goodness for the 3226 trace flag! Stefanie Higgins]]>sqlpixieThu, 24 May 2012 18:11:05 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/backup-completed-error-message-143112#commentsAnchorhttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/backup-completed-error-message-143112#commentsAnchorThu, 24 May 2012 10:00:25 GMT
Kevin, It is annoying, but it can also be helpful. Knowing errors happened close to the backup times might point you in the direction that the backup caused an issue. Michael Dean]]>Michael DeanThu, 24 May 2012 10:00:25 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/backup-completed-error-message-143112#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/sql-server-finebuild#commentsAnchorMon, 09 Jan 2012 17:43:43 GMT
A new release documented at http://www.sqlmag.com/blog/tool-time-blog-16/tool-time-with-kevin-kline/check-updates-tool-time-favorite-finebuild-141853. ]]>Kevin_KlineMon, 09 Jan 2012 17:43:43 GMThttp://www.windowsitpro.com/article/sql-server/sql-server-finebuild#commentsAnchorhttp://www.windowsitpro.com/blog/tool-time-blog-16/tool-time-with-kevin-kline/information-hoarder-141116#commentsAnchorFri, 02 Dec 2011 21:48:59 GMT
Great Hands on How to Content (SMO)1.6732Ghz ]]>akela_p501usaFri, 02 Dec 2011 21:48:59 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/tool-time-with-kevin-kline/information-hoarder-141116#commentsAnchorhttp://www.windowsitpro.com/article/compression/sql-server-compression-estimator-139766#commentsAnchorTue, 04 Oct 2011 09:55:19 GMT
Hi Kevin, Interesting to know about this tool and I will sure give it a try some time soon. Here is a post of mine that is very much related: http://blogs.microsoft.co.il/blogs/yaniv_etrogi/archive/2011/09/24/automating-sql-server-2008-data-compression-decision-taking.aspx ]]>yaniv.etrogiTue, 04 Oct 2011 09:55:19 GMThttp://www.windowsitpro.com/article/compression/sql-server-compression-estimator-139766#commentsAnchorhttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/check-release-ssms-tool-pack-mladen-140727#commentsAnchorTue, 27 Sep 2011 08:28:15 GMT
Sorry for getting your name wrong, Mladen! Folks, you can follow Mladen on twitter (@MladenPrajdic) and read his blog (http://weblogs.sqlteam.com/mladenp/) as well. Very good stuff!]]>Kevin_KlineTue, 27 Sep 2011 08:28:15 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/check-release-ssms-tool-pack-mladen-140727#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/sp_whoisactive#commentsAnchorMon, 14 Mar 2011 20:16:20 GMT
Nice one , very useful .

I am getting below error for a complex large query.
error message="XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels." ]]>MuppanaMon, 14 Mar 2011 20:16:20 GMThttp://www.windowsitpro.com/article/sql-server/sp_whoisactive#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/sql-server-2008-spatial-tools#commentsAnchorMon, 06 Dec 2010 10:27:15 GMT
Another great tool is the Virtual Earth spatial data generator at http://mikeo.co.uk/demo/sqlspatial/default.aspx.
]]>BurttMon, 06 Dec 2010 10:27:15 GMThttp://www.windowsitpro.com/article/sql-server/sql-server-2008-spatial-tools#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/sql-server-2005-system-diagram#commentsAnchorFri, 05 Nov 2010 18:04:23 GMT
SQL Server Magazine occasionally bundles this in with the magazine subscription, although I’m not privy to when and which issues that might be.]]>KLINEFri, 05 Nov 2010 18:04:23 GMThttp://www.windowsitpro.com/article/sql-server/sql-server-2005-system-diagram#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/autoaudit#commentsAnchorFri, 30 Jul 2010 08:25:09 GMT
Interesting.
Does your ’AutoAudit’ satisfy FISMA/ECAR? Is it good enough for Class B2 TCSEC government system?]]>HOLSINGERFri, 30 Jul 2010 08:25:09 GMThttp://www.windowsitpro.com/article/sql-server/autoaudit#commentsAnchorhttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/automatic-shutdown-and-startup-of-services-136860#commentsAnchorWed, 28 Apr 2010 00:35:13 GMT
Hi Kevin,

I like PsService by Mark, it is easy to handle.
http://technet.microsoft.com/en-us/sysinternals/bb897542.aspx

CU
tosc]]>toscWed, 28 Apr 2010 00:35:13 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/automatic-shutdown-and-startup-of-services-136860#commentsAnchorhttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/collaboration-nation-call-to-action-calling-all-sql-server-bloggers-and-twitterers-136859#commentsAnchorTue, 23 Mar 2010 11:58:31 GMT
Not sure how I feel about the nicknames for Paul but I would agree that he often needs a good swat + his nose stuck in it... ;-)

Cheers,
kt]]>Kimberly L. TrippTue, 23 Mar 2010 11:58:31 GMThttp://www.windowsitpro.com/blog/tool-time-blog-16/sql-server/collaboration-nation-call-to-action-calling-all-sql-server-bloggers-and-twitterers-136859#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/tool-tip-the-awesomeness-of-robocopy#commentsAnchorMon, 15 Mar 2010 17:22:58 GMT
Instead of Robocopy, use RoboCopyPlus (www.robocopyplus.com).
It is a wrapper around your instalaltion of Robocopy, that adds email notification depending on the job result (success, warning, error) and optionally attaches logfiles that it can strip down to showing the warnings and errors only.

Becasue it’s only a wrapper, it works with all versions of Robocopy and you can use yoru existing scripts pretty much; just need to add the swicthes that define the email message to be sent out.

We use it for our customers and is hugely enhances the ease of managing som any daily jobs.

Cool little tool :)!]]>LeenheerMon, 15 Mar 2010 17:22:58 GMThttp://www.windowsitpro.com/article/sql-server/tool-tip-the-awesomeness-of-robocopy#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/architecture-questions-what-s-your-opinion-#commentsAnchorMon, 01 Mar 2010 10:56:26 GMT
I would like to see more on the folklore of the architecture itself. The second quesiton needs more elaboration. ]]>LawrenceMon, 01 Mar 2010 10:56:26 GMThttp://www.windowsitpro.com/article/sql-server/architecture-questions-what-s-your-opinion-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/troubleshooting-parallel-queries-on-sql-server-2005#commentsAnchorMon, 22 Feb 2010 06:57:49 GMT
nice one]]>avinashMon, 22 Feb 2010 06:57:49 GMThttp://www.windowsitpro.com/article/sql-server/troubleshooting-parallel-queries-on-sql-server-2005#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/get-a-clue-a-sqlclue-that-is-#commentsAnchorTue, 19 Jan 2010 17:39:07 GMT
Bill Wunder dropped me a note and asked me to post the following added info: By the way, the SQLClue Configuration Compare tool is absolutely free. It can be used to compare all configuration settings and scripted objects on any two SQL Servers or compare two files containing SQL scripts or any other data, or a file and SQL Instance, or - and this is a handy one I use more and more, the .showplan xml output from two query plans saved from the query plan DMVs or the Van Gogh GUI. It is only if you create a data store that a SQLClue license must be purchased. Cheers!]]>KEVINTue, 19 Jan 2010 17:39:07 GMThttp://www.windowsitpro.com/article/sql-server/get-a-clue-a-sqlclue-that-is-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/tool-tip-the-awesomeness-of-robocopy#commentsAnchorMon, 18 Jan 2010 17:49:05 GMT
Cool, Josh. Do you have any recommendations for script libaries for ROBOCOPY? It’d be neat to discover that there are some out there somewhere. Also, I encourage you to join the conversation at the SQLMag Tool Time forum (http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=169&threadid=93919&enterthread=y). Thanks, -Kevin]]>KEVINMon, 18 Jan 2010 17:49:05 GMThttp://www.windowsitpro.com/article/sql-server/tool-tip-the-awesomeness-of-robocopy#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/tool-tip-the-awesomeness-of-robocopy#commentsAnchorWed, 13 Jan 2010 16:52:40 GMT
I use robocopy almost daily and have use it in tons of automation scripts. Nice article.]]>JoshWed, 13 Jan 2010 16:52:40 GMThttp://www.windowsitpro.com/article/sql-server/tool-tip-the-awesomeness-of-robocopy#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/disk2vhd-the-physical-to-virtual-converter#commentsAnchorSat, 09 Jan 2010 19:15:59 GMT
Actually VMWare has had a P2V converter for years. You can download it from VMWare here http://www.vmware.com/products/converter/ You can run the tool while the physical box is running Another great (but not free as in no trial s/w) is Novell’s Platespin Migrate. It does the job, but you have to buy a license for each server you convert which could get costly if you have a lot.]]>TonySat, 09 Jan 2010 19:15:59 GMThttp://www.windowsitpro.com/article/sql-server/disk2vhd-the-physical-to-virtual-converter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorWed, 06 Jan 2010 04:54:59 GMT
Just to set the record straight. Im not the same kalpesh thaker who committed the original offence :). However i do share the same name...so don’t panic :) I work as a day to day linux sysadmin in southern africa, and discussing tips and issues on public forums and networkds has become somewhat of a day to day enjoyment for me. Plagiarism in my book is definitely a serious offence. Unfortunately, due to way that information has become so publically available nowdays, this kind of thing will happen time and time again. I think setting an example of an offence should be more than enough to discourage people from plagiarising material on public networks. Plagiarism is a form of theft, and legal action should be taken depending on the offence committed. I do think that careful moderation of publications needs to be improved in general, as in most cases, this is a last measure before the publication goes live.]]>kalpeshWed, 06 Jan 2010 04:54:59 GMThttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/whose-free-dmv-monitoring-tool-is-better-#commentsAnchorTue, 17 Nov 2009 06:53:55 GMT
erfasdfdfsdafasdfas]]>mohanTue, 17 Nov 2009 06:53:55 GMThttp://www.windowsitpro.com/article/sql-server/whose-free-dmv-monitoring-tool-is-better-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorSun, 01 Nov 2009 14:52:47 GMT
Please note that the URL shown above is out of date and will produce a 404 error. To download SQL Script, please use: http://www.sqlserverutilities.com/SQL-Server-Utilities-SQLScripter-product-details.htm Thanks, -Kevin]]>KEVINSun, 01 Nov 2009 14:52:47 GMThttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/disk2vhd-the-physical-to-virtual-converter#commentsAnchorFri, 16 Oct 2009 02:59:58 GMT
VMWare also have a free tool for migrating PM to VM: http://www.vmware.com/products/converter/ There is article about this at: http://www.petri.co.il/virtual_convert_physical_machines_to_virtual_machines_with_vmware_converter.htm Regards, Matjaz]]>MatjazFri, 16 Oct 2009 02:59:58 GMThttp://www.windowsitpro.com/article/sql-server/disk2vhd-the-physical-to-virtual-converter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/health-data-rights#commentsAnchorWed, 30 Sep 2009 21:24:51 GMT
Excellent input, Michael. And thanks for making me aware of your blog. I’m checking it out now! =^) -Kevin]]>KEVINWed, 30 Sep 2009 21:24:51 GMThttp://www.windowsitpro.com/article/sql-server/health-data-rights#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/health-data-rights#commentsAnchorMon, 28 Sep 2009 07:28:47 GMT
Kevin, I agree with most of everything you said - and I’ve been there. Most of the last few decades of my career have been spent in the juncture between MSSQL and health care (see my blog http://www.MSSQL-HealthIT.com). One other nuance in the progress is this: Many hospitals are on a nearly 10 year plan to convert to Electronic Medical Record (EMR) systems, which include many modules (Billing, Scheduling, Order Entry, etc.). It’s been my experience that data mining, indeed, BI, only occurs when hospitals are many years down the road with this effort, after huge amounts of info has been collected. They then turn to ETL issues, poor query response, self-serve BI, etc, only at this time - with all the heartache (and hearturn, fellow GERD patient) that incurs. We can assist these leaders by encouraging them to adopt BI systems *at the same time* as the inception of the first EMR modules, rather than as an afterthought. This is particularly pertinent since a system has to be installed to prove "meaningful use" in order to receive the stimulus money for the next few years. Us old SQL dogs have both an opportunity and a duty to encourage such adoption. Regards, Michael Clifford]]>MICHAELMon, 28 Sep 2009 07:28:47 GMThttp://www.windowsitpro.com/article/sql-server/health-data-rights#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorWed, 23 Sep 2009 00:21:39 GMT
Hi Kevin, I guess my reply is a bit late comer! :) But anyways... I completely agree with you that Plagiarism is a form of Theft! And hence it must be dealt with just like one! Every professional must take responsibility of what he / she is publishing and claiming as his / her own pieces of work. Now days, with the help of blog sites, forums, it’s very easy for one to violate copyrights and still get away with it. In order to control Plagiarism, the concerned governing bodies of these sites must have some measures to verify the Authenticity of the Author himself/herself and also every article he/she publishes. I feel very bad about that fact that the cases that you have pointed out in this article come from my home country, India. These are some of those incidents which allow people to form opinions about India. However, please let me assure you that these are only very rare cases and there are plenty of Professionals from India still around with their Dignity intact! Hope this makes sense! Regards, Atul Kale Sr. Solution Architect]]>AtulWed, 23 Sep 2009 00:21:39 GMThttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/new-slide-deck-section-added#commentsAnchorMon, 21 Sep 2009 16:30:33 GMT
The slides have all been corrected. In addition, I’ve posted a couple new slide decks from my sessions at the Best Practices Conference (http://www.bestpracticesconference.com). -Kevin]]>KEVINMon, 21 Sep 2009 16:30:33 GMThttp://www.windowsitpro.com/article/sql-server/new-slide-deck-section-added#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/new-slide-deck-section-added#commentsAnchorThu, 03 Sep 2009 08:47:53 GMT
I couldn’t open any of slides. Also, error 404 file is not found (Should I Virtualize SQL Server?).]]>SergeiThu, 03 Sep 2009 08:47:53 GMThttp://www.windowsitpro.com/article/sql-server/new-slide-deck-section-added#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/another-great-tool-from-yaniv-etrogi#commentsAnchorSat, 18 Jul 2009 16:04:38 GMT
The updated link is: http://blogs.microsoft.co.il/blogs/yaniv_etrogi/BlocksTracer/BlocksTracer.zip]]>YanivSat, 18 Jul 2009 16:04:38 GMThttp://www.windowsitpro.com/article/sql-server/another-great-tool-from-yaniv-etrogi#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorFri, 10 Jul 2009 09:30:32 GMT
How to install the latest version: The code is in the link of the statement below in the doc home page. The name of the file is "hyperlinked". If you click on it, it opens the script directly in management studio. We will reformulate the next statement to make it more obvious. "To install the latest version of YourSQLDba, just execute the script YourSQLDba_InstallOrUpdateScript.sql in a SQL Server Management Studio window for the SQL Server 2005 and beyond." For first time installation, another script must be ran with your customized parameters directly on SQL Server machine. Open on the left "YourSqlDba Guide" doc tree and "Initial Setup" topic. Theses parameters are default backup directory for logs and data, SMTP server to use for emailing maintenance report to you, and your email adress. Samples are given on in this topic. This is needed to be ran only once. For future upgrades just re-run YourSQLDba_InstallOrUpdateScript.sql scripts. Your can give your comments and feedback at www.codeplex.com.]]>MauriceFri, 10 Jul 2009 09:30:32 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorTue, 07 Jul 2009 09:29:49 GMT
I downloaded YourSQLDba, but there is no code in the YourSQLDba_ENU.zip file, only the YourSQLDba_ENU.chm help file.]]>JOHNTue, 07 Jul 2009 09:29:49 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorMon, 06 Jul 2009 15:10:04 GMT
Thanks for letting us know about the broken download link. The article has been updated with the new link, which you’ll find in the summary box under How to Get It. You can find out more information about why this link changed in Kevin Kline’s In a Nutshell blog post "Updated Site for YourSQLDBA" at http://www.sqlmag.com/Article/ArticleID/102394/102394.html. Megan Keller Associate Editor, SQL Server Magazine mkeller@sqlmag.com]]>MeganMon, 06 Jul 2009 15:10:04 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/dbgizmo#commentsAnchorThu, 02 Jul 2009 00:09:18 GMT
Thanks, Kevin, for mentioning DBGizmo. The features briefly described in this blog entry are the free features only. They are a small fraction of the overall functionality. DBGizmo is far more than a look-up tool. It’s essentially a database schema analysis tool and a T-SQL code generation tool. There are many unique features to enjoy. We tried to provide the free features while also allowing a reasonable evaluation of the many other features. We tried to do this in an innocuous way, but we would welcome any suggestions for improvement. Brian Walker Wingenious Inc.]]>BRIANThu, 02 Jul 2009 00:09:18 GMThttp://www.windowsitpro.com/article/sql-server/dbgizmo#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorWed, 01 Jul 2009 21:52:37 GMT
I don’t know what happened with SourceForge. May be they did not like that I duplicated this project to Codeplex. In fact there is two places where YourSqlDba can be downloaded: http://yoursqldba.codeplex.com/ http://www.grics.qc.ca/yoursqldba Every change we do to our project is replicated from http://www.grics.qc.ca/yoursqldba to http://yoursqldba.codeplex.com/ site.]]>MauriceWed, 01 Jul 2009 21:52:37 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorWed, 01 Jul 2009 15:15:52 GMT
I know that sqlmaint.exe is deprecated and that the maintenance plans are now run via SSIS, but I did not hear the Database maintenance plans themselves will be deprecated. Most deprecated features are marked as deprecated in Books-On-Line a version or so before they are removed. Is there any official stance on this from Microsoft?]]>TimWed, 01 Jul 2009 15:15:52 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorWed, 01 Jul 2009 12:03:01 GMT
I did find it available at this location: http://yoursqldba.codeplex.com/]]>AaronWed, 01 Jul 2009 12:03:01 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorWed, 01 Jul 2009 11:57:59 GMT
The link for the download does not work. I get a 404 error on Source Forge’s website. A search on that site for YourSQLDba does not return any results.]]>AaronWed, 01 Jul 2009 11:57:59 GMThttp://www.windowsitpro.com/article/sql-server-2005/yoursqldba#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorMon, 25 May 2009 12:10:08 GMT
I agree there needs to be a code of ethics for a Database Administrator. I also think the responsibilities for a Database Administrator need to be more clearly defined. I have worked with databases in some form or antoher for over 12 years and I find that most companies have no idea what a Database Administrators job should be. I have worked at my current position for 8 years and I find that many times ethics and best practices go out the door in exchange for profit and customer satisfaction. I continue to explain the need for data protection and best practices. Sometimes I feel between a rock and a hard place. Hopefully in the future as the need for instant data, reports, and metrics grows corporations will begin to value their DBA’s more and listen to them.]]>TeresaMon, 25 May 2009 12:10:08 GMThttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorhttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorThu, 21 May 2009 09:40:14 GMT
Nice reports. Thanks for the tip.]]>MarcosThu, 21 May 2009 09:40:14 GMThttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorMon, 11 May 2009 18:12:28 GMT
I think that we should strive to find the right solution for the problem in the current environment. I’ve been in environments where the staff was so pedantic about "the process" that they lost the spirit behind the need to support the users, and in environments where there was too much other work to do to spend time doing more than the minimum necessary to get the job done. Neither one was good, but the management and staff seemed to think that it was okay for them at the time.]]>RyanMon, 11 May 2009 18:12:28 GMThttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorMon, 27 Apr 2009 13:49:23 GMT
Interesting but if a hiring company has no interest in the importance of databases, surely the company is at fault for not been aware (ignorance is not a defence)in the importance of database systems and maintenace. At the moment there is no incentive or consequences involved for a lot of companies to ensure best practices are enforced or in the training of there staff.]]>shaunMon, 27 Apr 2009 13:49:23 GMThttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorWed, 22 Apr 2009 13:02:01 GMT
Just a random thought - Any code should include the words "To the best of my ability,...". That leaves it up to me (and my employer, I would hope) to improve my ability, through training, reading, best practices, whatever. If something untoward were to happen with the data I was protecting, I would rather be thought of as slightly unknowledgeable than unethical. Knowledge can be learned; I don’t think "evil" can be fixed.]]>MARKWed, 22 Apr 2009 13:02:01 GMThttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorTue, 21 Apr 2009 16:55:00 GMT
This is a valid, but difficult question. Being the sole dba and typically working for people that don’t understand the funtion(s) of a dba, I am often directed to make do with little personnel or hardware resources. Security and database maintenance are seen as secondary priorities to providing support for developers and data to customers. The joke here is that I’m risk-adverse, but my thought is that is what I was hired for - to protect the data.]]>LoriTue, 21 Apr 2009 16:55:00 GMThttp://www.windowsitpro.com/article/sql-server/is-it-time-for-a-professional-code-of-ethics-for-dbas-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/looking-for-good-dmv-database-admin-queries-#commentsAnchorWed, 08 Apr 2009 09:41:26 GMT
Never head about sqlserverpedia.com neither sqlcat.com before. Looks like sites about sql are been created in an amazing speed. The problem is to know wich one is good and which is not. Thanks for the mention.]]>MarcosWed, 08 Apr 2009 09:41:26 GMThttp://www.windowsitpro.com/article/sql-server/looking-for-good-dmv-database-admin-queries-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/things-you-know-now#commentsAnchorFri, 13 Mar 2009 11:50:51 GMT
Well, not much to add, I think you covered the basis and most important things. If I have to add something, I would say: Keep an eye out of SQL Server, take some time to see what others are doing in the same field. Could be Oracle, IBM or why not... MySQL. See what they are doing and how, figure out why they should be doing it with SQL, thinking about this in advance could be a good thing when you have to argue about why you are a SQL Server DBA instead of ORACLE or DB2 DBA.]]>MarcosFri, 13 Mar 2009 11:50:51 GMThttp://www.windowsitpro.com/article/sql-server/things-you-know-now#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorWed, 04 Mar 2009 15:18:39 GMT
Great stuff, very educational.]]>DonaldWed, 04 Mar 2009 15:18:39 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/best-of-the-blogs#commentsAnchorSat, 21 Feb 2009 04:12:19 GMT
I also like Gail Shaw’s blog http://www.sqlinthewild.co.za/ and aunt Kathy’s blog http://www.sqlservercentral.com/blogs/kathi_kellenberger/]]>DianaSat, 21 Feb 2009 04:12:19 GMThttp://www.windowsitpro.com/article/sql-server/best-of-the-blogs#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/best-of-the-blogs#commentsAnchorMon, 16 Feb 2009 07:07:18 GMT
I’ve created a Google Custom Search Engine that includes all of these blogs at http://www.google.com/coop/cse?cx=013404112661014427095%3Achvbpe8obo0.]]>AaronMon, 16 Feb 2009 07:07:18 GMThttp://www.windowsitpro.com/article/sql-server/best-of-the-blogs#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/does-the-down-economy-have-an-impact-on-your-job-#commentsAnchorFri, 16 Jan 2009 11:49:24 GMT
yea, layoff is pretty bad over las vegas. dba find openings will have to accpet salaries like the take home portion of the indian contractors. where to get free pass to www.sqlpass.org]]>jonFri, 16 Jan 2009 11:49:24 GMThttp://www.windowsitpro.com/article/sql-server/does-the-down-economy-have-an-impact-on-your-job-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/linq-enabling-or-entangling-#commentsAnchorThu, 08 Jan 2009 18:52:56 GMT
Thanks -- we need more articles like this to help us gauge the usefulness and pitfalls of new approaches.]]>James KThu, 08 Jan 2009 18:52:56 GMThttp://www.windowsitpro.com/article/sql-server/linq-enabling-or-entangling-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/linq-enabling-or-entangling-#commentsAnchorFri, 02 Jan 2009 18:02:58 GMT
I agree Kevin. I’ve been getting the sense that MS has been trying to turn the DBA role into some form of database-centric application developer. The app-dev’s I work with have loved most of the new features that have been abstracting them from database objects, and the need to know much about database modeling to build a data driven application. I understand that they are concerned about losing developers to competing ORM technologies, but instead of LINQ (TNBT), I wish they would spend time working on things that DBA’s want. Native change/revision control for SQL Server and DB objects would be a good start. RyanB SQL DBA]]>RyanFri, 02 Jan 2009 18:02:58 GMThttp://www.windowsitpro.com/article/sql-server/linq-enabling-or-entangling-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/linq-enabling-or-entangling-#commentsAnchorMon, 29 Dec 2008 15:18:21 GMT
No comment, just agree with the article.]]>BrianMon, 29 Dec 2008 15:18:21 GMThttp://www.windowsitpro.com/article/sql-server/linq-enabling-or-entangling-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorWed, 03 Dec 2008 11:38:27 GMT
Hi, A new version of SQLScripter is now available for download. This version only resolves the bug encountered with the zipping and due to the many requests by users, it also offers the capability of deleting or not the unzipped original folder in case the zip completes with success. http://www.valinor.co.il/tools-sqlscripter.asp -Yaniv]]>YanivWed, 03 Dec 2008 11:38:27 GMThttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorWed, 19 Nov 2008 01:19:20 GMT
Guys, sorry for the confusion. The link published in the article takes you to a page where you need to scroll down all the way in order to see the actuall download link. This is the direct download link: http://www.valinor.co.il/sqlscripter/SQLScripter.zip SQLScripter by Yaniv Etrogi is free as stated in it’s attached License Agreement. -Yaniv]]>YanivWed, 19 Nov 2008 01:19:20 GMThttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorThu, 13 Nov 2008 10:57:00 GMT
Hi jmgibson, Have you been able to download SQLScripter for free from the link above? I just tested the Click Here to Download SQLScripter link at http://www.valinor.co.il/sqlscripter/sqlscripter.html and was able to download the .zip file and get to the installation wizard with no problems. Please let me know if you are still having problems downloading the tool. Thanks, Megan Keller Associate Editor, SQL Server Magazine mkeller@sqlmag.com]]>meganbearly Thu, 13 Nov 2008 10:57:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorTue, 11 Nov 2008 23:04:40 GMT
I’ve emailed the contact to see if they can fix the .zip file on the provided link.]]>JeffTue, 11 Nov 2008 23:04:40 GMThttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorTue, 11 Nov 2008 22:52:05 GMT
Are you sure its free? I’ve been to that site and the link you provide offers a corrupt .zip file, and downloading the version from www.sqlscripter.com is not free.]]>JeffTue, 11 Nov 2008 22:52:05 GMThttp://www.windowsitpro.com/article/sql-server-2005/sqlscripter#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorMon, 25 Aug 2008 09:42:16 GMT
We are currently at version Microsoft SQL Server 2005 - 9.00.3068.00 (X64), the defrag things it’s SQL2000 because of the ’8.00’ in the version.]]>JOHNMon, 25 Aug 2008 09:42:16 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/blogging-quantity-versus-quality#commentsAnchorSat, 26 Jul 2008 21:05:02 GMT
Good luck with the Twitter-like approach. If I unleashed all thoughts which found their way from the bowels of my brain to the cerebral synapses, I don’t think others would find them nearly as clever or useful as I. Indeed, I’d likely read what I wrote and wonder, "Egad--what was I thinking!". I’ve always enjoyed your posts. Let me know how the new method works out for you...]]>JimmySat, 26 Jul 2008 21:05:02 GMThttp://www.windowsitpro.com/article/sql-server/blogging-quantity-versus-quality#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/blogging-quantity-versus-quality#commentsAnchorTue, 22 Jul 2008 15:57:33 GMT
Kevin, I prefer a hybrid approach as you mention. My blogs are not full-fledged articles yet they should provide value or why write them at all. Also, I plan out my formal articles where as my blogs are not planned. If you read my blogs then you are basically learning what I have been working on and/or been thinking about this week. Cheers Derek Comingore]]>DerekTue, 22 Jul 2008 15:57:33 GMThttp://www.windowsitpro.com/article/sql-server/blogging-quantity-versus-quality#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/sql-server-2005-system-diagram#commentsAnchorTue, 15 Jul 2008 12:36:07 GMT
How do I get a copy of the poster (hard copy) if I am a subscriber?]]>NoelTue, 15 Jul 2008 12:36:07 GMThttp://www.windowsitpro.com/article/sql-server/sql-server-2005-system-diagram#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/what-makes-a-useful-poster-#commentsAnchorFri, 27 Jun 2008 17:12:09 GMT
If the poster is larger than A3, provided it’s pretty, I’ll roll it or fold it and file it somewhere. Years later it could be interesting or funny to look at. So size is the number one decider. Even A3 is a bit big, but if it has a diagram that is a useful overview - e.g. the parts of SQL 2008 or the "BI Burger" - then I might put it on a precious bit of wall-space. If it’s a reference with lots of words then it really has to be something I can hold in my hands. Is that still a "poster"? Whatever, that’s the kind of thing I prefer to get at shows and with magazines.]]>LanceFri, 27 Jun 2008 17:12:09 GMThttp://www.windowsitpro.com/article/sql-server/what-makes-a-useful-poster-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/great-giveaways-in-sqlmag-and-at-teched-2008#commentsAnchorFri, 13 Jun 2008 01:52:36 GMT
Is there a way to receive that poster by mail?]]>JanFri, 13 Jun 2008 01:52:36 GMThttp://www.windowsitpro.com/article/sql-server/great-giveaways-in-sqlmag-and-at-teched-2008#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/crosstab-result-sets-in-sql-server#commentsAnchorWed, 11 Jun 2008 13:35:51 GMT
I need to add the field called @PCField in the results set. How could I do that? I would really appreciate your input on that. Thanks, Mala]]>vijayamala Wed, 11 Jun 2008 13:35:51 GMThttp://www.windowsitpro.com/article/sql-server/crosstab-result-sets-in-sql-server#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/ssms-tools-pack-6-tools-that-help-you-do-more-with-ssms#commentsAnchorTue, 20 May 2008 15:43:17 GMT
Awesome tools, and worth every penny ;-) Thanks so much for sharing it with the SQL Server community!]]>FRANCISTue, 20 May 2008 15:43:17 GMThttp://www.windowsitpro.com/article/sql-server-2005/ssms-tools-pack-6-tools-that-help-you-do-more-with-ssms#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/march-omnibus#commentsAnchorTue, 15 Apr 2008 13:14:35 GMT
It’s funny that Johnl123 is so vehement about DailyKos. I suspect it’s because DailyKos is a liberal blog and doesn’t agree with John’s values. So I should immediately point out that these are simply blogs that I, as a person, enjoy reading and has nothing to do with the editorial direction or scope at SQL Server Magazine. I also firmly believe that blogs, in general, are not sources of information rather they are sources of opinion. Therefore, if you don’t like the opinions coming from a blog, then you can certainly ignore it. Otoh, I also read the blogs at the Economist.com on a regular basis, and is a much more conservative news outlet (politically, not socially conservative) than many other such as FoxNews. In my case, I like to see opinions from a wide spectrum of smart people. Consequently, I read what they have to say - every one from G. Gordon Liddy to Arianna Huffington. However, I’ve rarely seen a political blog that generates news - they simply editorialize on news that is reported by other reputable news agencies. But, again, this is just my reading tastes and does not reflect, in any way on SQL Server Magazine’s opinion or editorial direction. -Kev]]>KEVINTue, 15 Apr 2008 13:14:35 GMThttp://www.windowsitpro.com/article/sql-server/march-omnibus#commentsAnchorhttp://www.windowsitpro.com/article/performance/sqlquerystress#commentsAnchorThu, 03 Apr 2008 17:45:44 GMT
This is greate tool. I was looking for something to stress test queries.]]>FarhadThu, 03 Apr 2008 17:45:44 GMThttp://www.windowsitpro.com/article/performance/sqlquerystress#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/march-omnibus#commentsAnchorWed, 02 Apr 2008 10:39:11 GMT
The non-SQL Server links at the end of the column are of no use. For the record I think kos is a horrid source of information. I hope this is not a portent of things to come with SQL Server Magazine.]]>JOHNWed, 02 Apr 2008 10:39:11 GMThttp://www.windowsitpro.com/article/sql-server/march-omnibus#commentsAnchorhttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorMon, 31 Mar 2008 18:03:08 GMT
The download link for the SQL Server 2005 Performance Dashboard Reports is now correct and working. Thanks for alerting us to the error!]]>AnneMon, 31 Mar 2008 18:03:08 GMThttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorhttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorMon, 24 Mar 2008 10:01:21 GMT
I’ll ask Kevin if he has an updated link for the Peformance Dashboard Reports.]]>AnneMon, 24 Mar 2008 10:01:21 GMThttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorhttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorTue, 18 Mar 2008 16:23:20 GMT
The link on how to get the code dies on Microsoft’s site. Have they moved it?]]>MichaelTue, 18 Mar 2008 16:23:20 GMThttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/march-omnibus#commentsAnchorTue, 18 Mar 2008 11:33:12 GMT
Glad to see you’ve got Dailykos on your list! I’ve been following the site for a couple years, and I think it’s a great source of information on the economy and progressive politics.]]>AnneTue, 18 Mar 2008 11:33:12 GMThttp://www.windowsitpro.com/article/sql-server/march-omnibus#commentsAnchorhttp://www.windowsitpro.com/article/performance/sqlquerystress#commentsAnchorFri, 14 Mar 2008 12:12:56 GMT
Casey, thanks for the kind words! We editors are always happy to hear when a reader like you has found useful information in SQL Server Magazine. Please let us know if there are any other topics you’d like to see covered. Anne Grubb, Web strategic editor, SQL Server Magazine and Windows IT Pro, agrubb@windowsitpro.com]]>AnneFri, 14 Mar 2008 12:12:56 GMThttp://www.windowsitpro.com/article/performance/sqlquerystress#commentsAnchorhttp://www.windowsitpro.com/article/performance/sqlquerystress#commentsAnchorThu, 13 Mar 2008 17:37:39 GMT
This is a tool that I will definitely use!!! I am currently troubleshooting a database that runs fine except for during high volume month-end processing. So, I have been looking for a way to emulate the load that it receives at peek times. This article alone more than pays for my subscription to SQL Server Magazine. Thank you!!! Casey M. Evans California Highway Patrol SQL Server DBA]]>caevans@chp.ca.gov Thu, 13 Mar 2008 17:37:39 GMThttp://www.windowsitpro.com/article/performance/sqlquerystress#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/sqlping#commentsAnchorMon, 04 Feb 2008 22:09:39 GMT
Could be useful if I could only figure out how to create the IP List.]]>GlennMon, 04 Feb 2008 22:09:39 GMThttp://www.windowsitpro.com/article/sql-server-2000/sqlping#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorTue, 29 Jan 2008 11:03:58 GMT
In 26 years of writing professionaly, I’ve been plagiarized a couple of times (at least, that I’m aware of). After the initial disbelief wore off, I was just angry (not flattered!). Although on the magazine we’re diligent about checking authors and their sources, we’ve had a few instances of plagiarism occur--fortunately, it doesn’t happen often. But I also believe, as you do, that most professionals have enough integrity to avoid the temptation of lifting another’s work.]]>AnneTue, 29 Jan 2008 11:03:58 GMThttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorThu, 10 Jan 2008 14:27:54 GMT
Plagarism is the sincerest form of flatery. That is right up until the time they benefit or profit from all you hard work.]]>VictorThu, 10 Jan 2008 14:27:54 GMThttp://www.windowsitpro.com/article/sql-server/plagiarism#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/soliciting-feedback-for-the-3rd-edition-of-sql-in-a-nutshell-#commentsAnchorTue, 04 Dec 2007 14:07:06 GMT
Actually I’m seeing more interest in PostgreSQL as people are outgrowing MySQL. I recently listened to a podcast with one of the main contributors to it and was very excited by all the advantages (eg. running Perl inside the database engine). I realize the amount of work this must entail, but you book, being as popular as I’m sure it is, will not only satisfy the market of existing users, but I’m sure encourage others to take a fresh look at this database that they used to think was perhaps only for academicians.]]>ChristopherTue, 04 Dec 2007 14:07:06 GMThttp://www.windowsitpro.com/article/sql-server/soliciting-feedback-for-the-3rd-edition-of-sql-in-a-nutshell-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/denis-bauer-s-clr-reflector#commentsAnchorWed, 07 Nov 2007 08:29:35 GMT
Very nice!]]>ianWed, 07 Nov 2007 08:29:35 GMThttp://www.windowsitpro.com/article/sql-server/denis-bauer-s-clr-reflector#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/raid6-on-sql-server-#commentsAnchorWed, 31 Oct 2007 12:52:11 GMT
Hi Sean, I have done considerable testing of RAID5 compared to RAID1 and RAID10. Since RAID5 is similar to RAID6, you might be interested in the results. On TPC-C tests scaling to 3000 concurrent users, RAID1 was 310% faster and RAID10 was 319%. These are, imo, rather significant performance gains. I have to say that I was expecting in the range of 30-50% better performance. A 3X performance improvement was very surprising to me. This and other findings were documented in an article published by SQL Server Magazine called "Bare Metal Tuning". Sorry, but I don’t have the article ID number handy. Hope this helps, -Kev]]>KEVINWed, 31 Oct 2007 12:52:11 GMThttp://www.windowsitpro.com/article/sql-server/raid6-on-sql-server-#commentsAnchorhttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorTue, 30 Oct 2007 08:27:08 GMT
Not able to get to the link, nor do can I search for it on MS site. Anyone else having this problem?]]>RODOLFOTue, 30 Oct 2007 08:27:08 GMThttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/raid6-on-sql-server-#commentsAnchorFri, 19 Oct 2007 08:12:21 GMT
I am using Raid 6 with great performance on a mission critical system and did have a situation with two disk failures. If you are going to make statements like you did above, please back them up with performance data.]]>SeanFri, 19 Oct 2007 08:12:21 GMThttp://www.windowsitpro.com/article/sql-server/raid6-on-sql-server-#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorThu, 11 Oct 2007 13:01:07 GMT
Please contact Customer Service at 800-793-5697 8-5 MDT or email sglmag@penton.com if you can not access the download. Thank you, Customer Service/SQL Server Magazine]]>riehl Thu, 11 Oct 2007 13:01:07 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorMon, 17 Sep 2007 06:16:21 GMT
Just what I needed, and when I needed it! Thanks, David.]]>DavidMon, 17 Sep 2007 06:16:21 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/multiserver-management#commentsAnchorMon, 10 Sep 2007 09:01:32 GMT
Hi Kevin -- I realize this is an older post but thought I’d respond to you. Our organization uses multi-server admin (Master-Target) in both SQL 2000 & 2005 for our backups, maintenance, Disaster Recovery, replication audits and email alerts related to these processes. It is easy to set up, easy to manage (in scripts and via EM), and has reduced our work monitoring and managing standard DBA jobs. Our enterprise has ~ 170 SQL instances (and growing) with ~ 2000 DBs taking up ~ 16 terabytes space. I was hunting for information related to a new error we are getting in SQL 2005 related to the MSX Operator when I came across your post. Mary]]>MARYMon, 10 Sep 2007 09:01:32 GMThttp://www.windowsitpro.com/article/sql-server/multiserver-management#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorThu, 06 Sep 2007 12:56:15 GMT
Hi- I’m trying to reach Kevin to get a copy of the post so I can fix this. He’s on the road alot so have patience. I should hear from him tomorrow. ~ Diana May]]>DianaThu, 06 Sep 2007 12:56:15 GMThttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorWed, 29 Aug 2007 10:54:16 GMT
Any news with the blog entry? I’m trying to find an easy way to determine if the box is multicore or hyperthreading. Thanks.]]>JASONWed, 29 Aug 2007 10:54:16 GMThttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorTue, 28 Aug 2007 10:04:19 GMT
I believe the link is working now. Sorry for the inconvenience.]]>GayleTue, 28 Aug 2007 10:04:19 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorMon, 27 Aug 2007 17:37:30 GMT
Unfortunately download page not found - could you please check dowload location Thank]]>ChungMon, 27 Aug 2007 17:37:30 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorMon, 27 Aug 2007 07:54:43 GMT
Sounds interesting - but the download link doesn’t work.]]>TIMMon, 27 Aug 2007 07:54:43 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorSun, 26 Aug 2007 22:24:52 GMT
Link is broken]]>MichaelSun, 26 Aug 2007 22:24:52 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorSun, 26 Aug 2007 22:02:13 GMT
Download link is not working.]]>manishSun, 26 Aug 2007 22:02:13 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorSun, 26 Aug 2007 13:48:15 GMT
Link is NFG.]]>DexterSun, 26 Aug 2007 13:48:15 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorSat, 25 Aug 2007 19:47:15 GMT
great find, but the url to actually download the scripts does not work for me.]]>JimSat, 25 Aug 2007 19:47:15 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorSat, 25 Aug 2007 01:51:41 GMT
The article would be better if I could download the scripts. Please fix link.]]>ToniSat, 25 Aug 2007 01:51:41 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorFri, 24 Aug 2007 14:37:08 GMT
There seems to be a problem with the blog posting. We’re working on this. Thanks Diana May Technical Editor SQL Server Magazine]]>DianaFri, 24 Aug 2007 14:37:08 GMThttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorFri, 24 Aug 2007 06:23:29 GMT
Heads up.. These install scripts are hard coded to install from c:\ so either modify the scripts to your install path or make sure you unzip the scripts into c:\AITScripts before trying.. Good Luck..]]>JASONFri, 24 Aug 2007 06:23:29 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorWed, 22 Aug 2007 15:49:46 GMT
This link does not work :( Please, fix it!]]>ElzbietaWed, 22 Aug 2007 15:49:46 GMThttp://www.windowsitpro.com/article/query-analyser/sql-server-automation-scripts#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorTue, 21 Aug 2007 15:51:25 GMT
Hi Kevin, where is the actual blog on this topic? I’m trying to figure out an easy way to determine if our processors on our DB servers are duo core or not. Thanks.]]>GLENTue, 21 Aug 2007 15:51:25 GMThttp://www.windowsitpro.com/article/sql-server/determining-sql-server-cores-cpus-and-hyperthreading#commentsAnchorhttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchorFri, 17 Aug 2007 13:28:05 GMT
Invalid link in "HOW TO GET IT" section... should be http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&DisplayLang=en]]>JEFFFri, 17 Aug 2007 13:28:05 GMThttp://www.windowsitpro.com/article/reporting2/sql-server-2005-performance-dashboard-reports#commentsAnchor