Future Technology: The Mactini

Or what do you think?

 

I wish you a nice day,
tosc

Backup, Integrity Check and Index Optimization - CTP

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization  (Best Free Tool - Gold)
scripts, a solution based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.

He makes some interessting Updates for us - in his new CTP version of IndexOptimize!

  • UPDATE 05 Dec 2010 - New CTP version of IndexOptimize with the following changes.

    Support for updating of statistics with the option RESAMPLE. Set @StatisticsResample = 'Y' to use this option. - Thanks Ola  :-))
    Update statistics using NORECOMPUTE on statistics that has auto update statistics disabled.
    Only query sys.dm_db_index_physical_stats to check the fragmantation if it's needed to decide what action that should be performed.
    Support for only updating statistics when the data has been modified. Set @OnlyModifiedStatistics = 'Y' to use this option.
  • UPDATE 01 Dec 2010 - The most requested feature in IndexOptimize for a long time has been support for updating of column statistics. I now have a CTP version with this feature. Here's an example of how you can rebuild or reorganize indexes with fragmentation and at the same time update the statistics. As you can see the new parameter is @UpdateColumnStatistics.

    EXECUTE dbo.IndexOptimize
    @Databases = 'USER_DATABASES',
    @FragmentationHigh_LOB = 'INDEX_REBUILD_OFFLINE',
    @FragmentationHigh_NonLOB = 'INDEX_REBUILD_ONLINE',
    @FragmentationMedium_LOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE',
    @FragmentationMedium_NonLOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE',
    @FragmentationLow_LOB = 'STATISTICS_UPDATE',
    @FragmentationLow_NonLOB = 'STATISTICS_UPDATE',
    @UpdateColumnStatistics = 'Y'

Please feel free to contact him if you have any questions.

I wish you a nice  day,
tosc

Microsoft Driver for PHP for SQL Server 2.0.1

The Microsoft Drivers for PHP for SQL Server provide connectivity to Microsoft SQL Server from PHP applications. In addition to some important bug fixes for the existing SQLSRV driver, version 2.0 release adds support for PDO with a new PDO_SQLSRV driver.

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=80e44913-24b4-4113-8807-caae6cf2ca05

And here some more informations:
http://blogs.msdn.com/b/sqlphp/archive/2010/11/30/update-release-of-the-microsoft-drivers-for-php-for-sql-server.aspx

I wish you a nice day,
tosc

Best Free Tool - a Community Choice!

SQL Server Magazine (www.sqlmag.com)  has published the Community Choice and Editors Best Awards for 2010.
I'm happy to see two tools which I'm posting about!

Community Choice
GoldSQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization by Ola Hallengren • ola.hallengren.com

Editors' Best
Silver:
SSMS Tools Pack 1.9 • Mladen Prajdiæ (Blog | Twitter)• www.ssmstoolspack.com
Bronze: SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization by Ola Hallengren • ola.hallengren.com

So to  you both - CHEERS! Honor to whom honor is due.

I wish you a nice day,

tosc

HOW IT WORKS: IO Affinity Mask - Should I Use It?

Link: http://blogs.msdn.com/b/psssql/archive/2010/11/19/how-it-works-io-affinity-mask-should-i-use-it.aspx

I think a good explanation of IO Affinity! :-)

I wish you a nice day,

tosc

#CU package 11 for SQL Server 2008 Service Pack 1

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

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

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/

 And if you are  a little  bit  confused about this CU 11 which isn't a fix of #CU package 1 for SQL Server 2008 Service Pack 2  -  you know what I mean - then read the comment of  Aaron Bertrand :-)

I wish you all a nice "supported" day,

CU
tosc

#CU package 1 for SQL Server 2008 Service Pack 2

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

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

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

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

CU
tosc

Microsoft code-named “Atlanta”

 What is Microsoft code-named "Atlanta?"

Microsoft code-named "Atlanta" is a configuration assessment cloud service helping enable DBAs to proactively avoid configuration problems. Additionally, Atlanta will provide best practice guidance and help you to more rapidly resolve identified issues through step-by step-guidance and the ability for Microsoft support professionals to access the most up-to-date configuration data for their deployment.

This secure cloud service will help DBAs to:

  • Proactively avoid problems with Microsoft SQL Server through ongoing monitoring and alerting of configuration from the cloud

  • Reduce downtime and improve performance of Microsoft SQL Server through proactive scanning for known configuration issues and comparison with best practices

  • Resolve issues faster by providing Microsoft, or your own support staff, the ability to get a current view of your configuration, changes that have been made, and use the most up to date solutions to solve them

So let us take a look to the beta!

http://www.microsoftatlanta.com/

I wish you a nice day,

tosc

I want some Moore - SSMS Tools Pack 1.9.3.0 by Mladen Prajdić

SSMS Tools Pack is an very exciting Add-In (Add-On) for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2 and respective Microsoft SQL Server Management Studio Express Versions. This tool is developed by Mladen Prajdić (Blog | Twitter).

Mladen Prajdić is an SQL Server MVP and C# developer!
This release adds a great new feature and fixes a few bugs.

"The new feature called Window Content History saves the whole text in all all opened SQL windows every N minutes with the default being 30 minutes. This feature fixes the shortcoming of the Query Execution History which is saved only when the query is run. If you're working on a large script and never execute it, the existing Query Execution History wouldn't save it. By contrast the Window Content History saves everything in a .sql file so you can even open it in your SSMS. The Query Execution History and Window Content History files are correlated by the same directory and file name so when you search through the Query Execution History you get to see the whole saved Window Content History for that query. Because Window Content History saves data in simple searchable .sql files there isn't a special search editor built in. It is turned ON by default but despite the built in optimizations for space minimization, be careful to not let it fill your disk. You can see how it looks in the pictures in the feature list. "

The fixed bugs are:

  • SSMS 2008 R2 slowness reported by few people.
  • An object explorer context menu bug where it showed multiple SSMS Tools entries and showed wrong entries for a node.
  • A datagrid bug in SQL snippets.
  • Ability to read illegal XML characters from log files.
  • Fixed the upper limit bug of a saved history text to 5 MB.
  • A bug when searching through result sets prevents search.
  • A bug with Text formatting erroring out for certain scripts.
  • A bug with finding servers where it would return null even though servers existed.
  • Run custom scripts objects had a bug where |SchemaName| didn't display the correct table schema for columns. This is fixed. Also |NodeName| and |ObjectName| values now show the same thing.

So, take a look - and feel free :-)

http://www.ssmstoolspack.com

I wish you all  a nice day,

tosc

 

SQL Server 2005 Service Pack 4 CTP available

A long time ago <<< Service Pack SQL Server 2008 SP2 and SQL Server 2005 SP4 - Based on feedback from the community !!! >>>

Customer Technology Preview (CTP) for Microsoft SQL Server 2005 Service Pack 4 is available for download!

SQL Server 2005 Service Pack 4 CTP 1 includes:

  • All hotfixes released up to Microsoft SQL Server 2005 SP3 Cumulative Update 1 to 11

List of the bugs that are fixed in SQL Server 2005 Service Pack 4 CTP

So, take a look - but make sure IT'S ONLY FOR TESTING!!!

Microsoft SQL Server 2005 Service Pack 4 CTP
Microsoft SQL Server 2005 Express Edition Service Pack 4 CTP

I wish you all a nice day,
tosc

« 1 2 3 4 5 6 7 8 9 10 11 ... 24 »