dataindataout.wordpress.com
July 2016 – Data In Data Out
https://dataindataout.wordpress.com/2016/07
Data In Data Out. Running Mobius Spark – The system cannot find the path specified error. July 29, 2016. July 30, 2016. Is a project to enable using C# to develop against Apache Spark. The project page on GIT has the directions to set up and use Mobius. However, when I tried those, I ran into “The system cannot find the path specified” error. Essentially, the error is because the various directory and file paths referred to in the scripts did not exist on my machine. On my machine though, the path. Likew...
dataindataout.wordpress.com
July 2014 – Data In Data Out
https://dataindataout.wordpress.com/2014/07
Data In Data Out. Connecting Tableau to SQL Server – Impersonation options. July 20, 2014. July 21, 2014. When publishing a Data Source to Tableau Server, you can choose to impersonate another user. Impersonation helps to apply the security context that is specific to the user being impersonated; in case of Tableau, it will be the user logging into Tableau; thus allowing the tableau user to only see the data that he/she is allowed to see. Continue reading →. Connecting Tableau to SQL Server. July 20, 2014.
dataindataout.wordpress.com
SQL Server Stored Procedures in Tableau – Part 1 – Data In Data Out
https://dataindataout.wordpress.com/2014/08/11/sql-server-stored-procedures-in-tableau-part-1
Data In Data Out. SQL Server Stored Procedures in Tableau – Part 1. August 11, 2014. This series of posts attempt to look at the pros and cons of using Stored Procedures as data access method for Tableau reports. The points made here are valid as of Tableau 8.2. Gives a general introduction and identifies areas where some of SProcs advantages become irrelevant when it comes to Tableau. Looks at metadata considerations. Looks at Execution Plan considerations. Portability to an extent. A typical non-BI app...
dataindataout.wordpress.com
Connecting Tableau to SQL Server – Impersonation options – Data In Data Out
https://dataindataout.wordpress.com/2014/07/20/connecting-tableau-to-sql-server-impersonation-options
Data In Data Out. Connecting Tableau to SQL Server – Impersonation options. July 20, 2014. July 21, 2014. When publishing a Data Source to Tableau Server, you can choose to impersonate another user. Impersonation helps to apply the security context that is specific to the user being impersonated; in case of Tableau, it will be the user logging into Tableau; thus allowing the tableau user to only see the data that he/she is allowed to see. Impersonation is achieved by running the command EXECUTE AS USER =...
dataindataout.wordpress.com
samskolli – Data In Data Out
https://dataindataout.wordpress.com/author/samskolli
Data In Data Out. Running Mobius Spark – The system cannot find the path specified error. July 29, 2016. July 30, 2016. Is a project to enable using C# to develop against Apache Spark. The project page on GIT has the directions to set up and use Mobius. However, when I tried those, I ran into “The system cannot find the path specified” error. Essentially, the error is because the various directory and file paths referred to in the scripts did not exist on my machine. On my machine though, the path. Likew...
dataindataout.wordpress.com
Bulk Inserts into SQL Server – Data In Data Out
https://dataindataout.wordpress.com/2016/07/25/bulk-inserts-into-sql-server
Data In Data Out. Bulk Inserts into SQL Server. July 25, 2016. July 26, 2016. Loading data in bulk is a common occurrence in the analytic world. Recently, I had to revisit some of the concepts with bulk loading and the following is some of the notes I have gathered. It is well known that for any high volume inserts, various things. Disclaimer: Most of the information is gathered from two primary resources. One is this web page. BULK INSERT (Transact-SQL Statement). BCP (Bulk Copy Program). There are coup...
dataindataout.wordpress.com
SQL Server Stored Procedures in Tableau – Part 4 – Behind the scenes – Data In Data Out
https://dataindataout.wordpress.com/2014/08/11/sql-server-stored-procedures-in-tableau-part-4-behind-the-scenes/comment-page-1
Data In Data Out. SQL Server Stored Procedures in Tableau – Part 4 – Behind the scenes. August 11, 2014. August 11, 2014. This series of posts attempt to look at the pros and cons of using Stored Procedures as data access method for Tableau reports. The points made here are valid as of Tableau 8.2. Gives a general introduction and identifies areas where some of SProcs advantages become irrelevant when it comes to Tableau. Looks at metadata considerations. Looks at Execution Plan considerations. Creating ...
dataindataout.wordpress.com
August 2014 – Data In Data Out
https://dataindataout.wordpress.com/2014/08
Data In Data Out. FMTONLY Temp table and Metadata Workaround. August 11, 2014. This piece of code is self-explanatory. IF OBJECT ID(N'[dbo].[FMTONLY Example]’, N’P’) IS NOT NULL. DROP PROCEDURE [dbo].[FMTONLY Example]. CREATE PROCEDURE dbo.FMTONLY Example() AS. When FMTONLY is ON:. 1 Variable declaration and assignments are done. 2 All branches of a if-else statement are considered; even if the condition is not satisfied. DECLARE @fmtOnly BIT — Variable to see if FMTONLY ON is true or not. Various differ...
dataindataout.wordpress.com
SQL Server Stored Procedures in Tableau – Part 3 – Execution Plan – Data In Data Out
https://dataindataout.wordpress.com/2014/08/11/sql-server-stored-procedures-in-tableau-part-3-execution-plan
Data In Data Out. SQL Server Stored Procedures in Tableau – Part 3 – Execution Plan. August 11, 2014. August 11, 2014. This series of posts attempt to look at the pros and cons of using Stored Procedures as data access method for Tableau reports. The points made here are valid as of Tableau 8.2. Gives a general introduction and identifies areas where some of SProcs advantages become irrelevant when it comes to Tableau. Looks at metadata considerations. Looks at Execution Plan considerations. Exec sp prep...
SOCIAL ENGAGEMENT