Microsoft SQL Server 2012 Service Pack 2

The Service Pack 2 for Microsoft SQL Server 2012 (Build 11.0.5058) is available:

Bugs that are fixed in SQL Server 2012 Service Pack 2

Download:

Microsoft® SQL Server® 2012 Service Pack 2 (SP2)

I wish you a nice day,
tosc

Torsten Schuessler

#CU package 10 for SQL Server 2012 Service Pack 1

The Cumulative update package 10 for Microsoft SQL Server 2012 Service Pack 1 (Build 11.0.3431.0) is available:

Cumulative update package 10 for SQL Server 2012 SP 1 is available

And here you can get the whole information of builds that were released after SQL Server 2012 SP1.:

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

 

I wish you a nice day,
tosc

 

Torsten Schuessler

SQL Server 2014 has been released to manufacturing

Yesterday, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014 has been released to manufacturing and will be generally available on April 1. Quentin’s blog discussed the tremendous momentum with the SQL Server business as well as SQL Server 2014’s new in-memory OLTP technology and hybrid cloud capabilities. Additional details on those capabilities and highlights are provided by the SQL Server Blog.

I wish you a nice day,
tosc

SQL Server 2012 System Views Map

Something I forgot... we talk about, Christoph :-)

SQL Server 2012 System Views Map

The Microsoft SQL Server 2012 System Views Map shows the key system views included in Microsoft SQL Server 2012, and the relationships between them. The map is similar to the prior versions of Microsoft SQL Server System Views Maps and includes updates for the Microsoft SQL Server 2012. Note that not all possible relationships are shown.

You can download it from here!

And...

Microsoft Business Intelligence at a Glance Poster

The poster summarizes the benefits of Microsoft's BI technologies and depicts them by layer: client (such as BI in Excel), the presentation subsystem (such as SharePoint 2013), information sources (such as Reporting Services), and data sources (such as relational databases). It focuses on the enterprise architect and IT implementer audience. It includes Office 2013 client and server, SQL Server 2012 with SP1, and BI services in Windows Azure.

You can download it from here!

I wish you a nice  day,
tosc

Server 2014 – Neues für Datenbank-Entwickler und Administratoren

www.sqlpass.de

Hallo PASS‘ler,

hiermit möchten wir euch zum nächsten Treffen der Regionalgruppe Franken in Nürnberg am 
Dienstag, 21. Januar 2014
18:30 bis ca. 20:30
zum 
kostenlosen Vortrag

SQL Server 2014 – 
Neues für Datenbank-Entwickler und Administratoren
 

SQL Server 2014 - Neues für Datenbank-Entwickler und Administratoren

SQL Server 2014 bringt einige fundamentale Neuerungen mit den neuen Speichertechnologien Clustered Columnstore Indexes und In-Memory OLTP (Codename „Hekaton“).

Diese sind für sich gesehen spannend genug.

In diesem Vortrag verschaffen wir uns aber einen kompletten Überblick über die neuen Features, die der neue SQL Server mit sich bringt. (Hier gibt es eine kurze Übersicht:

www.insidesql.org/blogs/andreaswolter/2013/10/sql-server-2014-ctp2-released-download) – Der SQL Server 2014 wird übrigens auf der deutschen SQL Server Konferenz (www.sqlkonferenz.de) veröffentlicht werden – passend zur 10-Jahresfeier der PASS Deutschland e.V..

Gezeigt werden Demos und Hintergründe, wer und warum von den neuen Speicher-Engines profitieren wird; und inwiefern die anderen verbesserten und neuen Features wie Ressource Governor für IO, Buffer Pool Extension, AlwaysOn, Lock Priority Management, Partitioning & Statistics, die Performance, Verfügbarkeit und Sicherheit verbessern.

Sprecher

Andreas Wolter, ist Microsoft Certified Solutions Master (MCSM) auf SQL Server 2012 sowie MCM SQL Server 2008, und damit einer von weltweit weniger als einem Dutzend Experten weltweit, die diese höchste technische Zertifizierung von Microsoft unter (für den)SQL Server 2012 abgelegt haben. 
Dazu ist er Microsoft Certified Trainer (MCT), MCITP:DD/DA/BID, MCDBA, MCSA und kann auf über zehn Jahre Erfahrung mit SQL Server Datenbanksystemen zurückblicken. 
Mit seiner Firma SARPEDON Quality Lab (www.SarpedonQualityLab.com ) hat Andreas sich besonders auf die Entwicklung und Optimierung von Datenbank- und Datawarehouse-Architekturen spezialisiert. Dabei stehen Performance, Skalierbarkeit und vor allem auch das heiße Thema Sicherheit in seinem Fokus.  Außerdem ist er Trainer für die SQL Server Master-Classes(www.sarpedonqualitylab.com/SQL_Master-Classes.htm) und andere intensive Trainings. Sein Blog ist unter www.insidesql.org/blogs/andreaswolter zu finden.

Wir treffen uns bei

New Elements GmbH / it-schulungen.com
www.it-schulungen.com

Thurn-und-Taxis-Straße 10
(Alcatel-Lucent Gebäude im Nordostpark)
D - 90411 Nürnberg
Fon: 0911 - 65 00 83 - 25

Kostenfreie Parkplätze sind vorhanden.

Über Euer Kommen freuen wir uns sehr. Bitte teilt uns zwecks Planung der Räumlichkeiten mit, ob Ihr kommt.
Gerne könnt Ihr die Einladung an Kollegen und Mitarbeiter weitergeben.

Wir bitten um eine vorherige Anmeldung per XING www.xing.com/events/1341835 oder per Email an: mde@sqlpass.de.
Wir freuen uns auf eine rege Runde – und wer Lust hat bringt Zeit mit, den Abend gemeinsam beim Italiener ausklingen zu lassen.

Michael Deinhard und Torsten Schüßler

Kontakt

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

Regionalgruppe Franken

http://www.sqlpass.de/Regionalgruppen/Franken/


Michael Deinhard                            Torsten Schüßler

Christmas 2013 – THE DIGITAL STORY OF NATIVITY – (Christmas 2.0)

I know it's from 2012/2011/2010, but :-)

Thank you for spending your time on this blog.

SELECT LO.createdate
FROM   master.sys.syslogins LO WITH (nolock)
WHERE  lo.loginname = N'NT AUTHORITY\SYSTEM'
        OR lo.loginname = N'NT AUTHORITY\NETWORK SERVICE'; 

Do you know the result :-) 2013-12-24 00:00:00.000

May peace, prosperity, and happiness be yours throughout the holidays and new year.

  

Time to Say Thank You!

Yes, it is SysAdminDay!

July 26, 2013 14th Annual
System Administrator
Appreciation Day

You are welcome:

I wish you ALL a nice SysAdminDay!

CU
tosc 

Welcome as a Speaker for SQLSat 230 Rheinland

Yesterday, I received the "Welcome as a Speaker for SQLSat 230 Rheinland" – Mail.

BANG!

I am touched ...

We are happy to announce the schedule for SQLSaturday #230 Rheinland and welcome you as one of our selected speakers.

What an honor! I will talk about performance and manageability of tempdb, from the perspective of a database administrator.

I am happy about, that there are 3 InsideSQL’s:

Before I forget, take a closer look at Pre-Conference SQLSaturday #230 on Friday– very cheap & interesting!

Are you a photographers? Please get in touch with Dirk Hondong!

CU at SQLSaturday #230 | Rheinland!
tosc 

New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.

Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. I love this tool to perform index maintenance on instances with VLDBs - and the best it's free!

The new version supports:

  • lock timeout settings in DatabaseIntegrityCheck and IndexOptimize
  • support for indexes and statistics on objects that are created by internal SQL Server components
  • ... and so on :-)

It can be uses like this:

EXECUTE dbo.IndexOptimize @Databases = 'AdventureWorks', @LockTimeout = 600

The new version has some performance optimizations and minor bug fixes

Download: http://ola.hallengren.com/scripts/MaintenanceSolution.sql

Please feel free to contact him if you have any questions. And I tell you, Ola will consider it!!!

I wish you a nice  day,
tosc

Discrepancy by estimated TEMPDB space for CHECKDB and CHECKALLOC - WITH ESTIMATEONlY

I came around this problem (depends on SQL Server 2008 R2 jutst to SQL Server 2012) by reading Paul S. Randal's and Ana's blog posts:

DBCC CHECKDB runs CHECKALLOC, CHECKTABLE, CHECKCATALOG etc. against database, tables, views and so on. And I have learnded, however CHECKDB is executed against master database, a second CHECKDB is also running internally on the mssqlsystemressource.

So in my way, I want only make consistency check of disk space allocation by DBCC CHECKALLOC WITH ESTIMATEONLY against a ~ 200GB database, to know the estimated amount of tempdb space.

I run following DBCC command on SQL Server 2012 Enterprise Edition:

DBCC CHECKALLOC () WITH ESTIMATEONLY, TABLERESULTS;
GO

And I get this result

Estimated TEMPDB space (in KB) needed for CHECKALLOC on database XXX = 35383596.

OK, nothing special - but I thought about the posts of Ana and Paul, and a blog entry of Running SQP on SQL Server Blog - Faster DBCC CHECKDB Released in SQL 2008 R2 SP1 CU4 : Traceflag 2562 & 2549

So next shot comparing CHECKDB and CHECKALLOC:

DBCC CHECKDB WITH ESTIMATEONLY, TABLERESULTS; 
GO

DBCC CHECKALLOC WITH ESTIMATEONLY, TABLERESULTS;
GO

And the results are diffrent!
For CHECKDB:

Estimated TEMPDB space (in KB) needed for CHECKDB on database XXX = 27165.

And for CHECKALLOC:

Estimated TEMPDB space (in KB) needed for CHECKALLOC on database XXX = 35383596.

This isn't an expected result - what a discrepancy!

By the way I have made a Microsoft Connect entry: http://connect.microsoft.com/SQLServer/feedback/details/787049/discrepancy-by-estimated-tempdb-space-for-checkdb-and-checkalloc-with-estimateonly

So feel free to vote.

I wish you a nice day,
tosc

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