This post was authored by Meet Bhagdev, Program Manager, MicrosoftWe are delighted to share the production-ready release of the SQL Server Command Line Tools (sqlcmd and bcp) on macOS El Capitan and Sierra.The sqlcmd utility is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances of SQL Server. The utility is extremely useful for repetitive database tasks such as batch processing or unit testing.The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.Install the tools for macOS El Capitan and Sierra/usr/bin/ruby -e $(curl fsSL http://ift.tt/YQTuQh)brew tap microsoft/mssql-release http://ift.tt/2qNZsD8brew updatebrew install mssql-tools#for silent install ACCEPT_EULA=y brew install mssql-toolsGet startedSQLCMDsqlcmd -S localhost -U sa -P <your_password> -Q <your_query>BCPbcp <your table>in ~/test_data.txt -S localhost -U sa -P <your password>-d<your database> -c -t ,bcp <your table>out ~/test_export.txt -S localhost -U sa -P<your password> -d<your database> -c -t ,For more information, check out some examples for sqlcmd and bcp.Please file bugs, questions or issues on our Issues page. We welcome contributions, questions and issues of any kind.from SQL Server Blog http://ift.tt/2pGN2Nb This post was authored by Meet Bhagdev, Program Manager, MicrosoftHi all,We are excited to announce the Production Ready release for the Microsoft Drivers v4.3.0 for PHP for SQL Server. The drivers now support Debian Jessie and macOS. The driver enables access to SQL Server, Azure SQL Database, and Azure SQL DW from any PHP application on Linux, Windows, and macOS.Notable items for the release:AddedPHP 7.1 supportAdded Unicode Column name support (issue #138)Support for transparent connections to AlwaysOn Availability Groups. The driver quickly discovers the current AlwaysOn topology of your server infrastructure and connects to the current active server transparently.Added support for sql_variant data type with limitation (issue #51 and issue #127)Debian Jessie (tested on Debian 8.7) and macOS (El Capitan and above) supportConnection Resiliency support for WindowsConnection pooling support for Linux and macOSFixedFixed the assertion error (Linux) when fetching data from a binary column using the binary encoding (issue #226)Fixed PECL installation errors when PHP was installed from source (issue #213)Fixed issue output parameters bound to empty string (issue #182)Fixed a memory leak in closing connection resourcesFixed load ordering issue in MacOS (issue #417)Fixed the issue with driver loading order in macOSFixed null returned when an empty string is set to an output parameter (issue #308)SQLSRV onlyFixed sqlsrv client buffer size to only allow positive integers (issue #228)Fixed sqlsrv_num_rows() when the client buffered result is null (issue #330)Fixed issues with sqlsrv_has_rows() to prevent it from moving statement cursor (issue #37)Fixed conversion warnings because of some const chars (issue #332)Fixed debug abort error when building the driver in debug mode with PHP 7.1Fixed string truncation when binding varchar(max), nvarchar(max), varbinary(max), and xml types (issue #231)Fixed fatal error when fetching empty nvarchar (issue #69)Fixed fatal error when calling sqlsrv_fetch() with an out of bound offset for SQLSRV_SCROLL_ABSOLUTE (issue #223)PDO_SQLSRV onlyFixed