(Rod Trent) One of the growing selling points of Microsoft Azure is the ability to host SQL Server databases. Azure does offer options for utilizing other database types, making it a very open data platform, but Microsoft makes using SQL Server in the Cloud much easier and much more affordable.

(Varinder Sohal) Recently in one of our HR projects we implemented the contained SQL Server database concept. We implemented the policy that going forward we will create Contained SQL Server Users without logins in contained databases which will ease the process of migrating the databases across dat

(Kris Wenzel) In today’s lesson you’re going to learn how filter the results returned from your queries using the WHERE clause. This clause is important as only those records matching the where clause’s conditions are returned in the query results. The objectives of today’s lesson are to:

(Sunil Agarwal) The clustered column store index (CCI) has been designed for Data Warehouse scenario which primarily involves

(Buck Woody) In this series, I’ll cover the practical side of integrating the “cloud” – specifically the Microsoft Azure Platform – for the SQL Server professional. It’s a bare-bones, get-me-started, show-me-the-money kind of article that has only three elements:

(Pinal Dave) History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. Most of the cities like Seattle and many others have this boom and bust life.

(Tim Radney) Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic Overflow”.

(Kenneth Fisher) Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look!

(Kris Wenzel) The series starts with the article Introduction to Database Joins. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server. In

(Rohit Garg) Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.