Related resources for Microsoft SQL Server
  • Chapter 7: Master Data Services7/11/2019 2:15:32 AM. Microsoft SQL Server 2008 R2 Master Data Services (MDS) is another new technology in the SQL Server family and is based on software from Microsoft’s acquisition of Stratature in 2007.
  • Installing SQL Server On Linux In Azure7/10/2019 9:53:40 AM. In this video, let us learn to create Azure Virtual Machine (Linux) and install SQL Server on it.
  • How To Import Data From Excel Data Into SQL Table In Microsoft SQL Server 20163/18/2019 10:08:42 AM. This article demonstrates the inbuilt functionality of importing data from Microsoft Excel to a SQL table using import export wizard.
  • Auditing Data Changes In Microsoft SQL Server8/27/2018 9:49:37 AM. Tracking changes in data over time is a common problem, and deciding on your approach relies on answering questions such as “Do I want to track every field or just some fields?”, “Does it need to be ‘
  • Ranking Function In Microsoft SQL Server12/21/2016 11:05:41 AM. This article will explain the Ranking function in Microsoft SQL Server.
  • SQL Server 2014 Database Backup - Encryption5/24/2016 10:31:46 AM. In this article you will learn about SQL Server Database Backup. Microsoft SQL Server has developed a key feature introduced in SQL Server 2014, backup encryption.
  • How To Import Excel Data Into Microsoft SQL Server5/3/2016 12:20:57 AM. In this article you will learn how to import excel data into Microsoft SQL Server.
  • Installing SQL Server 20147/16/2013 6:12:26 PM. This article explains how to install and use SQL Server 2014 step-by-step.
  • Create a Report in SSRS 20085/20/2013 4:42:14 PM. In this article you will learn how to create a report in SSRS 2008.
  • Installing SharePoint 2013: Part 12/7/2013 12:02:53 PM. Installing SharePoint 2013 is an interesting experience if you didn’t mess it up. As a first step we need to understand the hardware and software requirement for SharePoint 2013.
  • Triggers and Active Databases10/3/2012 9:27:59 AM. This article is intended to illustrate how to use triggers in databases systems to enforce business rules and react to events in database applications thus supporting the Active databases principles.
  • Chapter 9: Reporting Services Enhancements5/20/2012 1:52:39 AM. If you thought Microsoft SQL Server 2008 Reporting Services introduced a lot of great new features to the reporting platform, just wait until you discover what’s new in Reporting Services in SQL Server 2008 R2.
  • SQL Server Integration Services (SSIS)- Export Data using Wizard5/20/2012 1:06:24 AM. In this article we will see how to export data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio).
  • Self-Service Analysis with PowerPivot5/19/2012 5:28:36 AM. Microsoft SQL Server 2008 R2 comes to the rescue for these users with two new features to meet these needs-SQL Server PowerPivot for Excel 2010 and SQL Server PowerPivot for SharePoint 2010. PowerPivot for Excel gives analysts a way to integrate large volumes of data outside of a corporate data warehouse, whether they are creating reports to support decision making or prototyping solutions that will eventually be part of a larger BI implementation.
  • Simulating Autonomous Transactions in Microsoft SQL Server5/15/2012 1:14:24 PM. In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.
  • XML Data Type in Microsoft SQL Server 20055/15/2012 1:07:41 PM. In this article we will see about XML data type in Microsoft SQL Server 2005.
  • Chapter 8: Complex Event Processing with StreamInsight7/20/2011 12:30:59 AM. Microsoft SQL Server StreamInsight is a complex event processing (CEP) engine. This technology is a new offering in the SQL Server family, making its first appearance in SQL Server 2008 R2. It ships with the Standard, Enterprise, and Datacenter editions of SQL Server 2008 R2.
  • Creating an OLAP Cube (SSAS)6/14/2011 3:45:31 PM. Here you will see how to create an OLAP Cube (SSAS).
  • Chapter 4: High Availability and Virtualization Enhancements12/2/2010 2:22:57 AM. This chapter discusses the enhancements to high availability that significantly contribute to the capabilities of SQL Server 2008 R2 in both physical and virtual environments.
  • Oracle database 11g and Microsoft SQL Server 20088/22/2009 8:32:09 AM. In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment of the IT industry. By analyzing these two giants, we can see the trends in the database systems. It’s remarkable to say that I will analyze these database systems from the developer perspective.
  • Building Data Access Helper Component for Microsoft SQL Server2/3/2006 12:58:58 AM. In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.