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

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 of a correlated subquery.

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.

Getting Started with Power BI Designer 06/15/2015

The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Combining OS Installation and SQL Server Sysprep 06/04/2015

In recent articles we have been discussing how to streamline deployment of SQL Server 2014 Azure Infrastructure-as-a-Service (IaaS) virtual machines, without relying on Gallery images. In this article we capture all of the steps in the form of a single PowerShell script that can be executed remotely.

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server 06/01/2015

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.

Converting Comma Separated Value to Rows and Vice Versa in SQL Server 05/21/2015

Often while reporting you will encounter a situation where you will have comma separated values in a single column but you want to report them in rows. In other cases you might have values in multiple rows and want them to be a single value separated by comma or some other character. Arshad Ali demonstrates how to write queries in SQL Server to handle these scenarios quickly.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing SQL Server 05/07/2015

In one our articles recently published on this forum, we described the process of deploying a Windows Server 2012 R2 into an Azure Infrastructure as a Service (IaaS) virtual machine using the latest gallery image. This was meant to constitute the first step of the process involving prestaging a setup of SQL Server 2014. Now we are ready to initiate the SQL Server setup.

T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements 05/04/2015

Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.

CONCAT and STUFF Functions in SQL Server 2012 04/20/2015

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image 04/06/2015

There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service (IaaS) virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image, including a pre-staged SQL Server installation, which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.

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













Thanks for your registration, follow us on our social networks to keep up-to-date