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


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.

Introduction to Azure SQL Database Scalability 12/01/2014

One of the primary advantages of Platform-as-a-Service (PaaS) solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.

Lead and Lag Functions in SQL Server 2012 11/20/2014

Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function.

Monitoring Azure SQL Database 11/06/2014

Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.

T-SQL Programming Part 8 - Removing Rows with the DELETE Statement in SQL Server 11/03/2014

Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.

Backup and Restore Strategies in SQL Server – Part 2 10/20/2014

There are several high availability solutions that can be used with SQL Server. While these high availability solutions ensure maximum uptime for your databases, you need to set up backup and restore strategies to recover the data or minimize the risk of data loss in case a failure happens.

Performing Azure SQL Database Management Tasks by Using PowerShell with REST API 10/06/2014

Recently, we have been exploring the ability to administer Azure SQL Database by leveraging REST APIs invoked from PowerShell-based scripts. Such an approach offers more flexibility, facilitating functionality that is not directly exposed in the PowerShell cmdlets. We have already illustrated these advantages in the context of managing Azure SQL Server instances - now it is time to show how similar benefits can be realized when dealing directly with Azure SQL Databases.

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