SQL Server security – (Part 3) Author: Basit A. Farooq Editor’s Note: In this third part of the SQL Server security article series, you’ll first learn how to manage securables at the database and schema scope. You’ll also learn about fixed server roles and how to create custom server roles to simplify administration and manage permissions. This article applies to […]
Author: Basit Aalishan Masood-Al-Farooq
SQL Server security – (Part 2)
SQL Server security – (Part 2) Author: Basit A. Farooq Editor’s Note: In this second part of the SQL Server security article series, you’ll first learn how to manage logins. You’ll also learn how to create and manage database users. This article applies to SQL Server 2005 and later editions. Modifying logins You can change a login using SQL Server […]
SQL Server security – (Part 1)
SQL Server security – (Part 1) SQL Server security is based around principals and securables. A principal is a SQL Server object that can be used to grant permissions to securables. A securable is any object that supports permissions. In the first part of the SQL Server security article series, you’ll learn about the two types of authentication SQL Server […]
New Features in SQL Server 2016
New Features in SQL Server 2016 Author: Basit A. Farooq During his keynote speech at Microsoft Ignite conference in Chicago, Microsoft Corporate CEO Satya Nadella announced that the first public preview of SQL Server 2016 will be available this summer. Finally, the wait is over and on the May 27, 2015, the first public preview of SQL Server 2016 was...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
New Features in SQL Server 2016
New Features in SQL Server 2016 Author: Basit A. Farooq During his keynote speech at Microsoft Ignite conference in Chicago, Microsoft Corporate CEO Satya Nadella announced that the first public preview of SQL Server 2016 will be available this summer. Finally, the wait is over and on the May 27, 2015, the first public preview of SQL Server 2016 was […]
SQL Server 2014: User Views – (Part-1)
SQL Server 2014: User Views – (Part-1) Author: Basit A. Farooq Views provide you with flexible options for displaying data, such as limiting access to specific columns in a table, effectively hiding the remaining columns; and joining data from multiple tables, giving you a denormalized presentation from normalized data. Most often, you will create views based on one or more...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SQL Server 2014: User Views – (Part-1)
SQL Server 2014: User Views – (Part-1) Author: Basit A. Farooq Views provide you with flexible options for displaying data, such as limiting access to specific columns in a table, effectively hiding the remaining columns; and joining data from multiple tables, giving you a denormalized presentation from normalized data. Most often, you will create views based on one or more […]
Big Data Analytics with the Microsoft Analytics Platform System Appliance
Big Data Analytics with the Microsoft Analytics Platform System Appliance Author: Basit A. Farooq Data warehouses are the central repository containing all relevant data (internal or external) for enterprise information and decision support systems. These repositories provide high quality information, that is, subject-oriented, integrated, time-invariant and non-updatable, for the data analysis purposes to support enterprise’s management processes and business decisions....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Big Data Analytics with the Microsoft Analytics Platform System Appliance
Big Data Analytics with the Microsoft Analytics Platform System Appliance Author: Basit A. Farooq Data warehouses are the central repository containing all relevant data (internal or external) for enterprise information and decision support systems. These repositories provide high quality information, that is, subject-oriented, integrated, time-invariant and non-updatable, for the data analysis purposes to support enterprise’s management processes and business decisions. […]
Top 20 tips to optimize your T-SQL code (Part-2)
Top 20 tips to optimize your T-SQL code (Part-2) Author: Basit A. Farooq In this second of the two part article series, I will share the last 10 tips that you can follow to optimize T-SQL code. Tip#11: Avoid overindexing tables Indexes are the solution to many performance problems, but too many indexes on tables affect the performance of INSERT,...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here