Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

SQL Server management, tutorials, scripts, coding, programming and tips for database administrators

MS SQL

Getting Started with Azure SQL Data Warehouse - Part 5 05/22/2017

In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali covers performance optimization and the different aspects that impact performance.

Setting Variables in Calling T-SQL Code While Using sp_executesql 05/04/2017

In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.

Where is my SQL Server Configuration Manager? 05/04/2017

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.

Azure SQL Database - Dynamic Data Masking 05/01/2017

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.

Getting Started with Azure SQL Data Warehouse - Part 4 04/20/2017

Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.

Backing Up SQL Server Databases Hosted on Azure VMs 04/06/2017

Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.

Displaying Backup or Restore Progress 04/03/2017

Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.

How to Move a Table to a Different File Group 04/03/2017

There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.

Getting Started with Azure SQL Data Warehouse - Part 3 03/20/2017

Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.

Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services 03/09/2017

One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. Derived from the combination of two terms - Development and Operations, it represents a new approach to building synergy between these two seemingly conflicting types of activities. In this article, we will focus on using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, we will rely on Visual Studio Team Services.

Clean Your Buffers for Accurate Performance Testing 03/02/2017

In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run.

Who Changed My Database Schema? 03/02/2017

Have you ever wanted to know who made a schema change to your database?  If so, read on to learn how.

Getting Started with Azure SQL Data Warehouse - Part 2 02/23/2017

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.

Managing Azure SQL Database Recovery 02/06/2017

Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region. Read on to learn more.

Finding the Worst Performing TSQL Statement 02/02/2017

Have you ever wondered how to find the worst performing TSQL queries on your instance?  If you have, you are not alone.

MS SQL Archives




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM