Cameron Oliver

Format APEX code Visual Studio code

Personally, I use the following extensions for vscode: Salesforce Extensions for VS Code - A package of Salesforce made extensions for editing code. Provides syntax highlighting & will recognize salesforce files based on their extension. Pretty much a must have for working with sfdx. Apex PMD - provides a tool to…

Salesforce

Answered Jul 9, 2021 · 2.0K Views Read answer →

What is the use of ApexPages.StandardController? [closed]

When this VisualForce page is loaded, two controllers are instantiated: the standardController for account, and your myControllerExtension. Your VisualForce page can call methos from either of those controllers: The standardController offers out-of-the-box operations like save (either create or update) or delete.Your…

Salesforce

Answered Jul 3, 2021 · 1.5K Views Read answer →

Pandas: sum up multiple columns into one column without last column

For pandas sum multiple columns, you can perform this by first selecting it by iloc and then apply sum: df['Fruit Total']= df.iloc[:, -4:-1].sum(axis=1) print (df) Apples Bananas Grapes Kiwis Fruit Total 0 2.0 3.0 NaN 1.0 5.0 1 1.0 3.0 7.0 NaN 11.0 2 NaN NaN 2.0 3.0 2.0 And getting the total of all columns, you can…

Big Data Hadoop

Answered Jun 24, 2021 · 1.6K Views Read answer →

Implementing a SOA in Django using celery

A message queue (such as rabbitmq brokered by celery) is a perfectly fine way to handle communication between SOA components. Additionally, if you need real-time communication without sharing databases between services, REST is basically made for this. There are several options for implementing REST services on top of…

Spark

Answered Jun 9, 2021 · 1.7K Views Read answer →

How to fix invalid syntax error when using “print”?

To solve invalid syntax python print you should add the parenthesis, like this: print()Example is probably for the older python 2, which didn't use parentheses for print. Reasons are that in python 2.x print is a keyword, whereas in python >3 it's a function. For beginners, that is the biggest difference between…

Python

Answered Jun 7, 2021 · 4.0K Views Read answer →

How sql server string concatenation done for large strings?

An operator in a string expression that concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression (a string operator). For example SELECT 'book'+'case'; returns bookcase . Transact-SQL Syntax Conventions. It might depend on what is meant by "too…

AWS

Answered Apr 30, 2021 · 1.5K Views Read answer →

Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)

Microsoft SQL Server, Error: 18456 Solution by Pinal Dave: Create a new user with Administrator privilege with the same username and password as SQL Server 2008 in the operating system. On SQL Server database create a new user by expanding DatabaseNode >> Security >> Login >> Create New User and add this new user with…

SQL Server

Answered Apr 30, 2021 · 1.2K Views Read answer →

How SQLServer add a default value for a column?

SQL Server add column with default using: TER TABLE table_name ADD column_name tada_type NOT NULL CONSTRAINT constraint_name DEFAULT default_value; ALTER TABLE table_name ADD column_name data_type NULL CONSTRAINT constraint_name DEFAULT default_value WITH VALUES;SQL Servers DEFAULT is SET QUOTED_IDENTIFIER ON and with…

SQL Server

Answered Apr 24, 2021 · 1.8K Views Read answer →

What are the differences between sql server varchar vs.nvarchar ?

SQL server varchar vs.nvarchar The key difference between varchar and nvarchar is the way they are stored, varchar is stored as regular 8-bit data(1 byte per character) and nvarchar stores data at 2 bytes per character. Due to this reason, nvarchar can hold upto 4000 characters and it takes double the space as SQL…

SQL Server

Answered Apr 24, 2021 · 634 Views Read answer →

Is table partitioning improving performance? Is it worth it?

Using SQL Server partitioning is only going to help your query performance if the partitioning scheme is built to serve your specific queries. You're going to have to review your query patterns and see how they are accessing the table in order to identify the best approach. The reason for this is you can only…

SQL Server

Answered Apr 24, 2021 · 284 Views Read answer →

:While attempting to connect to a SQL Server on remote computer on home network getting "Network-related or instance-specific error".

This is a SQL connection error, to resolve this, if your database server is SQL Server, do the following: Stop the Lansweeper Server service in Windows Services. Stop your web server service in Windows Services. Make sure the SQL Server and SQL Server Browser services are running at all times on the server hosting…

SQL Server

Answered Apr 23, 2021 · 92 Views Read answer →

What is the difference between instance name and instance id in SQL Server?

INSTANCE NAME = Is attached to a SERVER NAME just like the way it's stated. When you try to connect to an SQL Database you need the server to be able to get in. It's all about the networking and properties of your Physical or Virtual machine hosting your DATABASE. INSTANCE ID = Is attached to SQL Instance Name. Once…

SQL Server

Answered Apr 23, 2021 · 26 Views Read answer →