Manage

SQL Transact SQL T SQL

• Configure SQL Server at database level with new scoping syntax

  SQL Server 2016 adds ALTER DATABASE SCOPED CONFIGURATION to its new T-SQL statements. The statement lets DBAs control database configuration at the level of a single database. Continue Reading

• SQL Server best practices for handling the post-installation blues

  The job isn't over after a successful SQL Server installation. These SQL Server best practices will help you optimize your new SQL Server installation from the start. Continue Reading

• How do the T-SQL commands TRUNCATE TABLE and DELETE differ?

  TRUNCATE TABLE and DELETE are T-SQL statements with similar functions, but that doesn't make them interchangeable. They operate differently and use different amounts of SQL Server resources. Continue Reading

• SQL Server 2016 T-SQL features add to DBCC CHECKDB and more

  Expert Ashish Kumar Mehta shares some of the enhancements to T-SQL ahead in SQL Server 2016. This includes a DROP IF EXISTS option and MAXDOP for DBCC CHECKDB. Continue Reading

• How to set up the SQL Server buffer pool extension feature

  SQL Server 2014 includes the buffer pool extension feature, which can speed up query performance. Ashish Mehta explains the benefits of the feature and how to enable and disable it. Continue Reading

• Upgrade SQL Server 2014 SP1 in eight steps

  Upgrade from SQL Server 2008 R2 to SQL Server 2014 SP1 using backup and restore. This eight-step plan takes you through everything from log backups to end-to-end testing.Continue Reading

• In-memory OLTP reborn with SQL Server 2016

  Microsoft's in-memory OLTP needed improvements, and they are here with SQL Server 2016. Learn about the enhancements to this query-boosting feature.Continue Reading

• SQL Server 2016 addresses in-memory OLTP limitations

  Once hampered by limitations, in-memory OLTP will be more robust and complete in SQL Server 2016. Learn about the improvements.Continue Reading

• An introduction to SQL Server 2016 dynamic data masking

  An expert provides a step-by-step guide for how to use dynamic data masking in SQL Server 2016 CTP2 and Azure SQL database to protect sensitive data.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

• Two ways to encrypt database backups with SQL Server

  SQL Server 2014 provides two features that let database administrators easily encrypt database backups. An expert provides two demos that show you how.Continue Reading

• Create a user-defined server role in SQL Server 2012 with T-SQL, SSMS

  Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012.Continue Reading

• Nine T-SQL best practices

  Choosing the right data type and avoiding dynamic SQL are two of the nine T-SQL best practices that author Basit Farooq explains here.Continue Reading

• SQL Server views: Creating indexes and adding base data

  SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data.Continue Reading

• SQL Server views: What they are and how to create them

  SQL Server views can help DBAs provide information to users while still controlling data access. Find out how.Continue Reading