Microsoft SQL Server

158K

Solutions

188

Articles & Videos

48K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Share tech news, updates, or what's on your mind.

Sign up to Post

SQL - The SELECT Statement
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
2
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

SQL - Selecting Rows and Columns
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
0
SQL - Creating a Table
Viewers will learn how the fundamental information of how to create a table.
1
Dealing with Dates: Data Types and String Conversions (SQL Server)
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
0
Set Up Backup with Maintenance Plans (SQL Server)
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
0
How to Restore a Database from a Backup (SQL Server)
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
17
 

Expert Comment

by:enrique_aeo
Backup schedule
Full database backups Saturday 10PM
Differential backups Monday, Tuesday, Thursday, Friday at 10PM
Log backups every hour (on the hour) from 9AM to 6PM
Failure Occurred at  Thursday at 10:30AM
What restore process should be followed?

Question: If a failure occurs at Thursday at 10:30AM, what is the restore process that should be undertaken?
0
 
LVL 22

Author Comment

by:Steve Wales
First, if you're still able to access at least a part of the database, you would want to take a backup of the tail of the transaction log and save that.

You would restore your full backup from Saturday at 10, with the NORECOVERY option.
You would then restore the most recent differential which based upon your schedule is Tuesday at 10 PM, with the NORECOVERY option.
You would then apply every transaction log from 10PM Tuesday (that first one may have you an error about it not being needed) up until 9 AM Thursday, each with the NORECOVERY option.

Now, if you don't have a tail log backup, you restore your last transaction log backup from 10AM Thursday WITH RECOVERY and you are done with recovery to 10AM and 30 minutes of data loss.

If you do have the tail log backup available, you restore that 10 AM Thursday transaction backup with NORECOVERY and then restore the tail log backup and you're back to the point of failure with no data loss.
0
Query Current Session Information via SQL
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
0
Loading Excel or CSV Data into SQL Server
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
1
Implementing a Backup Strategy (SQL Server)
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
0
Dealing With Dates: Manipulating Dates (SQL Server)
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
2
What Is Transaction Monitoring and who needs it?
LVL 1
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Connecting To SQL Server From Oracle Using Heterogeneous Services Generic Gateway
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
2
Creating and Executing a SQL Pass-thru Query
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. This video covers the basics of creating and working with pass-thru queries.

1. The video first shows the viewer how to create a pass-thru query in Access.

2. The data in the SQL Server table that the pass-thru query will return is displayed in SQL Server Management Studio.

3. We then create the T-SQL string in the pass-thru query and create an ODBC data source that will be used to connect to the SQL Server.

4. Finally, we store the ODBC connection string in the pass-thru query so that the pass-thru query can be run at any time.

10
Using a SQL Server View from Within Access
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access is a SQL Server view. After linking to a SQL Server view, the developer can create queries, forms, and reports based on that view. In fact, in most cases the data is editable!

1. The video first shows the viewer how to create a view in SQL Server Management Studio.

2. Once the user creates the view, they learn how to link to the view using an ODBC datasource.

3. The video demonstrates how the data in the view is editable.

4. The video then illustrates how easy it is to create forms and reports based on the view data.

1
 

Expert Comment

by:peterslove
I will like to know how to update, delete and add records to a linked sql table in an Access form.
0

Microsoft SQL Server

158K

Solutions

188

Articles & Videos

48K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.