SQL-Transact SQL (T-SQL) News
July 09, 2015
Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
May 13, 2005
Get up to speed on server-level options to add another layer of integrity protection.
SQL-Transact SQL (T-SQL) Get Started
Bring yourself up to speed with our introductory content
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
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
When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how. Continue Reading
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Evaluate SQL-Transact SQL (T-SQL) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
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
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
Manage SQL-Transact SQL (T-SQL)
Learn to apply best practices and optimize your operations.
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
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
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
Problem Solve SQL-Transact SQL (T-SQL) Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading
Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012. Continue Reading
Can SQL combine tables where the values don't relate to one another? One expert says it's difficult unless you redesign the tables. Continue Reading