February 2020
November 2019
March 2019
- Association rule mining for Lastfm
- Predicting the spread of prostate cancer
- Decision trees
- Clustering German Credit Data using K-Means
- We will default loan from German credit data
- None parametric (Lowess)
- Oldfaithful eruption analysis
- UNIX-Fundamentals Lecture10
- UNIX-Fundamentals Lecture9
- UNIX-Fundamentals Lecture8
- UNIX-Fundamentals Lecture7
- UNIX-Fundamentals Lecture6
- UNIX-Fundamentals Lecture5
- UNIX-Fundamentals Lecture4
- UNIX-Fundamentals Lecture3
- UNIX-Fundamentals Lecture2
- UNIX-Fundamentals Lecture1
October 2018
- Git failed with a fatal error. Authentication failed for Visual Studio
- SQL Temporary Tables
- Exists Operator
February 2018
- Impact of Sociotechnical Plan
- Accidental Innovations
- Scenario Planning Versus Traditional Forecasting
January 2018
October 2016
April 2016
- SSRS Rounding problem when doing Totals
- Tableau error occurred while communicating data source
- Cannot connect to domain-PCSF_46008
October 2014
June 2014
- Hadoop installation: Saving the key failed error
- How to check if dynamic file name for current date exists in SSIS
- How to grant permissions only to view in sql server
January 2014
- Optimizing SQL Server Tables
- The remote server returned an error 401 Unauthorized
- Cycling SQL Server Error Logs
- How to change SQL Server Authentication Mode
- Convert integer date to datetime
- Check if file exists on FTP server in SSIS
- Data Compression in SQL Server
- The server sent an unrecognizable responses
- Power BI Q&A
December 2013
- Power BI Mobile Application
- How to upload workbook to Power BI site
- How to add Power BI app to Office 365
- Provision Power BI to Tenants
- Microsoft Cloud BI Model and Power BI
- Cloud Computing Models and BI in Cloud
- How to search objects in SQL Server
- Filtering objects in SSMS Object Explorer
- EXCEPT Clause in SQL Server
- INTERSECT Clause in SQL Server
November 2013
- Concatenate multiple columns in SQL Server
- Aliasing column name in SQL Server
- How to undo SQL Server Updates
- Escaping wild characters in SQL Server
- Windows could not start the SQL Server
- The cube cannot be browsed
- Installing Informatica PowerCenter Express on Ubuntu
- Reorganize and Rebuild Indexes
- An Error Prevented the view from loading – Solved
- Informatica PowerCenter Express
- Check if file exists in SSIS
- GROUPING SETS Clause in SQL Server
- CUBE Clause in SQL Server
- ROLLUP Clause in SQL Server
- SQL Server Multiple Grouping Sets
- How to create indexed views in sql server
- Distributed Database Design
- Unable to display this Web Part External List
- What is best way to compare datetime column in sql Server
- Information about requests in SQL Server
- SSIS ADO NET Data Source Parameters
- Identify new line or carriage return in string column in SQL Server
October 2013
- SUM and COUNT BIGINT values in SQL Server
- XACT_STATE in SQL Server
- Export XML file using SSIS
- Nested AFTER Triggers in SQL Server
- AFTER triggers in SQL Server
- INSTEAD Of triggers in SQL Server
- Trigger in SQL Server
- Default Constraints
- CHECK Constraints
- Unique Constraints
- Foreign Key Constraints
- Primary Key Constraints
- SQL Server Constraints
- SQL Server update .write clause
- CAP Theorem
- Temporary Table in Stored Procedure
- SQL Server 2014 new Server Roles
- Synonyms in SQL Server
- create excel file dynamically using ssis
- SSIS create excel file
- How to alter column from varchar(max) to varbinary(max)
- XML parsing errors
- Natively Compiled Stored Procedures
- SQL Server 2014 In-Memory OLTP (Hekaton Project)
- CLR Stored Procedures
- Transact-SQL Stored Procedure in SQL Server
- SQL Server Stored Procedure
- SQL Server database stuck In Recovery State -Solved
- OUTPUT clause in SQL Server
- SQL Server Sequence Object
- Last Identity Value in SQL Server
September 2013
- SQL Server Identity Column Property
- SQL Server 2014 – Buffer Pool Extension
- Restore SQL Server 2014 database from Windows Azure storage to Windows Azure VM
- Backup SQL Server 2014 database from Windows Azure VM to Windows Azure storage
- SQL Server 2014 in Windows Azure Virtual Machines
- SQL Server 2014 columnstore index
- SQL Server 2014 IO Resource Governance
- Backup SQL Server 2014 database to Windows Azure cloud storage
- sql server 2014 new features
- How to restore database windows azure sql database
- How to Backup Windows Azure SQL Databse
- SQL Server count function
- find table in sql query
- Alter primary key in SQL Server
- Lower, Upper and Title cases in SQL Server
- How to use SP_ExecuteSQL to prevent SQL injection
- Deploy SQL Server database to Windows Azure SQL Database
- TRY_CAST(), TRY_CONVERT() and TRY_PARSE() – Compare and Contrast
- Nonclustered Columnstore Indexes
- SQL Server First_Value and Last_Value offset window functions
- SQL Server Window Offset Functions
- CROSS APPLY and OUTER APPLY Operator
- Error enabling Windows feature NetFx3 SQL Server 2014 Installation Error
- How to create sql server database role and manage its members
- Roles in SQL Server
- Run SQL Server Management Studio as another user
- Why serializability sometimes considered too restrictive for schedules
- Why concurrency control is needed for database management systems
- SOME, All and ANY operators in SQL Server
- Using XACT_ABORT with transactions
August 2013
- How to add a leaf node for a hierarchyid tree
- Quering hierarchyid nodes in SQL Server
- Representing parent-child relationship in to tree using Hierarchyid data type
- How to create a level for parent child relation in SQL Server
- Recursive query using CTE
- SQL Indentation Tools
- How to DELETE all rows incrementally without too much pressure on the server?
- Consume SQL Azure using PowerPivot
- The protection level of the package requires a password, but PackagePassword property is empty, Solved
- ERROR Handling In SQL Server
- Skipping Excel subtotal rows in SSIS without using scripts
- Interop Object Vs OLEDB Provider for Excel, Which one is better in Server Environment
- Different uses of Execute or Exec in SQL Server
- Consume SQL Azure using Excel Power Query
- Consume SQL Azure using Excel Data Connection
- Loading data to and from SQL Azure using SSIS
- Connecting to SQL Azure from SSMS
- Dynamic SQL in SQL Server
- Filtering data with OFFSET-FETCH
- Execute multiple sql server scripts multiple times without loop
- How to remove duplicate rows in sql server using window functions
- set forceplan in sql server
- FORCESEEK table hint in SQL Server
- How to Maintain Transaction in SSIS using TransactionOption
- Consume web service using proxy class