Torsten Schuessler http://www.insidesql.org/blogs/tosc/ Torsten Schuessler's SQL-Blog aka tosc en-EU http://blogs.law.harvard.edu/tech/rss 60 DBSave SQL Server Backup von DD-MEDSOFT http://www.insidesql.org/blogs/tosc/2010/08/20/dbsave-sql-server-backup-von-dd-medsoft Fri, 20 Aug 2010 09:21:01 +0000 Torsten Schüßler * SQL Software 1008@http://www.insidesql.org/blogs/ <h1>DBSave SQL Server Backup</h1> <div class="image_block"><a href="/blogs/media/blogs/tosc/DBsave/DBSave_logo_transparent.png"><img src="/blogs/media/blogs/tosc/DBsave/DBSave_logo_transparent.png" alt="" width="190" height="133" /></a></div> <p><a title="DBSave SQL Server Backup - Features!" href="http://www.sql-server-backup.de/de/versionen/features.aspx" target="_blank">DBSave</a> von <a title="DD-MEDSOFT" href="http://www.sql-server-backup.de" target="_blank">DD-MEDSOFT </a>ist eine auf dem NET Framework basierende BACKUP-L&#246;sung zur Sicherung und Wiederherstellung von bis zu 4 Microsoft SQL Server Instanzen. Es werden alle &#160;<a title="SQL Server" href="http://www.microsoft.com/germany/sql">MS SQL Server </a>&#160;Versionen unterst&#252;tzt - einschlie&#223;lich MSDE- u. Expresseditionen. &#160;Die Installation ist zu folgenden Betriebssystemen kompatibel: &#160;&#160;Windows XP, VISTA, Windows 7, Windows Server 2003, Windows Server 2008.</p> <p><a href="http://www.insidesql.org/blogs/tosc/2010/08/20/dbsave-sql-server-backup-von-dd-medsoft#more1008">Read more &raquo;</a><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div> DBSave SQL Server Backup

DBSave von DD-MEDSOFT ist eine auf dem NET Framework basierende BACKUP-Lösung zur Sicherung und Wiederherstellung von bis zu 4 Microsoft SQL Server Instanzen. Es werden alle  MS SQL Server  Versionen unterstützt - einschließlich MSDE- u. Expresseditionen.  Die Installation ist zu folgenden Betriebssystemen kompatibel:   Windows XP, VISTA, Windows 7, Windows Server 2003, Windows Server 2008.

Read more »


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/08/20/dbsave-sql-server-backup-von-dd-medsoft#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=1008 Backup, Integrity Check and Index Optimization http://www.insidesql.org/blogs/tosc/2010/08/18/backup-integrity-check-and-index-optimization-1 Wed, 18 Aug 2010 14:54:04 +0000 Torsten Schüßler * SQL SQL-Server 2005 SQL-Server 2008 Tools SQL Server 2008 R2 647@http://www.insidesql.org/blogs/ <!-- sphereit start --> <p><a href="http://ola.hallengren.com/" target="_blank">Ola Hallengren</a> and his ongoing work of his <a href="http://ola.hallengren.com/" target="_blank">SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization</a> scripts - makes me happy :-)</p> <p>He made some important updates to his maintenance scripts:</p> <ul> <li>Support for selection of schemas, objects and indexes. You can select individual or lists of schemas, objects or indexes, use exclusions or use wild-cards. See the documentation for details about how it can be used.</li> </ul> <p><p>It works like this:<br />All indexes on the Production.Product table in the AdventureWorks database.<br /><code class="codespan">@Indexes = 'AdventureWorks.Production.Product'</code> <br /><br /></p><a href="http://www.insidesql.org/blogs/tosc/2010/08/18/backup-integrity-check-and-index-optimization-1#more647">Read more &raquo;</a><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div>

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-)

He made some important updates to his maintenance scripts:

  • Support for selection of schemas, objects and indexes. You can select individual or lists of schemas, objects or indexes, use exclusions or use wild-cards. See the documentation for details about how it can be used.

It works like this:
All indexes on the Production.Product table in the AdventureWorks database.
@Indexes = 'AdventureWorks.Production.Product'

Read more »

Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/08/18/backup-integrity-check-and-index-optimization-1#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=647 #CU 11 for SQL Server 2005 Service Pack 3 http://www.insidesql.org/blogs/tosc/2010/08/18/cu-11-for-sql-server-2005-service-pack-3 Wed, 18 Aug 2010 08:11:45 +0000 Torsten Schüßler SQL-Server 2005 963@http://www.insidesql.org/blogs/ <!-- sphereit start --> <p>The Cumulative update package 11 for SQL Server 2005 Service Pack 3 (<strong>Build 9.00.4309</strong>) is available at:</p> <p><a href="http://support.microsoft.com/kb/2258854" target="_blank">http://support.microsoft.com/kb/2258854</a></p> <p>And here you can get the whole information of builds that were released after SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released: <a href="http://support.microsoft.com/kb/960598/" target="_blank">http://support.microsoft.com/kb/960598/</a><br /><a href="http://support.microsoft.com/kb/981355/" target="_blank"></a></p> <p>CU<br /><a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div>

The Cumulative update package 11 for SQL Server 2005 Service Pack 3 (Build 9.00.4309) is available at:

http://support.microsoft.com/kb/2258854

And here you can get the whole information of builds that were released after SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released: http://support.microsoft.com/kb/960598/

CU
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/08/18/cu-11-for-sql-server-2005-service-pack-3#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=963 Migrate from MySQL to SQL Azure or SQL Server http://www.insidesql.org/blogs/tosc/2010/08/13/migrate-from-mysql-to-sql-azure-or-sql-server Fri, 13 Aug 2010 06:55:19 +0000 Torsten Schüßler SQL-Server 2005 SQL-Server 2008 Tools SQL Server 2008 R2 SQL Azure 777@http://www.insidesql.org/blogs/ <!-- sphereit start --><p><a href="http://blogs.technet.com/b/dataplatforminsider/" target="_blank">Microsoft</a> announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL!<br />Download: <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=69739c8c-ac82-41de-b9e6-8fa5ae2594d9" target="_blank">Microsoft SQL Server Migration Assistant for MySQL v1.0</a></p> <p>I hope you know the other SSMA for Oracle/Sybase/Access ?!<br />So take a look here:</p> <p> <ul> <li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=9dfb1773-5594-44a9-869f-a891629f80a5" target="_blank">SSMA for Oracle v4.2</a></li> <li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=f39d6150-e611-46e1-84c5-0808010711c8" target="_blank">SSMA for Sybase v4.2</a></li> <li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b" target="_blank">SSMA for Access v4.2</a></li> </ul> </p><p>CU<br /><a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p> <!--tags SSMA+Migration--><!-- sphereit end --><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div>

Microsoft announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL!
Download: Microsoft SQL Server Migration Assistant for MySQL v1.0

I hope you know the other SSMA for Oracle/Sybase/Access ?!
So take a look here:

CU
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/08/13/migrate-from-mysql-to-sql-azure-or-sql-server#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=777 Microsoft Driver for PHP for SQL Server 2.0 http://www.insidesql.org/blogs/tosc/2010/08/04/microsoft-driver-for-php-for-sql-server-2 Wed, 04 Aug 2010 07:58:55 +0000 Torsten Schüßler * SQL Tools 488@http://www.insidesql.org/blogs/ <p><a href="http://blogs.technet.com/b/dataplatforminsider/archive/2010/08/05/microsoft-drivers-for-php-for-sql-server-2-0-released.aspx">http://blogs.technet.com/b/dataplatforminsider/archive/2010/08/05/microsoft-drivers-for-php-for-sql-server-2-0-released.aspx</a></p><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div> http://blogs.technet.com/b/dataplatforminsider/archive/2010/08/05/microsoft-drivers-for-php-for-sql-server-2-0-released.aspx


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/08/04/microsoft-driver-for-php-for-sql-server-2#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=488 #CU 9 for SQL Server 2008 Service Pack 1 http://www.insidesql.org/blogs/tosc/2010/07/27/cu-9-for-sql-server-2008-service-pack-1 Tue, 27 Jul 2010 07:07:57 +0000 Torsten Schüßler SQL-Server 2008 480@http://www.insidesql.org/blogs/ <!-- sphereit start --> <p>The Cumulative update package 9 for SQL Server 2008 Service Pack 1 (<strong>Build 10.00.2789.00</strong>) is available:</p> <p><a href="http://support.microsoft.com/kb/2083921/" target="_blank">http://support.microsoft.com/kb/2083921/</a></p> <p>And here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1 was released:</p> <p><a href="http://support.microsoft.com/kb/970365/en-us" target="_blank">http://support.microsoft.com/kb/970365/en-us</a></p> <p>CU<br /> <a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div>

The Cumulative update package 9 for SQL Server 2008 Service Pack 1 (Build 10.00.2789.00) is available:

http://support.microsoft.com/kb/2083921/

And here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1 was released:

http://support.microsoft.com/kb/970365/en-us

CU
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/07/27/cu-9-for-sql-server-2008-service-pack-1#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=480 Database Upgrade to SQL Server 2008 http://www.insidesql.org/blogs/tosc/2010/07/26/database-upgrade-to-sql-server-2008 Mon, 26 Jul 2010 06:39:30 +0000 Torsten Schüßler * SQL SQL-Server 2005 SQL-Server 2008 SQL Server 2008 R2 478@http://www.insidesql.org/blogs/ <!-- sphereit start --> <h3>Whitepaper at <a href="http://sqlcat.com" target="_blank">SQLCAT</a> by Dmitry Artemov: Database Upgrade to SQL Server 2008, Tools and Approaches</h3> <p>This paper documents approaches and tools that can help&#160;to upgrade of SQL Server databases from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 (or SQL Server 2008 R2!!!).</p> <p><a href="http://sqlcat.com/whitepapers/archive/2010/07/22/database-upgrade-to-sql-server-2008-tools-and-approaches.aspx" target="_blank">Database Upgrade to SQL Server 2008 Tools and Approaches</a><br />(http://sqlcat.com/whitepapers/archive/2010/07/22/database-upgrade-to-sql-server-2008-tools-and-approaches.aspx)</p> <p>Resources for Upgrading to SQL Server 2008 (<a href="http://technet.microsoft.com/en-us/library/cc936623.aspx">http://technet.microsoft.com/en-us/library/cc936623.aspx</a></p> <p>&#160;</p> <p>I wish you a nice day,<br /><a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p> <!--tags SQLCAT--><!-- sphereit end --><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div>

Whitepaper at SQLCAT by Dmitry Artemov: Database Upgrade to SQL Server 2008, Tools and Approaches

This paper documents approaches and tools that can help to upgrade of SQL Server databases from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 (or SQL Server 2008 R2!!!).

Database Upgrade to SQL Server 2008 Tools and Approaches
(http://sqlcat.com/whitepapers/archive/2010/07/22/database-upgrade-to-sql-server-2008-tools-and-approaches.aspx)

Resources for Upgrading to SQL Server 2008 (http://technet.microsoft.com/en-us/library/cc936623.aspx

 

I wish you a nice day,
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/07/26/database-upgrade-to-sql-server-2008#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=478 SQL Azure - Project "Houston" http://www.insidesql.org/blogs/tosc/2010/07/22/sql-azure-project-houston Thu, 22 Jul 2010 04:00:00 +0000 Torsten Schüßler SQL Azure 475@http://www.insidesql.org/blogs/ <p>The <a title="SQL Azure" href="http://blogs.msdn.com/sqlazure/" target="_blank">SQL Azure</a> team have just announced the <a href="http://blogs.msdn.com/b/sqlazure/archive/2010/07/21/10040258.aspx" target="_blank">CTP1 of&#160; Project Code-Named &lt;&lt;Houston&gt;&gt;</a>!</p> <p>&lt;&lt;Houston&gt;&gt; is a lightweight and easy to use database management tool for SQL Azure databases -&#160; a web based admin tool.</p> <p>CU<br /><a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div> The SQL Azure team have just announced the CTP1 of  Project Code-Named <<Houston>>!

<<Houston>> is a lightweight and easy to use database management tool for SQL Azure databases -  a web based admin tool.

CU
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/07/22/sql-azure-project-houston#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=475 SolidQ Journal http://www.insidesql.org/blogs/tosc/2010/07/20/solidq-journal Tue, 20 Jul 2010 06:49:47 +0000 Torsten Schüßler * SQL external Links 470@http://www.insidesql.org/blogs/ <p>There is a new monthly SQL Server reading material for <strong>free</strong> at <a href="http://www.solidq.com/sqj">http://www.solidq.com/sqj</a><br />So take a look and have a nice day,</p> <p>CU<br /><a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div> There is a new monthly SQL Server reading material for free at http://www.solidq.com/sqj
So take a look and have a nice day,

CU
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/07/20/solidq-journal#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=470 SQL Server 2008 SP2 CTP http://www.insidesql.org/blogs/tosc/2010/07/08/sql-server-2008-sp2-ctp Thu, 08 Jul 2010 07:09:11 +0000 Torsten Schüßler SQL-Server 2008 SQL Server 2008 R2 460@http://www.insidesql.org/blogs/ <p>At SQL Server Team Blog: &#160;<a href="http://blogs.technet.com/b/dataplatforminsider/archive/2010/07/07/sql-server-2008-sp2-ctp-is-now-available-for-public-testing.aspx" target="_self">SQL Server 2008 SP2 CTP is now available for public testing</a></p> <p>The CTP version of SQL Server 2008 Service Pack 2 (SP2)&#160;contains the cumulative updates up to SQL Server 2008 SP1 cumulative update package 8.&#160;Upgrade only for the following SQL Server 2008 editions:</p> <ul> <li>Enterprise </li> <li>Standard </li> <li>Evaluation </li> <li>Developer </li> <li>Workgroup </li> </ul> <p>Download: <a href="http://go.microsoft.com/fwlink/?LinkId=196550" target="_blank">Download SQL Server 2008 SP2 CTP</a></p> <p>And for&#160;Express Edition or Express Edition with Advanced Services: <a href="http://go.microsoft.com/fwlink/?LinkId=196551" target="_blank">SQL Server 2008 Express Edition Service Pack 2 &#8211; CTP</a></p> <p>CU<br /><a href="/search/node/type%3Aad%2Cstory%2Cdownload%2Cpage%2Curl%2Cpoll+tosc">tosc</a></p><div class="item_footer"><br /><p><em>Qui tacet, consentire videtur</em></p></div> At SQL Server Team Blog:  SQL Server 2008 SP2 CTP is now available for public testing

The CTP version of SQL Server 2008 Service Pack 2 (SP2) contains the cumulative updates up to SQL Server 2008 SP1 cumulative update package 8. Upgrade only for the following SQL Server 2008 editions:

  • Enterprise
  • Standard
  • Evaluation
  • Developer
  • Workgroup

Download: Download SQL Server 2008 SP2 CTP

And for Express Edition or Express Edition with Advanced Services: SQL Server 2008 Express Edition Service Pack 2 – CTP

CU
tosc


Qui tacet, consentire videtur

]]> http://www.insidesql.org/blogs/tosc/2010/07/08/sql-server-2008-sp2-ctp#comments http://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=460