Manage

SQL Transact SQL T SQL

• 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

• SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT

  In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here.Continue Reading

• SQL CONSTRAINT clauses: PRIMARY KEY and UNIQUE

  In SQL Server, SQL CONSTRAINT clauses let you control the kinds of values that get entered into a column. Learn about two of them here.Continue Reading

• Manage your SQL Server databases with SQL DMVs

  SQL DMVs (dynamic management views) can help simplify administration of SQL Server databases. Find out how with detailed examples.Continue Reading

• Manage, query SQL Azure Federations using T-SQL

  Can SQL Azure help you manage “big data?” SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables.Continue Reading

• The most dangerous game: Hunting down bad SQL query performance

  SQL Server is faster when the queries behind your applications are faster. Learn how to spot bad SQL query performance, and then work with developers so you can improve throughput.Continue Reading