Tutorial by Topics: data

Basic Syntax: {GRANT| REVOKE | DENY} {PERMISSION_NAME} [ON {SECURABLE}] TO {PRINCIPAL}; {GRANT| REVOKE | DENY} - What you're trying to accomplish Grant: "Give this permission to the stated principal" Revoke: "Take this permission away from the stated principal" Deny:...

There are 2 spatial data types Geometry X/Y coordinate system for a flat surface Geography Latitude/Longitude coordinate system for a curved surface (the earth). There are multiple projections of curved surfaces so each geography spatial must let SQL Server know which projection to use. The usua...

This section provides an overview of what bigdata is, and why a developer might want to use it. Big data is the data characterized by the 4 V's. These are Volume, Velocity, Variety and Veracity. Volume - When the amount of data is in huge volume like Terabytes or Petabytes. As a report says, w...

This technique can also be used for other data sources e.g. files, web services. Note that when you do change these settings, you may have to specify Authentication/Credential details for the new source.

Melt with melt(DT, id.vars=c(..), variable.name="CategoryLabel", value.name="Value") Cast with dcast(DT, LHS ~ RHS, value.var="Value", fun.aggregate=sum) ParameterDetailsid.varstell melt which columns to retainvariable.nametell melt what to call the column with...

SQL Server includes a feature called delayed naming which means that in many cases you can deploy procedure and code that references objects that do not exist. It is also possible to drop or alter an object in such a way that any pieces of referencing code no longer run when called. When you get ...

ItemTemplate:It potrays the content and layout of items within the list.This is mandatory Required AlternatingItemTemplate:If mentioned, determines the content and layout of alternating items. If not mentioned, ItemTemplate is used. SeparatorTemplate : If mentioned, is rendered between items (an...

sqlcmd -S SHERAZM-E7450\SQL2008R2 -d Baseline_DB_Aug_2016 -o c:\employee.txt -Q "select * from employee"