Avent IT Solutions Pvt Ltd

30/03/2018

http://www.aventits.com/Staffing.php

30/03/2018

I am praying to the Lord that holds you in his love and graces your life with his blessings every day. Best wishes on this Good Friday.

09/03/2018

Celebrating our 3rd anniversary:
3 years
36 months
156.429 Weeks
1095 days
26280 hours
1576800 Minutes
94608000 Seconds

08/03/2018

05/03/2018

SQL Server Analysis Services (SSAS):

SQL Server Analysis Services introduces many enhancements for tabular models. These include:

Tabular mode as the default installation option for Analysis Services. (CTP 2.0)

Object-level security to secure the metadata of tabular models. (CTP 2.0)

Date relationships to easily create relationships based on date fields. (CTP 2.0)

New Get Data (Power Query) data sources, and existing DirectQuery data sources support for M queries. (CTP 2.0)
DAX Editor for SSDT. (CTP 2.0)

Encoding hints, an advanced feature for optimizing data refresh of large in-memory tabular models. (CTP 1.3)

Support for the 1400 Compatibility level for tabular models. To create new or upgrade existing tabular model projects to the 1400 compatibility level,

A modern Get Data experience for tabular models at the 1400 compatibility level.

Hide Members property to hide blank members in ragged hierarchies. (CTP 1.1)

New Detail Rows end-user action to Show Details for aggregated information. SELECTCOLUMNS and DETAILROWS functions for creating Detail Rows expressions. (CTP 1.1)

16/02/2018

http://www.aventits.com/aventblog/2018/02/16/advantages-of-asp-net-framework/

Posted on February 16, 2018 by AventiansAdvantages of ASP.NET Framework MOST IMPORTANT ADVANTAGES & REASON TO CHOOSE ASP.NET FRAMEWORK .NET allows the aptitude for any user to access data or database and return results. Entire flexibility for viewing in multiple browsers including internet explorer....

08/02/2018

VMware Horizon Cloud on Microsoft Azure released an update today. In addition to a number of UI and back-end platform enhancements, we have developed several noteworthy updates to existing features. Schedule Based Power Management The initial release of Horizon Cloud on Microsoft Azure introduced po...

06/02/2018

The Language of the Future is C #:

Since C # is the most popular language in .NET, it’s necessary to include it in the conversation. While C # is a very mature language, it has an exciting future as well. Much like the .NET framework, C # is being developed as an open source project. Now that C # is open source, its development will be visible to the public, including the road map.
Much like with the .NET Standard Library, Microsoft is promising a faster release cycle with C #. These out-of-band releases will include new language features to further enhance an already robust and mature language.

In future releases we’ll see some interesting new ways for developers to write C #:

• Local functions will allow functions inside of methods that will have access to variables in scope.
• Tuples let functions return multiple results. The results can be named so that the code remains readable.
• Pattern matching extensions for C # enable many of the benefits of algebraic data types and pattern matching from functional languages, but in a way that smoothly integrates with the feel of the underlying language. Pattern matching is able to switch on the necessary type of data and offers greater flexibility when working with non-primitive data types.
• Immutable objects are a feature being discussed for beyond C #
7. Immutable objects are an explicit shorthand way of writing immutable classes with the added benefit of the compiler being able to identify them as immutable.
Because of Roslyn, the cross-platform compiler-as-a-service, C # can be written and run on any platform. Roslyn enables C # to run in IDEs (integrated development environments) and editors, and it opens the door to support from any linter, refactoring tool and code generation tooling. In the future, expect to see more uses for C # in more places.

Source:

Exciting times lie ahead for .NET developers. Earlier this year during Build, Microsoft’s biggest developer event, clear roadmaps were give.

01/02/2018

Growth of cloud storage:

Cisco estimates that the total cloud storage market will increase from 370EB in 2017 to 1.1ZB in 2018 which reinforces that this will be a particular growth area for cloud service providers. Increased regulation has driven requirements for several copies of backup data – on-premises, off-site or in the cloud and in certain industries; legislation requires longer term retention of data, often up to 10 years.
According to a 2017 Gartner survey, 42% of respondents said they would be looking to implement cloud backup in the next year, while 13% said they were already doing so. Increased availability of high-speed fibre broadband, as well as FTTP and MPLS circuits, means backup to the cloud has become much more accessible for small to medium sized businesses.
Over the last year, we have seen massive growth in the take-up of cloud backup offerings. Cloud backup is probably one of the easiest cloud services to test and adopt. For example, it takes only a few clicks within the Veeam Backup and Recovery console to add iland as a service provider and start sending backup or copy jobs to the cloud.

Source:

Cisco estimates that the total cloud storage market will increase from 370EB in 2017 to 1.

29/01/2018

SQL Server Database Engine:

SQL Server 2017 includes many new Database Engine features, enhancements, and performance improvements.

• CLR assemblies can now be added to a whitelist, as a workaround for the clr strict security feature described in CTP 2.0. sp_add_trusted_assembly, sp_drop_trusted_assembly, and sys.trusted_asssemblies are added to support the white list of trusted assemblies (RC1).
• Resumable online index rebuild resumes an online index rebuild operation from where it stopped after a failure (such as a failover to a replica or insufficient disk space), or pauses and later resumes an online index rebuild operation. See ALTER INDEX and Guidelines for online index operations. (CTP 2.0)
• The IDENTITY_CACHE option for ALTER DATABASE SCOPED CONFIGURATION allows you to avoid gaps in the values of identity columns if a server restarts unexpectedly or fails over to a secondary server. See ALTER DATABASE SCOPED CONFIGURATION. (CTP 2.0)
• A new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions. For this first version of the adaptive query processing feature family, we have three new improvements: batch mode adaptive joins, batch mode memory grant feedback, and interleaved ex*****on for multi-statement table valued functions. See Adaptive query processing in SQL databases.
• Automatic database tuning provides insight into potential query performance problems, recommends solutions, and can automatically fix identified problems. See Automatic tuning. (CTP 2.0)
• New graph database capabilities for modeling many-to-many relationships include new CREATE TABLE syntax for creating node and edge tables, and the keyword MATCH for queries. See Graph Processing with SQL Server 2017. (CTP 2.0)
• An sp_configure option called clr strict security is enabled by default to enhance the security of CLR assemblies. See CLR strict security. (CTP 2.0)
• Setup now allows specifying initial tempdb file size up to 256 GB (262,144 MB) per file, with a warning if the file size is set greater than 1GB with IFI not enabled. (CTP 2.0)
• The modified_extent_page_count column in sys.dm_db_file_space_usage tracks differential changes in each database file, enabling smart backup solutions that perform differential backup or full backup based on percentage of changed pages in the database. (CTP 2.0)
• SELECT INTO T-SQL syntax now supports loading a table into a FileGroup other than the user's default by using the ON keyword. (CTP 2.0)
• Cross database transactions are now supported among all databases that are part of an Always On Availability Group, including databases that are part of same instance. See Transactions - Always On Availability Groups and Database Mirroring (CTP 2.0)
• New Availability Groups functionality includes clusterless support, Minimum Replica Commit Availability Groups setting, and Windows-Linux cross-OS migrations and testing. (CTP 1.3)

New dynamic management views:

o sys.dm_db_log_stats exposes summary level attributes and information on transaction log files, helpful for monitoring transaction log health. (CTP 2.1)
o sys.dm_tran_version_store_space_usage tracks version store usage per database, useful for proactively planning tempdb sizing based on the version store usage per database. (CTP 2.0)
o sys.dm_db_log_info exposes VLF information to monitor, alert, and avert potential transaction log issues. (CTP 2.0)
o sys.dm_db_stats_histogram is a new dynamic management view for examining statistics. (CTP 1.3)
o sys.dm_os_host_info provides operating system information for both Windows and Linux. (CTP 1.0)
• The Database Tuning Advisor (DTA) has additional options and improved performance. (CTP 1.2)
• In-memory enhancements include support for computed columns in memory-optimized tables, full support for JSON functions in natively compiled modules, and the CROSS APPLY operator in natively compiled modules. (CTP 1.1)
• New string functions are CONCAT_WS, TRANSLATE, and TRIM, and WITHIN GROUP is now supported for the STRING_AGG function. (CTP 1.1)
• There are new bulk access options (BULK INSERT and OPENROWSET(BULK...) ) for CSV and Azure Blob files. (CTP 1.1)
• Memory-optimized object enhancements include sp_spaceused and elimination of the 8 index limitation for memory-optimized tables, sp_rename for memory-optimized tables and natively compiled T-SQL modules, and CASE and TOP (N) WITH TIES for natively compiled T-SQL modules. Memory-optimized filegroup files can now be stored, backed up and restored on Azure Storage. (CTP 1.0)
• DATABASE SCOPED CREDENTIAL is a new class of securable, supporting CONTROL, ALTER, REFERENCES, TAKE OWNERSHIP, and VIEW DEFINITION permissions. ADMINISTER DATABASE BULK OPERATIONS is now visible in sys.fn_builtin_permissions. (CTP 1.0)
• Database COMPATIBILITY_LEVEL 140 is added. (CTP 1.0).
For more information, see What's new in SQL Server 2017 Database Engine.

18/01/2018

Exponential growth in cloud services solutions:

Software as a Service (SaaS) opened a flexible and financially attractive door for businesses and consumers to try early cloud services. The growth of infrastructure and platform as a service (Iaas and PaaS, respectively) has expanded the number of cloud solutions available in the public and private sectors. In 2018, we expect to see many more organizations take advantage of the simplicity and high-performance the cloud guarantees.

According to a forward-looking survey on cloud services from Cisco, these solutions will continue to be deployed and used worldwide to accomplish diverse goals on an unprecedented level. 2018 will see SaaS solutions take the cake as the most highly deployed cloud service across the globe. The Cisco survey also forecasts that SaaS will account for 60% of all cloud-based workloads—a 12% increase over 2017 predictions. PaaS solutions will experience a modest five percent growth rate, while IaaS solutions are also set to increase. Given that these projections were made in 2016 and given positive performance in 2017, we can reasonably expect even greater growth in cloud services solutions than these predictions. Businesses that want to simplify operations and make it easier for their customers to access services will move more aggressively toward integrating SaaS, IaaS, and/or PaaS into their business processes.