挨踼大福

from Pocket via IFTTT

最近有些同事因為避免 License 爭議，將 SQL Server 換成 Express 版本，但都有些使用不順的狀況.... from Pocket http://bit.ly/2UHWtuO via IFTTT

過去幾年有關注過 SymmetricDS 這一套資料庫複寫軟體，隨著時間推進版本提升不少，目前已經來到 3.9. from Pocket https://ift.tt/2K4poBr via IFTTT

本範例將利用HAVING子句及彙總運算特性，以取代原本使用IF-ELSE判斷式之成立/不成立時均需寫入之需求，以銷售記錄寫入為例，當有銷售記錄時則全部寫入，如無銷售記錄時，則仍需寫入一筆註記資料。測試資料及SQL如下： --00. from Pocket http://ift.tt/2tlW1px via IFTTT

大家好，繼 SQL Server 2016 新功能搶先看系列最新力作【在工作群組叢集環境中建立 AlwaysOn 可用性群】新功能！ from Pocket http://ift.tt/2cZIKc7 via IFTTT

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. from Pocket http://ift.tt/2xt2yMG via IFTTT

SQLPerformance.com integration allows you to ask questions and get advice from SQL Server experts all over the world. from Pocket http://ift.tt/2idXZks via IFTTT

This is just a simple article visually explaining SQL JOINs. I'm a pretty visual person. Things seem to make more sense as a picture. I looked all over the Internet for a good graphical representation of SQL JOINs, but I couldn't find any to my liking. from Pocket http://ift.tt/2iytId0 via IFTTT

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB. from Pocket http://ift.tt/1Ki5c98 via IFTTT

是的，在今年三月的時候微軟就已經宣佈要讓 SQL Server 放在 Linux 系統裡，而在前陣子的 Microsoft Connect(); 2016 大會裡發表了 Microsoft SQL Server for Linux v. from Pocket http://ift.tt/2gcB8Tw via IFTTT

TPC（Transaction Processing Performance Council）是一個組織，翻成中文就叫「交易處理效能委員會」，這個委員會的主要功能是定義一些交易處理及資料庫效能量測的標準，其中 TPC-C 標準是測量 OLTP 系統的 tpmC（每分鐘可以處理的 Transa from Pocket http://ift.tt/2g8r5Pu via IFTTT