Browse by Tags
SQL Server - Best Practices
Microsoft did some updated of there SQL TechNet site: SQL Server - Best Practices SQL Server Best Practices Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. These SQL Server best practices draw on the extensive experience and expertise from respected developers and engineers at Microsoft, who walk you through the specifics...
System Center Configuration Management with Remote SQL installations
So, for the ones that want to install System Center Configuration Management with a Remote SQL box...here are some things you HAVE to consider when installing Config Manager along with a Remote SQL server. You will get to the following error: Setup Fails to Install SMS Provider Components When using the Configuration Manager Setup Wizard to install a sccmshortname primary site, setup may fail when...
The blog comments now work with all browsers on all the myITforum.com blogs
Ladies and Gentlemen of all ages… The blog comments now work with all browsers on all the myITforum.com blogs.
Did you miss myITforum.com?
Michael Wood seems to have really missed myITforum.com. Now, sit back and enjoy the show, because myITforum.com, Inc. is going… Ha!! Sorry, can’t let the cat out yet. I’ll just say, Rod has some BIG plans for myITforum.com, Inc.
Eileen Brown posted Technet MOM and SMS Webcast list
MOM & SMS Webcasts for December Microsoft Webcast: Disk-to-Disk-to-Tape Backup with Data Protection Manager and CommVault Thursday, December 08, 2005 - 11:00 AM - 12:00 PM Pacific Time Randy De Meno, Director of Advanced Applications & Microsoft Partnership, CommVault Microsoft System Center Data Protection Manager (DPM) 2006 is a server software application designed from the ground up to optimize...
TechNet and MSDN virtual labs running on Virtual Server 2005 R2
Microsoft just re-launched the TechNet and MSDN virtual labs running on Virtual Server 2005 R2.
Writing SQL Queries: Let's Start with the Basics
SQL Server Developer Center: Writing SQL Queries: Let's Start with the Basics This is a nice introduction to writing SQL queries written by Jackie Goldstein. Summary: Learn to be more productive with SQL Server 2005 Express Edition with this quick introduction to the T-SQL language and the basics of getting information from the database using the SELECT statement.
Microsoft Express Edition products and website
Microsoft Express Edition products and website Questions about Express Downloads: Visual Basic 2005 Express Edition Visual C# 2005 Express Edition Visual C++ 2005 Express Edition Visual J# 2005 Express Edition Visual Web Developer 2005 Express Edition SQL Server 2005 Express Edition Below you will find some of the questions and answers from the FAQ pages What are the Express Editions? The Express Editions...
Microsoft SQL Server: SQL Server 2005 Features Comparison
Microsoft SQL Server: SQL Server 2005 Features Comparison Microsoft has redesigned the SQL Server 2005 product family to better meet the needs of each customer segment with four new editions: Express, Workgroup, Standard, and Enterprise. So which one do you need to buy?
Free Microsoft Support
The Industry Insiders : Free Microsoft Support Free Microsoft Support Blake Handler has posted a HUGE list of resources for Free Microsoft Support. Thanks Blake!!
Upgrading to SQL Server 2005
Barnaby_Jeans has a great post on Upgrading to SQL Server 2005 Upgrading to SQL Server 2005 If you are currently working with SQL Server 7 or SQL Server 2000, you may be asking yourself what you need to know in order to upgrade to SQL Server 2005 once it launches. The TechNet team has put together an audiocast that talks about upgrading to SQL Server 2005. These audiocasts are a great way to learn...
More on Stored Procedures, Bad?
Louis Davidson writes on his The SQL Doctor is In (Real In) blog site about the article link I posted about Stored Procedures being a bad thing. Louis does a great job conviencing me his points about Stored Procedures are not a bad thing, but bad programming makes a huge difference. So, you can have the best of both worlds. If you are a die-hard Stored Procedures person, then by all means use them...
Dynamic SQL
http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx Great Article by Frans Bouma (Microsoft MVP - C#)
Microsoft SQL Server 2000 Service Pack 4
Microsoft SQL Server 2000 Service Pack 4 Download SQL Server 2000 Service Pack 4 (SP4), the latest and most comprehensive update to SQL Server 2000. Source: http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en
The SQL Server Best Practices Analyzer
Do you not have a full-time DBA to keep Microsoft SQL Server databases running according to industry standards and best practices? Sometimes even DBAs want to test their SQL Servers against various best practices. In the past, you would have to tweak your SQL Server settings manually to find the ideal configuration. Now, Microsoft has released a tool called the Microsoft SQL Server Best Practices Analyzer...
Code Repository - We want your scripts
We are working on releasing a myITforum Code Pack, containing all the great scripts from the myITforum group. In order to try to collect as many scripts as possible, we will be giving away 1 copy of Windows 2003 Server to each of the two top donators of files . The scripts must be ones that were not included in any of the Code Repository Code Packs or the Original Database. The scripts can be any of...
MMS - Code Repository
Just got confirmation on the time of this presentation. Dan Thomson and I will be presenting on April 20, 2005 (Wednesday) at 4:00 - 5:15 PM http://www.myitforum.com/blog/rcrumbaker/archive/2005/01/31/2823.aspx
New KBs - SMS 2.0 and SMS 2003
Systems Management Server 2.0 892937 Systems Management Server deployment packages are available that include security update MS05-014 for Internet Explorer 6 Service Pack 1 894154 How to obtain and use the February 2005 Security Update Scan Tool in environments that use Systems Management Server 2003 and Systems Management Server 2.0 Systems Management Server 2003 838891 You may receive status message...
New KB - SQL 891311
SQL Server 2000 891311 FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log
Code Repository call for Code Pack Scripts
We (Dan Thomson and I) are wanting to gather up some more code so we can release another Code Pack for the Code Repository. http://www.myitforum.com/blog/rcrumbaker/archive/2004/12/01/178.aspx - Code Repository Links We are wanting to collect as many scripts as possible so we can get them included in our next Code Packs. If you are willing to share any of your bat, cmd, hta, html, ipf, js, jse, kix...
New KB - SQL 2000 KB-260249
SQL Server 2000 260249 DSN network library shown as "Other" in ODBC Administrator
