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 Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
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


Getting Started with Stretch Database Functionality in SQL Server 2016 – Part 1 11/16/2015

Start using Stretch Database in SQL Server 2016 with this step-by step guide. Learn how to use SSMS to do it manually or use T-SQL to automate the overall process.

Azure SQL Database - Transparent Data Encryption 11/05/2015

Transparent Data Encryption offers the ability to encrypt the content of a database, its transaction logs, as well as backups, while at rest. Encryption and decryption are performed in real-time, at the individual page level, as the database is being written to and read from storage, without necessitating changes to applications accessing their data. Read on to learn more.

Installing SQL Server 2016 11/02/2015

You now have a couple of new installation options available when you install SQL Server 2016. One of those new features is being able to define multiple tempdb data files while installing SQL Server. Additionally the incorporation of PolyBase into the database engine means there is a new option for installing the new PolyBase Query Service. Greg Larsen walks you through the GUI installation process for SQL Server 2016 and explores these new installation options.

Understanding Stretch Database Functionality in SQL Server 2016 10/19/2015

Stretch Database, introduced in SQL Server 2016, lets you move or archive your cold data from a local SQL Server database to Azure SQL Database transparently without writing code for data movement, while at the same time allowing applications to access it like any other table. Read on to learn more about this new capability in SQL Server 2016.

Azure SQL Database - Row-Level Security 10/05/2015

One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).

10 New Features Worth Exploring in SQL Server 2016 10/01/2015

There is a lot of buzz around SQL Server 2016. It will not be too long until SQL Server 2016 will be fully baked and ready for shipping. As always there are a ton of new features and in this article Greg Larsen explores 10 of those new features.

Creating Dashboards for Mobile Devices with Datazen – Part 4 09/21/2015

Arshad Ali shows you how to create filters, publish dashboards to the Datazen server and create drill-through dashboards.

Automated Patching of SQL Server IaaS VMs 09/08/2015

In a recent article we have described an automated method of backing up user databases hosted on SQL Server instances running in Infrastructure-as-a-Service (IaaS) Azure virtual machines. In this article we turn our attention to the equivalent approach to manage Windows updates in the same scenario.

T-SQL Programming Part 15 - Understanding How to Write a Correlated Subquery 09/03/2015

How do you return a set of records that are based on the results of another set of records with TSQL? One method is to write a correlated subquery. Greg Larsen explains what a correlated subquery is, and provides a number of examples.

Creating Dashboards for Mobile Devices with Datazen – Part 3 08/20/2015

Learn how to create a data source and data view and then how to create dashboards with Datazen Publisher using those data sources and data views.

Creating Dashboards for Mobile Devices with Datazen – Part 2 08/06/2015

Arshad Ali shows you how to install, configure and use Datazen Server.

Automated Backups of SQL Server Databases in Azure IaaS VMs 08/03/2015

Marcin Policht demonstrates methods to simplify and streamline provisioning and management of Azure SQL Database and SQL Server running in IaaS Azure virtual machines. The focus of this article is on the functionality related to common maintenance tasks, in particular database backups, facilitated by Azure VM extensions.

Creating Dashboards for Mobile Devices with Datazen – Part 1 07/23/2015

Arshad Ali demonstrates how to use Datazen to quickly and easily create dashboards and KPIs (Key Performance Indicators) for mobile devices.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Completing the Process 07/06/2015

Recently, we presented a script that provisions a new Azure IaaS virtual machine running Windows Server 2012 R2 and that prestages a SQL Server 2014 default instance. In this article learn how to eliminate the need to manually initiate the second part of the SQL Server setup and finalize the capture.

Power BI - Getting Data from Analysis Services 07/02/2015

Arshad Ali demonstrates how to use Analysis Services connector to interactively query your on-premise data from an Analysis Services instance in Power BI reports or dashboards.

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