During the last US presidential election we extracted some important critical information from the presidential debate to help profile the candidates. This year we are performing the same […]
Visual Studio – The process cannot access the file because it is being used by another process
Cannot delete the file “C:\……t\LoadExcelFiles.ispac”: The process cannot access the file ‘C:\…..LoadExcelFiles.ispac’ because it is being used by another process The above error common message that we encounter […]
Pattern matching vs Fuzzy Lookup in SQL Server
I recently came across a post in Linkedin about a script that performs Pattern Matching or “Fuzzy Lookup” within TSQL. The Script was definitely an elegant solution to […]
Adding CSV files as linked Server Connection
I often get a lot of migration projects where the data needs to port from CSV format into SQL Server. Here is a quick way I achieve it […]
administration / MSBI / MSSQL / TSQL / Uncategorized
#sqlhelp | should you remove indexes from tables before ETL?
Starting today we are introducing a new type of blog content which covers questions from #sqlhelp. We pick random questions from the feed and try to cover them […]
Charting controls: – Things to keep in mind – Part 2
In this second part of the series on charting controls we take a look at a few lesser known charting controls. You can view the first part of […]
Charting controls: – Things to keep in mind
I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to […]
Creating subfolders within SSAS
Recently there was a requirement for organizing columns from certain dimensions into individual entities within the presentation layer of powerview and powerbi. The approach that was taken was […]
Tracing Analysis Services – the trace that won’t stop
I am currently facing an issue where profiler is running a trace on SSAS and the trace can’t be stopped from within SSMS profiler since it keeps throwing […]
Loading Resumes and searching them using SQL Server – Part 2/2 (PDF+ FileTable + Full Text Search)
In this post we continue after creating our file table and posting some pdf documents into it. For the previous post please click here. Apparently there is very […]