March 9th, 2017
How to Create and Back Up a SQL Server Database Part 2
In part 2 of this blog, learn how to create a backup maintenance plan that will run on a daily basis and how to restore the database.
More
SQL Server
-
-
February 2nd, 2017How to Create and Back Up a SQL Server Database Part 1
MoreSoftware Engineer Irma Azarian explains how to create a simple database and how to manually create a backup file that can be used to restore the database.
-
September 4th, 2014How to Become Certified in SQL Server 2012: Part 3
MoreThe third step in becoming certified in SQL Server 2012 is to pass the Implementing a Data Warehouse with Microsoft SQL Server 2012 test.
-
April 30th, 2014The SQL Server PIVOT Query
MoreThe PIVOT operator in SQL Server is used to rotate your query output 90 degrees so the unique column values can be transposed to column headers.
-
March 20th, 2014How to Become Certified in SQL Server 2012: Part 2
MoreThe second step in becoming certified in SQL Server 2012 is to pass the Administering Microsoft SQL Server 2012 Databases exam.
-
March 13th, 2014Microsoft SQL Server vs. Oracle: The Same, But Different?
MoreThe main differences between the two RDBMS are language (TSQL vs PL/SQL), transaction control, and DB object organization.
-
February 28th, 2014ETL and its Application in Data Warehouses
MoreWhat is the Extract, Transform and Load (ETL) process and some things to consider while implementing it in a Data Warehouse setup?
-
January 30th, 2014Introduction to SQL Server 2012 – Part One
MoreMicrosoft SQL Server 2012 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools.
-
January 13th, 2014What is Crystal Reports?
MoreCrystal Reports is a Business Intelligence application that aggregates and displays data from databases to users via reports.
-
December 17th, 2013Comparing Crystal Reports and SQL Server Reporting Services
MoreThe biggest differences between the reporting services Crystal Reports and SQL Server are in the ease of use and performance.
-
November 26th, 2013What Are SQL Joins?
MoreA SQL Join is Used to Retrieve Records From Multiple Tables in a Database.
-
October 15th, 2013How to Become Certified in SQL Server 2012: Part 1
MoreThe first step in becoming certified in SQL Server 2012 is to pass the querying microsoft SQL Server 2012 exam. Find out what to expect here.
-
June 4th, 2013Advantages and Drawbacks of Using Stored Procedures for Processing Data
MoreStored Procedures Have Become the De Facto Method for Accessing and Processing Backend Data. But Are They the Best Solution For the Job?