-
Some years ago, I was reading one book of Itzik Ben-Gan where he explained in depth the use of a new operator: APPLY, I told myself, it just another new feature more. I didn’t understand the relevance and the many versatile applications it had, through time, I have been using APPLY in many scenarios. Saving time and resources it is a fundamental part of each TSQL development, in this short article I would like to explain a simple trick with APPLY operator.The requirement can sound exotic but is...
-
-
-
Love these skills? Find your Match.
-
-
Hi! I wrote these tips after many hours of some ERP system speed optimization. It was very helpful for me and my team. I hope it will be helpful for you too.So, lets go. Read UncommittedRead Committed + read_committed_snapshot off(alter database xxx set read_committed_snapshot off)Read Committed + read_committed_snapshot on(alter database xxx set read_committed_snapshot on)Repeatable ReadSerializableSnapshot(alter database xxx set allow_snapshot_isolation on)Tested on MSSQL 2014.
-
-
-
-
Love these skills? Find your Match.
-
-
Modern browsers support multiple compression schemes such as deflate and gzip. Using this nifty feature in your web application can contribute greatly to an improved overall user experience. In this article, we'll discuss response (gzip) compression, it's benefits and how to implement it in your ASP.NET core web application. Response compression is an effective way to improve the efficiency of any website. It helps reduce bandwidth use and dramatically speeds up your website's load time...
-
-
-
-
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
Tech job seekers, both active and passive, are willing to make a move for the right offer. But when is the right time to move? Since the technology sector is ever expanding and evolving, it is hard to know when the market is best placed for a strategic relocation into another role. According to the Bureau of Labor Statistics, the employment of tech and computer occupations is expected to grow 12% by 2024, greater than the average for all other occupations. Now more than ever it is important that...
-
-
-
Love these skills? Find your Match.
-
-
1. How much Disk Space is my Database currently using on Disk and what is the real Data Volume in the Database files?2. How close is the Data Volume to the Storage Limits?The following article will show you how to extract all relevant information using T-SQL for automation - step by step.If you simply need a quick and dirty solution without going through the details feel free to jump the code block labelled PUTTING IT ALL TOGETHER at the very end of this article.The first table we want to look...
-
-
-
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
"What is the one technology I need to learn to get a job like the one you have?" - this is a question I've received from time to time, and my answer would vary, depending on who asked. Or rather; who I perceive the questioner to be - I cannot *know* for a fact what most suits his or her particular ambitions and style.. But in the last few years my answer, more often than not, has been "PowerShell"! Simply because I see it as one of the most important and game-changing technologies to come out of...
-
-
-
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
Time Intelligence is a common issue for every OLAP structure because Time as dimension apperars in every OLAP project, in every Cube you build, despite business model or type. To handle Time Intelligence good in calculations, aggregations and optimization, you need to use Timescale as well. With Timescale I mean: MonthToDate (MTD), YearToDate (YTD), LastYear(LY) etc..., all these very important to everyday use of Business Intelligence solutions.Now, I will take you to the technical steps of implemention...
-
-
-
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
Debian 8 (Jessie) doesn't contain RoundCube in it's repositories. Why, I don't know :) .
In ISPConfig3, Perfect Server, Debian 8, you get SquirrelMail, but I don't like how it looks.
With some trouble setting it up, I managed to configure RoundCube on Debian 8 and make it wokring with ISPConfig3. Used many sources to make it work and decided to create this manual that you’re reading.I presume that you have configured your server with Perfect Server Debian 8 (Apache, BIND, Dovecot, ISPConfig 3) configuraton...
-
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
How to initiate git through sshlogin using shh~~~git
$ ssh
[email protected]
~~~creating a folder
~~~git
$ mkdir folder_name
~~~changing to that newly created folder~~~git
$ cd folder_name
~~~initiating as a master branch~~~git
$ git init --bare
~~~changing the windows pack~~~git
$ git config pack.window 0
~~~##step 5 : clone to local machine usingcloning the newly created folder to local~~~git
$ git clone
[email protected]:/home/folder_name
~~~adding the all files which are created
-
-
-
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
Recently, I was drafting some PowerShell codes and stumbled across which conditional statement should I use for a very simple task and decided to explore abit more on their performance differences.Below is a sample code that I have coded to display the result of the overall performance between some of the conditional statements method and it is purely for educational coding purposes.If anyone is interested to find out, copy the codes below, paste it on PowerShell ISE and run it.
-
-
-
-
-
-
Love these skills? Find your Match.
-
-
-
-
Love these skills? Find your Match.
-
