July 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our July top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):

1

Announcing the JDBC Driver 7.0 RTW!

We are pleased to announce the production release of the Microsoft JDBC Driver 7.0 for SQL Server! The 7.0 Release To World (RTW) includes the following items since the previous RTW release: Added Added new connection property “useBulkCopyForBatchInsert” to enable Bulk Copy API support for batch insert operation (Azure SQL Data Warehouse specific) #686 Added setUseBulkCopyForBatchInsert()…


Konference SQL Server Bootcamp 2018, Brno

Zajímá vás, jak SQL Server využít naplno a jak jeho méně známé funkce můžete prakticky využít ve vlastních aplikacích? Brněnská pobočka Windows User Group připravila dvoudenní bezplatnou vzdělávací konferenci SQL Server Bootcamp 2018. Akce je určena pro databázové vývojáře, administrátory i BI specialisty. Na prakticky orientovaných přednáškách předních českých odborníků na SQL Server seznámit nejen s…


Use the Maintenance Plan Wizard (使用維護計畫精靈)

Use the Maintenance Plan Wizard (使用維護計畫精靈) 1.使用SSMS連線到SQL Server,在SQL Server Instance>管理>維護計畫,按下右鍵,選擇[維護計畫精靈] 2.設定排程,建議在離峰時間執行,例如01:00,最少可以每周執行一次。   3.選擇需要定期執行的工作 如果您選擇了[重建索引],就不需要勾選[更新統計資料],因為REBUILD(重建索引)會一併更新統計資料   4.針對上一個步驟所選擇的項目,勾選您的資料庫 以下是[重建索引工作] 以下是[更新統計資料工作]     Reference: Use the Maintenance Plan Wizard (使用維護計畫精靈) https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/use-the-maintenance-plan-wizard?view=sql-server-2017  


The SQL Server Defensive Dozen Part 2 – SQL Server Encryption, Key Management, And Data-At-Rest Encryption

Introduction In order to properly secure and harden SQL Server, the use of encryption provides many benefits including safeguarding data, separation of duties, and satisfying regulatory needs such as the Secure Technical Implementation Guide (STIG) or General Data Protection Regulation (GDPR). Within SQL Server there are several types of encryption: Channel encryption (encrypting login/data packets…

1

June 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our June top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):


Early technical preview of JDBC 6.5.4 for SQL Server released

We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added new connection property “useBulkCopyForBatchInsert” to enable Bulk Copy API support for batch…


SQL Updates Newsletter – June 2018

Recent Releases and Announcements Cumulative Update #8 for SQL Server 2017 RTM https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-8-for-sql-server-2017-rtm/ Cumulative Update #12 for SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-12-for-sql-server-2014-sp2/ Microsoft releases the latest update of Analytics Platform System Microsoft is pleased to announce that the Analytics Platform System (APS) appliance update 7 (AU7) is now generally available. APS is Microsoft’s scale-out Massively…


Friday Five: A Bot For Smart Homes, Windows 10 IoT Core, And More!

Complex Joins .NET Core 2.0 Entity Framework And SQL Server Oscar Garcia is a Principal Software Architect who resides in Sunny South Florida. He is a Microsoft MVP and certified solutions developer with many years of experience building solutions using .Net framework and multiple open source frameworks. Currently, he specializes in building solutions using technologies…


[SQL Server AlwaysOn AG] Required Synchronized Secondaries To Commit

O SQL Server 2017 trouxe uma novidade interessante para o AlwaysOn Availability Groups (AG); hoje vamos falar sobre a opção: Required_Synchronized_Secondaries_To_Commit. Pra entender o papel desta nova opção é importante entender como o AG se comporta quando está configurado para operar no modo síncrono. Para facilitar a nossa “prosa” vamos considerar que temos um AG…