Target audience: Drupal 7 users Used tools: Drupal 7 What’s the purpose: unlock maintenance mode When i add content to my Drupal 7 site it suddenly says it is under maintenance. I didn’t put it in maintenance mode. Now, when i try to load my site, i see main page with message : my.site.url is… Continue reading How to unlock the site from maintenance mode
Month: November 2015
SQL Group by using LINQ
Target audience: SQL programmers Used tools: SQL,XPath What’s the purpose: read parameters for SQL query from XML variable The problem is the same, like in post “Read parameters for SQL store procedure from XML variable” but this time the resolving must be made with LINQ. In the beginning, let’s the list for checking is continuous… Continue reading SQL Group by using LINQ
SQL Group by a range of value using T-SQL
Target audience: SQL programmers Used tools: T-SQL What’s the purpose: group records from SQL data table using aggregate functions with derived tables Now, let’s try to make the ‘job’ with t-sql only. The key point here is to use aggregate functions with so called derived tables.In this article http://logicalread.solarwinds.com/when-to-apply-sql-server-derived-table we can find a definition and… Continue reading SQL Group by a range of value using T-SQL