Torsten Schuessler https://www.insidesql.org/blogs/tosc/ Torsten Schuessler's SQL-Blog aka tosc en-EU http://blogs.law.harvard.edu/tech/rss 60 I know your data needs ... https://www.insidesql.org/blogs/tosc/2017/02/16/i-know-your-data-needs Thu, 16 Feb 2017 17:01:00 +0000 tosc Miscellaneous 3892@https://www.insidesql.org/blogs/ Don't miss this one! <div class="videoblock" style="width:100%;padding-bottom:56.25%"><iframe id="ytplayer" type="text/html" src="//www.youtube.com/embed/0AxjxBKzGJM" allowfullscreen="allowfullscreen" frameborder="0"></iframe></div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2017/02/16/i-know-your-data-needs#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3892 Cumulative Update 8 for SQL Server 2012 SP2 https://www.insidesql.org/blogs/tosc/2015/09/23/cumulative_update_8_for_sql_server_2012_sp2 Wed, 23 Sep 2015 08:58:00 +0000 tosc SQL Server 3807@https://www.insidesql.org/blogs/ <div> <p>The Cumulative update package <span class="Apple-style-span">8</span> for <span class="Apple-style-span">Microsoft SQL Server 2012 Service Pack 2</span> (Build <span class="Apple-style-span">11.00.5634</span>) is available:</p> <p><a href="http://support.microsoft.com/kb/3082561/" target="_blank">Cumulative update package 8 for SQL Server 2012 SP2</a></p> <p>And very important if you are using FileTable:<br />The COD hotfix resolves an issue where you may see access violations occur when using FileTable. More details in <a href="https://support.microsoft.com/kb/3087872" target="_blank">KB #3087872</a>. </p> <p>I wish you a nice day,<br /><a href="http://feeds2.feedburner.com/TorstenSchuessler" target="_blank">tosc</a></p> <p> </p> <div class="image_block"><a href="http://feeds.feedburner.com/~r/TorstenSchuessler/~6/1" target="_blank"><img style="border: 0;" src="http://feeds.feedburner.com/TorstenSchuessler.1.gif" alt="Torsten Schuessler" /></a></div> </div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>

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

Cumulative update package 8 for SQL Server 2012 SP2

And very important if you are using FileTable:
The COD hotfix resolves an issue where you may see access violations occur when using FileTable. More details in KB #3087872. 

I wish you a nice day,
tosc

 

Torsten Schuessler

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2015/09/23/cumulative_update_8_for_sql_server_2012_sp2#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3807 Microsoft Cloud Platform Roadmap Site https://www.insidesql.org/blogs/tosc/2015/02/12/microsoft_cloud_platform_roadmap_site Thu, 12 Feb 2015 11:38:00 +0000 tosc SQL Server 3768@https://www.insidesql.org/blogs/ <div> <p>Microsoft realized the need to provide better transparency with their new release of the <a title="Cloud Platform roadmap" href="http://www.microsoft.com/en-us/server-cloud/roadmap/" target="_blank">Cloud Platform Roadmap Site</a>.</p> <p>There are roadmaps given for ...</p> <ul> <li>Cloud Infrastructure: </li> <ul> <li>Microsoft Cloud Platform System Azure G-Series VM Sizes</li> <li>Azure ExpressRoute Enhancements</li> <li>Azure Multi-NIC Virtual Machines</li> <li>Azure Network Security Groups</li> <li>Azure Site Recovery Standalone</li> </ul> <li>Enterprise mobility: </li> <ul> <li>Azure RemoteApp</li> <li>Azure Active Directory Application Proxy</li> <li>Microsoft Intune: November Service Update</li> <li>Microsoft Intune: December Service Update</li> <li>Microsoft Intune: February Service Update</li> </ul> <li>Data management and analytics: </li> <ul> <li>Azure SQL Database Latest Update</li> <li>Azure SQL Database New Service Tiers</li> <li>Azure SQL Database Auditing</li> <li>Azure Machine Learning Marketplace</li> <li>HBase for Azure HDInsight</li> <li>Cluster Customization for Azure HDInsight to include Spark, R, Solr, Giraph</li> <li>Analytics Platform System Appliance Update 3</li> </ul> <li>Application development:</li> <ul> <li>Visual Studio Community 2013</li> <li>Live Channels for Azure Media Services</li> <li>Content Protection</li> <li>Visual Studio Online: Multi Data Center Support</li> <li>Visual Studio Online: Extensibility</li> </ul> <li>Internet of Things: </li> <ul> <li>Microsoft Azure IoT Services</li> </ul> </ul> <p>Enough stuff for us all :-)<br />I prefer - at this time - <a title="Azure SQL Database Auditing" href="http://azure.microsoft.com/en-us/documentation/articles/sql-database-auditing-get-started/" target="_blank">Azure SQL Database Auditing</a>.</p> <p>I wish you a nice day,<br /><a href="http://feeds2.feedburner.com/TorstenSchuessler" target="_blank">tosc</a></p> </div> <div class="image_block"><a href="http://feeds.feedburner.com/~r/TorstenSchuessler/~6/1" target="_blank"><img style="border: 0;" src="http://feeds.feedburner.com/TorstenSchuessler.1.gif" alt="Torsten Schuessler" /></a></div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>

Microsoft realized the need to provide better transparency with their new release of the Cloud Platform Roadmap Site.

There are roadmaps given for ...

  • Cloud Infrastructure: 
    • Microsoft Cloud Platform System Azure G-Series VM Sizes
    • Azure ExpressRoute Enhancements
    • Azure Multi-NIC Virtual Machines
    • Azure Network Security Groups
    • Azure Site Recovery Standalone
  • Enterprise mobility: 
    • Azure RemoteApp
    • Azure Active Directory Application Proxy
    • Microsoft Intune: November Service Update
    • Microsoft Intune: December Service Update
    • Microsoft Intune: February Service Update
  • Data management and analytics: 
    • Azure SQL Database Latest Update
    • Azure SQL Database New Service Tiers
    • Azure SQL Database Auditing
    • Azure Machine Learning Marketplace
    • HBase for Azure HDInsight
    • Cluster Customization for Azure HDInsight to include Spark, R, Solr, Giraph
    • Analytics Platform System Appliance Update 3
  • Application development:
    • Visual Studio Community 2013
    • Live Channels for Azure Media Services
    • Content Protection
    • Visual Studio Online: Multi Data Center Support
    • Visual Studio Online: Extensibility
  • Internet of Things: 
    • Microsoft Azure IoT Services

Enough stuff for us all :-)
I prefer - at this time - Azure SQL Database Auditing.

I wish you a nice day,
tosc

Torsten Schuessler

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2015/02/12/microsoft_cloud_platform_roadmap_site#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3768 #CU package 4 for SQL Server 2012 SP2 https://www.insidesql.org/blogs/tosc/2015/01/21/cu_package_4_for_sql_server_2012_sp2 Wed, 21 Jan 2015 21:24:00 +0000 tosc SQL Server 3766@https://www.insidesql.org/blogs/ <div> <p>The Cumulative update package <span class="Apple-style-span">4</span> for <span class="Apple-style-span">Microsoft SQL Server 2012 Service Pack 2 </span>(<span class="Apple-style-span">Build 11.0.5569.0</span>) is available:</p> <p><a href="http://support.microsoft.com/kb/3007556/" target="_blank">Cumulative update package 4 for SQL Server 2012 SP2</a></p> <p>I wish you a nice day,<br /><a href="http://feeds2.feedburner.com/TorstenSchuessler" target="_blank">tosc</a></p> <p> </p> <div class="image_block"><a href="http://feeds.feedburner.com/~r/TorstenSchuessler/~6/1" target="_blank"><img style="border: 0;" src="http://feeds.feedburner.com/TorstenSchuessler.1.gif" alt="Torsten Schuessler" /></a></div> </div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>

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

Cumulative update package 4 for SQL Server 2012 SP2

I wish you a nice day,
tosc

 

Torsten Schuessler

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2015/01/21/cu_package_4_for_sql_server_2012_sp2#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3766 Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 https://www.insidesql.org/blogs/tosc/2014/09/19/recommended_updates_and_configuration_options_for_sql_server_2012_and_sql_server-2014 Fri, 19 Sep 2014 11:08:00 +0000 tosc SQL Server 3726@https://www.insidesql.org/blogs/ <div> <p><strong>Great <a title="2964518" href="http://support.microsoft.com/kb/2964518/" target="_blank">KB article</a></strong>, with a lot of helpful guidance and information about configuration settings and valuable hotfixes for <span style="color: #ff0000;">SQL Server 2012</span> and <span style="color: #ff0000;">SQL Server 2014</span> used with high-performance workloads!</p> <p><strong>Really good stuff</strong>! 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.</p> <p>It's a <span style="color: #ff0000;">must read</span>, so check it out: KB 2964518 <a href="http://support.microsoft.com/kb/2964518/" target="_blank">Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads</a>.</p> <p>I wish you a nice day and happy reading :-),<br /><a href="http://feeds2.feedburner.com/TorstenSchuessler" target="_blank">tosc</a></p> <p> </p> <div class="image_block"><a href="http://feeds.feedburner.com/~r/TorstenSchuessler/~6/1" target="_blank"><img style="border: 0;" src="http://feeds.feedburner.com/TorstenSchuessler.1.gif" alt="Torsten Schuessler" /></a></div> </div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>

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

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2014/09/19/recommended_updates_and_configuration_options_for_sql_server_2012_and_sql_server-2014#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3726 #CUs for SQL Server 2012 SP1 and SP2 https://www.insidesql.org/blogs/tosc/2014/09/17/cu_for_sql_server_2012_sp1_and_sp2 Wed, 17 Sep 2014 13:58:00 +0000 tosc SQL Server 3724@https://www.insidesql.org/blogs/ <div> <strong>SQL Server 2012 Service Pack 1 Cumulative Update #12</strong> <p>The Cumulative update package <strong>12</strong> for <strong>Microsoft SQL Server 2012 Service Pack 1</strong>(<strong>Build <span>11.0.3470.0</span></strong>) is available:</p> <p><a href="http://support.microsoft.com/kb/2991533" target="_blank">Cumulative update package 12 for SQL Server 2012 SP1</a></p> <strong>SQL Server 2012 Service Pack 2 Cumulative Update #2</strong> <p>The Cumulative update package <strong>2</strong> for <strong>Microsoft SQL Server 2012 Service Pack 2</strong>(<strong>Build <span>11.0.5548.0</span></strong>) is available:</p> <p><a href="http://support.microsoft.com/kb/2983175" target="_blank">Cumulative update package 2 for SQL Server 2012 SP2</a></p> <p>I wish you a nice day,<br /><a href="http://feeds2.feedburner.com/TorstenSchuessler" target="_blank">tosc</a></p> <p> </p> <div class="image_block"><a href="http://feeds.feedburner.com/~r/TorstenSchuessler/~6/1" target="_blank"><img style="border: 0;" src="http://feeds.feedburner.com/TorstenSchuessler.1.gif" alt="Torsten Schuessler" /></a></div> </div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div> 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

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2014/09/17/cu_for_sql_server_2012_sp1_and_sp2#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3724 #CU package 3 for SQL Server 2014 https://www.insidesql.org/blogs/tosc/2014/08/19/cu_package_3_for_sql_server-2014 Tue, 19 Aug 2014 08:18:00 +0000 tosc SQL Server 3714@https://www.insidesql.org/blogs/ <div> <p>The Cumulative update package <strong>3</strong> for <strong>Microsoft SQL Server 2014 </strong>(<strong>Build <span>12.0.2402.0</span></strong>) is available:</p> <p><a href="http://support.microsoft.com/kb/2984923" target="_blank">Cumulative update package 3 for SQL Server 2014</a></p> <p><strong>Important!</strong> This Cumulative Update includes <a href="https://technet.microsoft.com/library/security/MS14-044" target="_blank">MS14-044!!!</a> <p>I wish you a nice day,<br /><a href="http://feeds2.feedburner.com/TorstenSchuessler" target="_blank">tosc</a></p> <p> </p> <div class="image_block"><a href="http://feeds.feedburner.com/~r/TorstenSchuessler/~6/1" target="_blank"><img style="border: 0;" src="http://feeds.feedburner.com/TorstenSchuessler.1.gif" alt="Torsten Schuessler" /></a></div> </p></div><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>

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


"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2014/08/19/cu_package_3_for_sql_server-2014#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3714 PASS-Vortrag "InMemory-Speichertechnologien in SQL Server 2014" - 29.07.2014 - Nürnberg https://www.insidesql.org/blogs/tosc/2014/07/28/pass-vortrag-inmemory-speichertechnologien-in Mon, 28 Jul 2014 10:21:00 +0000 tosc Community & PASS 3703@https://www.insidesql.org/blogs/ <table style="border: #003399 0px solid;" border="0" frame="border" align="center"> <tbody> <tr> <td> <div class="image_block"><a title="PASS Deutschland e.V." href="http://www.sqlpass.de" target="_blank"><img style="vertical-align: middle;" src="/blogs/media/blogs/tosc/pass_sqlpass_de.png?mtime=1333361728" alt="www.sqlpass.de" width="98%" height="98%" /></a></div> </td> </tr> <tr> <td> <p>Hallo PASS‘ler,</p> <p class="ecxMsoNormal" align="center">hiermit möchten wir euch zum nächsten Treffen der Regionalgruppe <span>Franken in <strong>Nürnberg</strong> am <br /></span><strong><span style="color: #ff0000;">Dienstag, 29. July 2014</span><span><br /></span></strong>18:30 bis ca. 20:30<strong><span><br /></span></strong><span>zum </span><span><br />kostenlosen Vortrag</span></p> <p class="ecxMsoNormal" align="center"><strong><span>InMemory-Speichertechnologien in SQL Server 2014<br /></span></strong></p> </td> </tr> <tr> <td style="background-color: #003399;"> <p><span style="color: #ffffff;"><strong>InMemory-Speichertechnologien in SQL Server 2014</strong></span></p> </td> </tr></tbody></table><a href="https://www.insidesql.org/blogs/tosc/2014/07/28/pass-vortrag-inmemory-speichertechnologien-in#more3703">Full story &raquo;</a><div class="item_footer"><br /><p><em>"Try not to become a man of success but rather to become a man of value."</em><br />Albert Einstein</p></div>
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 »

"Try not to become a man of success but rather to become a man of value."
Albert Einstein

]]> https://www.insidesql.org/blogs/tosc/2014/07/28/pass-vortrag-inmemory-speichertechnologien-in#comments https://www.insidesql.org/blogs/tosc/?tempskin=_rss2&disp=comments&p=3703