Short Tutorials Concepts Simplified

Hi All,

Continuing from my previous blog post about icons!

We shall now delve into another helpful topic series –

e-books.

Hold that thought!

This is not your regular e-books.

They have been crafted in a very lucid manner.

One of the two favorites is from @Syncfusion ‘s ebook library are

 

by John Garland
| Formats: Amazon Kindle and PDF
Make your transition to developing Windows Store apps as smooth as the Windows 8 UI.

 

==========

by Michael McLaughlin
| Formats: Amazon Kindle and PDF
Are you an experienced C# developer looking to ease your way into C++?
Author Michael McLaughlin walks you through C++ from types and functions to lambda expressions and the standard C++ library while relating these concepts to their parallels in C#.

============

 

There are plenty and best of all They are FREE for the asking!

http://www.syncfusion.com/resources/techportal/ebooks

 

 

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)

Icons for your Apps – No Problem!! Say Hello to MetroStudio

Have a great app idea –> Awesome

Have all the code ready — > Cool!

UX in place –> Yup, Kinda…

Well make UX icons a breeze for your apps now using MetroStudio from Syncfusion.

Try MetroStudio Today!! It’s FREE!!

Do you have the time to build 4500 icons??

Well @Syncfusion #syncfusion ‘s range of icons are crisp and can be modified easily!

Check out this video

http://www.youtube.com/watch?v=h52ZODX5g9g

They are FREE!!

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)

RAD Studio XE 5 is Here!!

RAD Studio XE 5 is Here!!

 

RAD Studio XE5 from EMBARCADERO TECHNOLOGIES The multi-device, true native app development for Android and iOS

 

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)

===

 

 

Sign up for Android news/info and apply to be a beta tester from Embarcadero Technologies

MDD

 

 

We are headed towards various Mobile Ecosystems,

No doubt the major 3 mobile ecosystems have taken both business and consumers world by storm!

Embarcadero Technologies! The Leading Enterprise Database and Applications Tools Company enables Developers a chance NOW! to experience and signup for as an Android Beta Tester.

Sign up for Android news/info and apply to be a beta tester: http://embt.co/RADBetaA

Hurry Registrations filling up soon!!

======

 

We have some exciting offers

Special Offers: http://embt.co/XE4RadOffer

– 6 months maintenance free with new user purchases

– 2009 users get the upgrade price when buying with 1 year maintenance

– bonus pack of extras free

Sign up for Android news/info and apply to be a beta tester: http://embt.co/RADBetaA

Hurry Registrations filling up soon!!

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)

SQL Server Shots – User Management Tips

In this post, I will try to shed some light on user management as Security is one of my favorite topic in databases.

 

In SQL Server, it is highly recommended that most DBAs follow these rules of Security

 

  1. Roles –> Database and Application roles
  2. Choosing the right Authentication mechanism –> Windows Authentication Highly recommended as it integrated with Windows Active Directory.
  3. Also creating Schemas for isolation of respective application tables for better and efficient user management

 

In the forth coming days, I will be diving deep into these topics with examples that are lucid to follow and implement.

 

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)

SQL Server Shots – Web Hosting SQL Server Database and assigning users

Today we shall try and understand, how Web hosting companies try and assign users for their specific accounts.

[Scenario – You are a SQL Server DBA and asked to create a user for a specific web hosting account]

 

Here is how we can accomplish it.

This is usually done as per the previous post via Schemas.

 

Let’s say, we have a user called Asha and we need to enable her to create database objects within the specified database.

1) Launch SQL Server Management Studio

2) Create a Database called AshaDB

3) Create a login called Asha

4) Now before clicking on the  OK button, make sure that you choose AshaDB as the preferred database to be connected
AssignUser

 

4) Create a schema called Asha

SchemaAssignment

5) Assign the required privileges

6) Now to verify this works , try logging in as the Asha user and make sure that she can create objects and only access the AshaDB as shown in the following two screenshots

 

LoginFailedDB_Inaccessible

 

The above screenshot indicates Asha is unauthorized to access the AdventureWorks Database

 

However, she can access her designated database.

 

 

DBAccessible_Asha

 

The final screenshot shows that she can create the required database objects under her schema.

ObjectsCreated

 

 

 

See you again soon!

 

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)

SQL Server Shots – Schema Magic

In today’s SQL Server Shots we present the cool security feature of Schemas in SQL Server.

 

[Scenario: Jon needs to access only Sales related information in the database and Rudra needs to access Human Resources]

1) One of the ways could be to just not give them access to the relevant tables.

2) However in a realistic scenario, it would be considered a best practice to isolate these two users into their respective areas.

 

[Solution: Schemas]

A schema within SQL Server is defined as a location to enable a or an group of users to be associated with it. This provides better security and efficient user management.

 

Let’s use the AdventureWorks Database to simulate an example.

 

  1. We will create two users Jon and Rudra
  2. Next we will explore the Schemas Object under the Security folder and make sure we have Sales and HumanResources
  3. We will then assign the user Jon to the Sales Schema and Rudra to the HumanResources Schema

 

Schema_Users

 

We will now double click on the HumanResources Schema and add the user Rudra to the schema

 

HR_rudra

 

 

Now grant the appropriate privilege to this user to test that we can create database objects.

Follow the same steps for Jon for the Sales Schema.

You can now see that Jon and Rudra can benefit by having access to only those tables being created by them in their individual schemas.

 

This helps in efficient data object creation and isolation.

 

So until tomorrow for the next SQL Server Shots.

===

Amplify Your Knowledge SQL Server Live! is part of Live! 360, the ultimate IT and Developer line-up.

#SQLLive360 @SQLLive360

SQLORL13_banner_ad_300x250(SEB)