SQL - Study Material
Thursday, May 27, 2021
Power Shell Commands
›
$psversiontable : Provides version of windows PowerShell
Get the cube size from PowerShell script
›
#### SSAS Size ### Param($ServerName=”localhost”) $loadInfo = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisS...
Sunday, June 7, 2020
Import Data to excel from tabular model using DAX
›
https://www.sqlbi.com/articles/import-data-from-tabular-model-in-excel-using-a-dax-query/
Tuesday, August 21, 2018
Import JSON from SQL
›
SELECT p . Id , p . FirstName , p . LastName , p . BirthDate FROM OPENROWSET ( BULK 'C:\temp\PeopleL...
Monday, November 2, 2015
Interview Questions
›
Interview 1 Explain about the project Tell me abou the challenges faced in your project Different configuration options in ssis Di...
Wednesday, April 15, 2015
Interesting T - SQL Queries (T - SQL Interview Questions)
›
Question 1 Write a single DML statement to replace 0 with 1 & 1 with 0? Answer create table #temp ( nm varchar ( 10 ), id ...
Wednesday, April 8, 2015
Specifying the password of SSIS Package while executing it as SQL Job
›
Normally when we create SSIS packages, in connection managers we may specify the password for some connections. It can be SQL authenticatio...
›
Home
View web version