Relational database
Microsoft's enterprise relational database engine.
A full-featured RDBMS with T-SQL, a cost-based optimizer, columnstore indexes, in-memory OLTP, Always On availability groups and deep tooling. Runs on Windows, Linux, containers and as Azure SQL.
SQL ServerIntermediateExecution plans tell you exactly how SQL Server ran your query. Learn which operators matter, how to spot bad estimates and what the warnings really mean.
#execution-plans#performance#t-sql
Error 1205 again? Pull the deadlock graph from the system_health session, read it like a DBA and fix the access pattern that causes it.
#concurrency#locking#troubleshooting
SQL ServerBeginnerThe single most important physical design decision in SQL Server, explained from first principles — with the queries to prove it.
#indexing#performance#schema-design
SQL ServerIntermediateWhat each isolation level protects you from, what it costs, and why so many teams switch on READ_COMMITTED_SNAPSHOT.
#concurrency#locking#transactions
SQL ServerBeginnerMicrosoft announced the first version of SQL Server 2017 to run on Windows Server, Linux and Docker on Ignite, yesterday, calling it one of the heroes of ‘our new choice paradigm’. It will be available to customers from October 2, 2017, onwards. SQL Server 2017 is a milestone that was in pipeline…
#linux#news
SQL ServerBeginnerMicrosoft announces general availability of SQL Server 2016.
#microsoft#news#sql-server-2016
SQL ServerBeginnerMicrosoft announced that the SQL Server Connector for Azure Key Vault is now generally available.
#azure-key-vault#news#sql-server-connector
SQL ServerBeginnerMicrosoft has announced SQL Server 2014 Service Pack 2 (SP2). The release of SQL Server 2014 SP2 is planned for next month.
#news#sql-server-2014
SQL ServerBeginnerIn-Memory OLTP Performance Demois now available for download. In-Memory OLTP is a performance feature available in SQL Server and Azure SQL Database.
#in-memory-oltp#news
SQL ServerBeginnerMicrosoft announces the generally release of SQL Server Management Studio (SSMS). This release will go on to include all the updates which was included in the April preview release.
#microsoft#news#ssms
SQL ServerBeginnerThe latest version of SQL Server Connection is now available.
#azure-key-vault#microsoft#news
