Friday, March 25, 2016

Scripting a database in SQL Server 2012

You may need to use your database on one server on another server. Perhaps you just want to have a copy to work with to try something. In this case you need to somehow get it on to the other server. The following video created using Microsoft Sway shows the procedure. Just use the navigation keys at the bottom right.

Enjoy this new format of presentation.

Tuesday, March 15, 2016

SQL Server can now run on LINUX


First week of March this year Microsoft announced the availability of SQL Server on LINUX for both on-premises and the cloud. The core RDBS capabilities are now in preview but will be available mid-2017. The above image from Microsoft site.


More details here:
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

All the very best on Windows will be available for LINUX as well such as:
Mission-Critical Performance
Industry-Leading TCO
The best in best security
Plus all the hybrid cloud innovations
These all available out-of-the box.

Microsoft is not just for Windows but is truly cross-platform.
The preview is available as of the announcement.
Sing-up here to get more as the preview is limited to a select initial group:
https://www.microsoft.com/en-us/server-cloud/sql-server-on-linux.aspx

Wednesday, March 9, 2016

Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

The above course will be offered again (April 14-May 17, 2016) as a non-credit course by the Pacific Center for Advanced Technology Training.


Course summary:

Databases, organized repositories of information, have become indispensable and in fact even more relevant despite the emergence of Big Data in today's world.

In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course which will take you from installing SQL Server 2012; learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL.

During each meeting the students will be assessed for their knowledge, competency and proficiency in SQL.

New this session:
SQL Azure Database: SQL Server in Microsoft Cloud
Windows PowerShell for SQL Server

My sincere thanks and best wishes to the January batch of students.

Thursday, March 3, 2016

Easy way to backup a SQL Server Database

You may need to backup a SQL Server database. What tool would you use? Of course you can use the SQL Server Management Studio, a great tool, agreed. But there is an easier tool which comes with your Windows 10 Installation. The Windows PowerShell, another great program from Microsoft.

This Swaytorial (Swaytorial 3) shows you how to do it in  1-2-3 steps. Enjoy! Just use the navigation guides at the bottom right.


CC