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 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.

How to Programmatically Determine Which Edition of SQL Server is Installed 02/02/2017

Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.

Getting Started with Azure SQL Data Warehouse - Part 1 01/23/2017

As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. Read on to learn more about this data warehouse-as-a-service offering from Microsoft.

Introduction to SAP HANA on Azure 01/05/2017

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.

Simple Row Level Security for SQL Server 2016 01/03/2017

Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by using row level security.

Using A Block Predicate to Restrict Row Updates and Inserts 01/03/2017

If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement. If you want to prevent this from occurring, you can use a blocking predicate.

Getting Started with R Services in SQL Server 2016 – Part 2 12/27/2016

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.

SQL Server in Azure Virtual Machines - Performance Optimizations 12/05/2016

When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. We will explore a couple of these enhancements in this article. In particular, we will focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).

Removing Email from msdb Database 12/01/2016

Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records from the msdb database. If you are sending email using database mail and you are not periodically purging email information, then you might find out this is one of the reasons your msdb database is growing bigger.

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