Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014

Great KB article, with a lot of helpful guidance and information about configuration settings and valuable hotfixes for SQL Server 2012 and SQL Server 2014 used with high-performance workloads!

Really good stuff! A huge list of categorized advice for trace flags, cumulative updates, MAXDOP settings, auto update statistics threshold, database lock activity increases, ALTER INDEX…ONLINE operation, I/O heavy operations, tempdb, Out-of-memory Improvements for DBCC CHECKDB  and much MORE.

It's a must read, so check it out: KB 2964518 Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads.

I wish you a nice day and happy reading :-),
tosc

 

Torsten Schuessler

#CUs for SQL Server 2012 SP1 and SP2

SQL Server 2012 Service Pack 1 Cumulative Update #12

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

Cumulative update package 12 for SQL Server 2012 SP1

SQL Server 2012 Service Pack 2 Cumulative Update #2

The Cumulative update package 2 for Microsoft SQL Server 2012 Service Pack 2(Build 11.0.5548.0) is available:

Cumulative update package 2 for SQL Server 2012 SP2

I wish you a nice day,
tosc

Torsten Schuessler

#CU package 3 for SQL Server 2014

The Cumulative update package 3 for Microsoft SQL Server 2014 (Build 12.0.2402.0) is available:

Cumulative update package 3 for SQL Server 2014

Important! This Cumulative Update includes MS14-044!!!

I wish you a nice day,
tosc

Torsten Schuessler

PASS-Vortrag "InMemory-Speichertechnologien in SQL Server 2014" - 29.07.2014 - Nürnberg


www.sqlpass.de

Hallo PASS‘ler,

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

InMemory-Speichertechnologien in SQL Server 2014

InMemory-Speichertechnologien in SQL Server 2014

Full story »

Time to Say Thank You!

Yes, it is SysAdminDay!

July 25, 2014 14th Annual
System Administrator
Appreciation Day

You are welcome:

I wish you ALL a nice SysAdminDay!

CU
tosc 

#CU package 1 for SQL Server 2012 Service Pack 2

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

Cumulative Update 1 for SQL Server 2012 SP2

I wish you a nice day,
tosc

Torsten Schuessler

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

1 3 4 5 6 7 8 9 10 11 ... 25