a developer's notebook
In Azure if you have two or more SQL Databases and you want to perform a query across them, you might come across the following error:
1 | Reference to database and/or server name in '[database table]' is not supported in this version of SQL Server. |
In order to perform cross database queries among SQL Azure databases you need to use the elastic database query feature. What is the Elastic Database Query Feature? The elastic database query feature enables you to run a Transact-SQL query…
What is it? EditorConfig helps developers define and maintain consistent coding styles between different editors and IDEs. The EditorConfig project consists of a file format for defining coding styles and a collection of text editor plugins that enable editors to read the file format and adhere to defined styles. EditorConfig files are easily readable and they work nicely with version control…
Node.js is updating quite frequently these days, so using your terminal on a Mac or command line on Windows would make update process faster. Updating Node.js on a Mac To update node.js on a mac, through terminal, you have a lot of options through popular package managers or node.js version managers. N N is a very simple node.js version management system. If you don’t have it,…
In Windows when you want to copy the path for your folder you click on the address bar and simply copy-paste the address path, but in Finder- in your Mac- you don’t have that option. So how you do that then? The process is very simple and is going to be described in the next few steps. Launch Automator Create Service…
There are some scenarios where you might want to reinstall nuget packages in your projects, like for example: Project Retargeting or Upgrade This can be useful when a project has been retargeted or upgraded and if the package REQUIRES reinstallation due to the change in target framework. You Broke the Project In case, you have inadvertently modified contents installed from a…
Today I feel quite relieved. Yesterday I organized my first big event, Athens Azure Bootcamp 2016, part of a much larger event called Global Azure Bootcamp 2016, with the help of a very good friend of mine, Kostas Pantos. What is the Global Azure Bootcamp? In short, it’s a one-day deep dive class into Azure, the objective of which is to help…
A MIME type is a two-part identifier for file formats and format contents transmitted on the Internet. It consists of a type, a sub-type and optional parameters. When publishing a new website in Azure WebSites, you may find out that not all file types can be served without some prior configuration. For example, if your site needs to serve custom fonts, either for icons…
Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language, built on the .NET Framework. You can search for it, using Windows Search, but probably you already have it installed on your computer. On top of the standard command-line shell, you can also find the Windows PowerShell ISE, which…
In Azure portal, if your account contributes to other azure subscriptions, you are allowed to switch from one to another using a drop-down menu at the top left corner. Problem is that by default the name used in Azure Active Directory is “Default Directory” which seems a little confusing. In order to change it to something more meaningful you can use the old windows azure portal,…
These are some quick notes on how to configure an SQL Server to Listen on a Specific TCP port. Open Run Command line and type: SQLServerManager12.msc for SQL Server 2014 SQLServerManager11.msc for SQL Server 2012 SQLServerManager10.msc for SQL Server 2008 and press Enter. To assign a TCP/IP port number to the SQL Server Database Engine In SQL Server Configuration Manager, in the console…
