Blog Index

List of Posts (sorted alphabetically)

• Link (2021-Feb-16)Azure Data Factory - Array Filter on an Array [Azure]
• Link (2018-Oct-14)Azure Stream Analytics - Troubleshooting Issues [Azure]
• Link (2013-Aug-08)Date function - First day of month (EOMONTH function, T-SQL) [T-SQL]
• Link (2018-Sep-14)DAX Date Calculations - Previous Period Combined Measure (Time Intelligence) [DAX, SSAS]
• Link (2014-Jan-03)Delete/Update Techniques (T-SQL , Delete/Update) [T-SQL]
• Link (2013-Dec-19)Get The List Of All Databases/Database Size (T-SQL) [DBA, T-SQL]
• Link (2012-Aug-09)How To Determine Size Of All Tables In A Database (T-SQL, Sql Table Size) [T-SQL]
• Link (2012-Oct-06)How To Enable Xp_Cmdshell And Other Advanced Options (T-SQL) [T-SQL]
• Link (2014-Jan-06)How To Get The List Of Ssrs Reports (T-SQL, Ssrs) [SSRS, T-SQL]
• Link (2018-Aug-04)How To Insert A Picture Into Sql Table (A Correlation Name Must Be Specified For The Bulk Rowset In The From Clause) - (T-SQL) [T-SQL]
• Link (2012-Jul-23)How To Remove Html From A String (T-SQL)T-SQL [T-SQL]
• Link (2012-Aug-04)How To Remove Time From Datetime Column (T-SQL) [T-SQL]
• Link (2013-Dec-20)Ms Sql Server 2012 - Certification Path [MS Learning]
• Link (2013-Dec-23)Ms Sql Server Read Excel File (Excel 2010, 2013) - Openrowset (X64) - (T-SQL) [SSIS, T-SQL]
• Link (2012-Nov-27)Remove Tab, New Line And Return Carriage From String (T-SQL) [T-SQL]
• Link (2012-Oct-01)SQL Reporting Services maximum number of parameter items (SSRS) [SSRS]
• Link (2018-Aug-24)SQL Reporting Services Tutorial (SSRS): T-SQL vs MDX vs DAX (with parameters) [DAX, MDX, SSAS, SSRS, T-SQL, Tabular Model]
• Link (2018-Aug-28)SSIS - Import Mixed Data Types From MS Excel (Excel Driver IMEX=1) [SSIS]
• Link (2012-Nov-27)WHILE LOOP (T-SQL) [T-SQL]