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

T-SQL Programming Part 13 - Selecting Data Using the TOP Clause 04/02/2015

There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2 03/23/2015

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.

Introduction to Automating Deployment of SQL Server in Azure IaaS Virtual Machines 03/05/2015

In general, Microsoft Azure provides two types of SQL Server based relational data services, Azure SQL Database Platform-as-a-Service (PaaS) and deploying a SQL Server instance into an Azure Infrastructure-as-a-Service (IaaS) virtual machine. There are obvious implications in regards to the management overhead associated with IaaS-based solutions. Marcin Policht reviews methods that allow you to minimize this overhead, focusing in particular on deployment tasks.

T-SQL Programming Part 12 - Using the ROLLUP, CUBE, and GROUPING SETS Operators 03/02/2015

Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.

Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1 02/19/2015

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.

Managing Azure SQL Database Authorization 02/05/2015

When planning for deployment of Azure SQL Database, it is important to consider all of the security measures that can be implemented. Having already looked at dealing with firewall-based protection and having also briefly described authentication, authorization, and encryption characteristics, it’s time to take a closer look at some of the authorization options that allow you to control access to your data in a granular manner.

T-SQL Programming Part 11 - Using SQL Server's GROUP BY clause to Summarize your Data 02/02/2015

SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.

Importance of Statistics and How It Works in SQL Server – Part 2 01/22/2015

Arshad Ali discusses what filtered statistics are and what's new in regards to statistics in SQL Server 2012.

Azure SQL Database Auditing 01/08/2015

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.

T-SQL Programming Part 10 - Returning Sorted Record Sets Using the ORDER BY Clause 01/05/2015

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. Greg Larsen explores how to return an order result set by using the ORDER BY clause.

Importance of Statistics and How It Works in SQL Server – Part 1 12/22/2014

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.

T-SQL Programming Part 9 - Using the MERGE Statement to Perform an UPSERT 12/04/2014

The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.

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