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

PASS Deutschland e.V. Franken - Di 09.11.2010 18:30 Uhr - Einstieg in Audit Traces mit MS SQL Server und Analysis Services

Hiermit möchten wir zu unserem (kostenfreien) monatlichen Treffen der PASS Deutschland e.V., Regionalgruppe Franken, am Dienstag, den 9.11.2010 um 18:30 Uhr zum Thema "Einstieg in Audit Traces mit MS SQL Server und Analysis Services" einladen.

Das Treffen findet in den NEUEN Räumlichkeiten der Fa. New Elements statt.

WICHTIG: der "Apres-PASS" - unser Networking nach dem Vortrag beim Italiener - trägt zu der steigenden Beliebtheit unserer Treffen sicherlich bei. Also bitte genügend Zeit einplanen und den zweiten Teil nicht versäumen. Der Abend endet üblicherweise erst gegen ca. 23:30 Uhr

Gerne nehmen wir schon jetzt Eure Anmeldung entgegen!
https://www.xing.com/events/589207

Auch diesmal ist es uns gelungen, einen hochkarätigen Sprecher - diesmal aus dem Hause Datev - zu gewinnen. Er referiert zu dem Thema:

Einstieg in Audit Traces mit MS SQL Server und Analysis Services

Inhalt:

- Überblick über den Sinn und Zweck von Audit Traces
- mögliche Einsatzgebiete
- technischer Ablauf
- Routineaufgaben des Administrators und mögliche Tätigkeiten eines DB Auditors
- Änderungen an Datenbanken nachvollziehbar machen, z.B.:
- Tabellen- oder Server Traces einrichten
- mehrstufige Überwachung

Zum Einstieg in das Thema SQL Server Audits wird zunächst ein Überblick über den Sinn und Zweck vermittelt.
Anschliessend werden sowohl verschiedene Einsatzgebiete, als auch ein allgemeiner technische Ablauf vorgestellt.
Dabei werden verschiedene Routine Aufgaben des Datenbank Administrators ebenso erläutert, wie mögliche Tätigkeiten eines DB Auditors aufgezeigt.
Es gibt vielfältige Möglichkeiten, Änderungen an Datenbanken nachvollziehbar zu gestalten und z.B. Tabellen- od. Server Traces einzurichten. Die Überwachung wird dabei auf mehreren Stufen stattfinden.

Referent

Dipl. Informatiker (FH) Mark Zielke beschreibt sich selbst wie folgt: Ich bin u.a. Computer Techniker und Dipl. Informatiker (FH). Erste Kontakte mit Datenbanksystemen hatte ich unter MS-DOS mit GW-BASIC. Später habe ich mich mit dem Borland Datenbank Server Interbase bzw. Firebird beschäftigt, dabei ging es u.a. um Reparaturen von defekten Datenbanken und Entwicklung von Warenwirtschafts- bzw. ERP Lösungen.

Nach mehrjährigen Projekten mit Schwerpunkt im angelsächsischen Raum habe ich ab 2007 Gerätetreiber für Siemens entwickelt und bin aktuell seit 1,5 Jahren als externer Consultant bei der DATEV eG tätig.

Wo ?

New Elements GmbH
Thurn-und-Taxis-Straße 10
90411 Nürnberg
Google Maps: http://tinyurl.com/37by4cg

Wir bitten um eine vorherige Anmeldung via XING
https://www.xing.com/events/589207
oder per Email an: kob@sqlpass.de

Wir freuen uns auf Euch

mfg

PASS Deutschland e.V.
http://www.sqlpass.de

Regionalgruppe Franken
http://www.sqlpass.de/Regionalgruppen/Franken/tabid/71/Defau...

Paul S. Randal's Myths and Misconceptions - a Summary of Common SQL Server Myths

#CU package 12 for SQL Server 2005 Service Pack 3

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

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

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

#CU package 4 for SQL Server 2008 R2

The Cumulative update package 4 for SQL Server 2008 R2 (Build 10.50.1746.0) is available:

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

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

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

CU
tosc

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