Evaluate

SQL Transact SQL T SQL

• Microsoft SQL Server 2016: Previews show promise for next year

  Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database. Continue Reading

• How to get started with PolyBase in SQL Server 2016

  With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in. Continue Reading

• Comparing memory-optimized tables and disk-based tables

  In all tests performed by expert Basit Farooq, memory-optimized tables outperformed disk-based tables by running faster and generating less disk I/O. Continue Reading

• Limited public preview opens for Azure SQL Data Warehouse

  Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing. Continue Reading

• SQL Server 2016 preview shows off new features, improvements

  Experts discuss the public preview of SQL Server 2016 and the best new features as early adopters ready themselves to put SQL Server 2016 into production. Continue Reading

• How to improve OLTP with SQL Server 2014 In-Memory

  Basit Farooq explains how to improve the performance of OLTP applications using SQL Server 2014 In-Memory. He details what makes SQL Server 2014 In-Memory different from other in-memory database engines and how to use that to your advantage.Continue Reading

• Digging deeper with T-SQL system functions and language tools

  Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server.Continue Reading

• Top 10 SQL Server development tips of 2008

  Here are the top 10 most viewed SQL Server development tips of 2008. From converting date/time values into character types, working with DATETIME and SMALLDATETIME in SQL Server 2005, using a stored procedure to find the size of SQL Server tables ...Continue Reading

• Five sqlcmd features to automate SQL Server database tasks

  Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcmd commands, such as for utilizing and populating ...Continue Reading

• Sample T-SQL stored procedure: P_DisplayProductDetails

  This sample T-SQL stored procedure to be debugged displays product details from the AdventureWorks database using a function to rank the unit price for each product subcategory.Continue Reading

• Find the product of a field in Microsoft SQL Server

  This function will produce the product of a field or set of values in SQL Server 2000.Continue Reading