Relational DB / Big Data / OLAPRelational DB / Big Data / OLAP
MongoDB Tutorials Tutorial 1 (guru99) Terms Learnng resources Guru99. Keywords Big data, Bigdata, Big-data, MongoDB, Mongo DB NoSql, No sql,
Category: MS BI
Measure Ms Sql Execution time in resolution of millisecondsMeasure Ms Sql Execution time in resolution of milliseconds
DECLARE @t1 DATETIME; DECLARE @t2 DATETIME; SET @t1 = GETDATE(); /* Put here the query to measure */; SET @t2
Temporary tables and Table variables – MsSQLTemporary tables and Table variables – MsSQL
Temporary Tables The simple answer is yes you can. Let look at a simple CREATE TABLE statement: CREATE TABLE #Yaks
How to search text at all Ms SQL tables, fields and all object?How to search text at all Ms SQL tables, fields and all object?
1. Create the following Stored Procedure at the database you want to search: CREATE PROCEDURE SearchTables @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60)
A Beginner’s Guide to SQLA Beginner’s Guide to SQL
A great guide for learning SQL from the start, from Udemy: https://blog.udemy.com/beginners-guide-to-sql/ What Wikipedia has to say about UDemy: Udemy.com
BI SSRS / SSMS / SSAS / SSMSBI SSRS / SSMS / SSAS / SSMS
BI SSRS / SSMS / SSAS / SSMS Password: nayabi2015 https://www.dropbox.com/sh/qjawz1tn033f2qn/AACgZP17vaBk4as_HwGBr4IIa?dl=0
Bulk Copy Program – BCP SQLBulk Copy Program – BCP SQL
Bulk Copy Program – BCP SQL Bulk Copy Program (BCP) – command-line tool used to import or export data against a
Pyramid Analytics – VideosPyramid Analytics – Videos
Pyramid Analytics – Videos https://www.dropbox.com/sh/8cdtdvcz1c63luq/AAAKubI0JT0dt7bYA8W6vCbza#/
Learn SSIS in 19 video lessonsLearn SSIS in 19 video lessons
01 - Getting Started 02 - Performing Basic Tasks 03 - Basic Transformations 04 - Variables 05 - Data Types
The Connection Strings ReferenceThe Connection Strings Reference
The Connection Strings Reference ConnectionStrings.com help developers connect software to data. It’s a straight to the point reference with connection
Step by step of executing SSIS 2012 package through stored procedureStep by step of executing SSIS 2012 package through stored procedure
Step by step of executing SSIS 2012 package through stored procedure http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
SSAS Cubes, Excel and SharePointSSAS Cubes, Excel and SharePoint
SSAS Cubes, Excel and SharePoint http://workerthread.wordpress.com/2012/01/10/ssas-cubes-excel-and-sharepoint-keeping-contributors-happy/
What is SSAS? Analytic services learning resourcesWhat is SSAS? Analytic services learning resources
Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool inMicrosoft SQL Server. SSAS
w3schools.com – The world’s largest web development sitew3schools.com – The world’s largest web development site
Offline version mediafire.com – w3schools.com.rar thecrazyprogrammer.com – w3schools-offline-version-download-full-website HTML HTML TutorialHTML Tag Reference CSS CSS TutorialCSS Reference JavaScript JavaScript