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

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.

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.

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.

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.

Understanding How to Use the UPDATE Statement to Change Your Data 10/02/2014

Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.

Backup and Restore Strategies in SQL Server – Part 1 09/22/2014

There are several high availability solutions which can be used with SQL Server and while these high availability solutions ensure maximum up-time 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.

How to Manage Microsoft Azure SQL Database Using PowerShell with REST APIs 09/04/2014

Continuing his discussion of a somewhat unorthodox method of managing Azure SQL Database that involves directly invoking REST APIs, Marcin Policht shows some of the unique benefits of REST APIs by demonstrating their unique capabilities that are not available via PowerShell.

TSQL: Understanding How to Use the INSERT Statement to Populate Your Database Tables 09/02/2014

Before you can read data from your database you need to understand how to insert data into the tables in your database. There are a number of different ways to accomplish this. Greg Larsen explores the methods you can use when inserting data into a database table using the INSERT statement.

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