Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

SQL Server 2016 User Logins Management

This is my 2nd article on SQL server 2016, in this article I will explain in detail how to maintain user permissions or security.

SQL Server Security Management

A. Developers Access Control

It is very crucial to manage each user’s access rights as it can become hectic when need to manage 10-20 users with multiple permissions on their windows authentication.

To manage permissions among users, SQL has provided access management using windows groups.

Below are the steps to create any local windows group

1.  Search “Computer Management” and open it.
2.  Expand “Local Users and Groups” and then open Groups.

3.  Add new local windows user group and map windows users under it. Eg. “SQLUserGP_Read”, “SQLUserGP_Write” and “SQLUserGP_DBA”

Windows group can be added in same fashion like windows user.
It is always advisable to provide execute rights to all developers so execute below query for same.
GRANT EXECUTE TO [VSPC0129\SQLUserGP_Read]
GRANT EXECUTE TO [VSPC0129\SQLUserGP_Write]


B.  SQL/Web User Access Control

To restrict hackers from manipulate our database, we should always provide minimal access to users.
It can be done at object level and database level.

Object Level

Advisable to provide access to only required objects so that other objects can’t be accessed in case of any hacking attempts.

Database Level 

Keep all the interactions through stored procedure and user should only be allowed to execute SPs (will not have even select rights).

धन्यवाद मित्रो !! 

Thanks Friends 

How to prevent user to not copy SQL server data files

Prevent database file from copying

I am working in a product based company and will provide SQL Server express 2014 edition with our software.
I want your expert comment on database security. 

Problem

As we are installing a database on client PC then they might be able to clone our system by attaching MDF files to another server. 

(In my view, through database objects name and data, other companies can easily identify our workflow and can develop software easily)

So I want some type of encryption or file system solution to prevent user to take database files. And yes as we are using express edition, we can't use available SQL server options.

100 SQL Azure interview questions

In this article I will share around 100 quality questions that covers all area In SQL Azure and azure.

Prepare following question I am sure those 100 questions definitely help you to crack interview in SQL Azure, happy job searching friends.

Top 100 SQL Azure interview questions:

1. What is SQL Azure?

2. What are the advantages of SQL Azure?

3. What is cloud computing?

4. What is scale a cloud service?

5. What is a cloud service role?

6. What is a cloud service components?

7. How many types of deployment models are used in cloud?

8. How is SQL Azure different than SQL server?

9. How many replicas are maintained for each SQL Azure database?

10. CAN I USE SQL AZURE AS A BACKUP WITH LOG SHIPPING OR DATABASE MIRRORING?

11. What are two difference between SQL Azure and Azure Tables?

12. How can we migrate from SQL server to SQL Azure?

13. Which tools are available to manage SQL Azure databases and servers?

14. What encryption security is available in SQL Azure?

15. Explain security with SQL Azure.

16. What is SQL Azure Firewall?

17. What is the difference between web edition and business edition?

18. How do we synchronize On Premise SQL server with SQL Azure?

19. How do we Backup SQL Azure Data?

20. What is the current pricing model of SQL Azure?

21. What is the current limitation of the size of SQL Azure DB?

22. How do you handle datasets larger than 50 GB?

23. What happens when the SQL Azure database reaches Max Size?

24. How many databases can we create in a single server?

25. How many servers can we create in a single subscription?

26. How do you improve the performance of a SQL Azure Database?

27. What are REST-style architecture's?

28. What is code near application topology?

29. What were the latest updates to SQL Azure service?

30. When does a workload on SQL Azure get throttled?

31. What happens when the SQL Azure database reaches Max Size?

32. What is the current limitation of the size of SQL Azure DB?

33. How do you handle datasets larger than 50 GB?

34. What is it’s similarity with SQL Server?

35. How can we migrate from SQL server to SQL Azure?

36. Difference between Web and Worker Roles in Windows Azure?

37. What is AutoScaling?

38. What are Horizontal and Vertical Scaling?

39. Which tools are available to manage SQL Azure databases and servers?

40. How many databases can we create in a single server?

41. How many servers can we create in a single subscription?

42. What is the difference in accessing DB between SQL Server Vs SQL Azure?

43. What is the Data Tier Application?

44. What is the index requirement in SQL Azure?

45. How do you migrate data from MSSQL server to Azure?

46. Where actually SQL Azure Database is hosted?

47. List layers of abstraction Microsoft architectured to provide relational DB through cloud platform ?

48. Explain four layers of abstraction Microsoft architectured?

49. How do we synchronize On Premise SQL server with SQL Azure?

50. What is SQL Azure Fabric?

51. What is provisioning, billing and metering, and connection routing concepts in the service layer?

52. Explain managing session state in Windows Azure?

53. Explain Azure Service Level Agreement (SLA)?

54. What’s the benefit of Azure SLA?

55. How many instances of a Role should be deployed to satisfy Azure SLA (service level agreement) ?

56. How to connect to SQL Azure Database by using sqlcmd?

57. What are the three main components of Windows Azure Platform?

58. How would you categorize Windows Azure?

59. Explain IaaS, PaaS and SaaS?

60. Explain differences between web edition and business edition?

61. What is the difference between web edition and business edition?

62. What is Windows Azure compute emulator?

63. What is Windows Azure Storage Emulator?

64. What are the roles available in Windows Azure?

65. How to design applications to handle connection failure in windows Azure?

66. List languages/frameworks that can be used to develop Windows Azure applications?

67. What are the three types of roles in Compute component in Windows Azure?

68. What is VM role in Windows Azure?

69. What is worker role in Windows Azure and how does it help?

70. What is web role in Windows Azure?

71. What are the differences between web role and worker role?

72. What is a role instance?

73. What is a guest operating system?

74. What is SQL Azure Data sync?

75. Which are the two editions in which SQL Azure database available?

76. What is Azure Diagnostics?

77. What is a service package?

78. What is a service configuration file?

79. What is a service definition file?

80. What is minimal vs. verbose monitoring?

81. What is swap deployments?

82. Explain in details security in SQL azure?

83. Ways to improve the performance of a SQL Azure Database?

84. What is a fan-out query in SQLAzure?

85. List types of tables in SQLAzure?

86. Explain tables in SQLAzure?

87. What is the index requirement in SQL Azure?

88. What were the latest updates to SQL Azure service?

89. What is the difference between web edition and business edition?

90. What is TDS(Tabular Data Stream) Gateway?

91. How to connect Azure federated root database and apply federation in entity framework?

92. How to scale out a federation by Sql statement?

93. What is Federation and Federation Member?

94. What is Federation Root Database?

95. What is SQL Azure Federations?

96. What is code near application topology?

97. How do we Backup SQL Azure Data?

98. What is sharding?

99. What is server-level principal?

100. What is function of master database?