DataBaseNews

[sqlmasterclass]

Idera - Search for the best SQL Management tool

Much less-than-most appropriate performance of database packages could have a large impact on every aspect of your commercial enterprise. To avoid that, database performance management tools can assist enhance the reaction time and efficiency of your databases and the applications that run on them, whilst also removing unplanned downtime. but finding out which carriers and technology make the maximum sense on your agency may be complicated and hard.

Many businesses observe database overall performance control equipment to treatment a selected, habitual trouble it really is affecting usability, responsiveness and person delight. but no longer every device can remedy each trouble, so understanding the excessive-stage purpose of the hassle to hand can help to slender down the listing of gear to be considered.

It's viable to make the software evaluation and choice process workable, but. right here, we display you a way to simplify it; similarly, we study merchandise from 9 of the main database performance control carriers to help you decide that's right for you.

Step one of a problem-driven product evaluation is to decide whether the problem includes the database control system (DBMS) itself; the shape of the database, such as index storage and corporation; or inefficient SQL database code. after you try this, you can restrict your database overall performance device evaluation to the appropriate software program category. this will drastically lessen the quantity of effort, as many precise equipment and a few providers may be removed based on the functionality presented.

As an example, when you have database fragmentation issues, you ought to study merchandise from BMC software, CA technologies, Quest and Idera Inc. For DB2 for z/OS customers, BMC's performance for DB2 Databases and CA's Database Analyzer and speedy Reorg can be used to discover and optimize disorganized database structures. For Oracle; Microsoft square Server; and DB2 for Linux, Unix and home windows -- or LUW -- users, Quest's Toad offers database fragmentation remediation, as does Idera's DBArtisan. (Editor's notice: On Nov. 1, 2016, Francisco partners and Elliott management Corp. finished their acquisition of the Dell software program organization and relaunched Quest as a new standalone employer.)

For database system monitoring, keep in mind products from Quest, SolarWinds, Bradmark technology and Idera. Database directors (DBAs) can use Quest's Foglight for Cross-Platform Databases to proactively screen their database, SQL database question, garage and virtualization performance. SolarWinds Database overall performance Analyzer is a database overall performance tracking and evaluation product for DBAs and alertness teams that offers wide help for unique database control gadget platforms. Bradmark's flagship imparting, Surveillance DB, is a heterogeneous, agent-pushed database performance reveal that offers Visibility to overall performance metrics for more than one DBMSes from a unmarried console. Idera's multi-platform database overall performance tracking device is the perfect application performance Platform. despite the fact that precise is predominantly an software overall performance control device, it has specialized database performance tracking alternatives for Oracle, DB2, square Server and SAP Adaptive Server agency with SAP HANA aid forthcoming. For DB2 for z/OS database device tracking, remember IBM's OMEGAMON, BMC's MainView and CA's SYSVIEW performance management choice for DB2 for z/OS.

For SQL database monitoring and analysis, bear in mind such products as Oracle organisation supervisor and IBM data Server supervisor with question screen. Microsoft also has square performance management options for its SQL database Server databases. in the DB2 for z/OS realm, in addition to the IBM alternative, BMC's performance for DB2 SQL database suite of gear and CA's Detector and Plan Analyzer products may be used for capturing -- identifying square as it runs -- and tuning square statements. For Oracle and SQL database Server, products along with Idera's DB Optimizer and Quest Toad's square optimization functionality can be used to boom the performance of your square code throughout the main relational DBMSes.

Of path, once in a while you won't recognise the underlying reason of database performance issues. In such cases, the pleasant approach is to start with a database system screen. most database performance carriers provide such tools, and many encompass rudimentary database fragmentation evaluation and SQL database monitoring talents with them.

Source : http://www.businesswire.com

Find more here : http://wiki.idera.com

[sqlmasterclass]

SQL tools ? How about Idera ?

Square Workload evaluation enhances square Diagnostic manager with continuous light-weight sampling of all square transactions mixed with an easy browser user interface for unique transaction evaluation. All dimensions of SQL database overall performance are uncovered on a unmarried display screen and drill-right down to root reasons may be executed in a few mouse clicks. The product also enables non-DBAs perceive how packages are strolling and wherein they may be creating bottlenecks within the database.

“The launch of square Workload evaluation affords an essential device with a view to assist customers ensure most beneficial utility performance,” said Scott Stone, organization product manager at IDERA. “With SQL database Diagnostic supervisor seasoned, square Workload evaluation combines good sized database aid tracking with deep, easy-to-use overall performance analysis and pointers to help you remedy any issues that might come up. It’s like having an additional MVP DBA in your group.”

“IDERA SQL database Workload analysis makes my process plenty simpler by digesting statistics from square Diagnostic supervisor and helping me resolve database problems,” says Rick Laufer, SQL database DBA at appoint Bridge, one in all the largest specialty staffing providers within the united states. “whilst supplying tuning tips like adding an index, I’m always asked, ‘What queries will that help?’ With square Workload evaluation, I can answer that question and provide percentage overall performance will increase. And that makes my boss glad.”

IDERA designs effective software with one purpose in thoughts – to solve clients’ most complex challenges with elegant answers. We don’t abide via the belief that a professional must sacrifice powerful features and fine for instant time to fee and simplicity of use. With IDERA, you certainly will have all of it. Our unique DNA is bolstered by way of a person community of almost one hundred,000 database and IT experts who use and evangelize our equipment. From our award-prevailing square Server database solutions to multi-platform database, utility and cloud monitoring gear, IDERA ensures your enterprise by no means slows down.

  Source : http://www.businesswire.com

Check tools at : https://www.idera.com

[sqlmasterclass]

Dynamic Masking for Database

All through current articles published in this forum, we have defined some of security-related functions constructed-into Azure SQL database Database, along with, most substantially, obvious information Encryption, Row-level protection, and Azure SQL database Database Auditing. Their availability reflects the steady effort with the aid of Microsoft to offer purposeful parity between Azure SQL database Database and square Server instances jogging in Azure digital machines in addition to on your on-premises surroundings. some other example of this fashion is help for Dynamic information masking, which we are able to cover in this text.

Dynamic information overlaying gives the potential to restriction visibility of touchy information saved in relational database tables reachable to non-privileged users. This capability, supported starting with square Server 2016 and gift inside the modern-day version of Azure square Database is based on a custom policy described at the database level. The policy specifies one or extra filters that ought to be implemented to the result set again in reaction to consumer or utility initiated queries. This functionality helps eventualities wherein database-resident content need to no longer be absolutely uncovered to database users. this is typically required whilst referencing information containing personally Identifiable records (PII), such as Social security Numbers (SSNs), credit score card numbers, or electronic mail addresses. by means of applying Dynamic data covering, you may ensure that handiest a part of the applicable column (as an instance, the final 4 digits of a SSN) is found in its authentic form in a result set.

A Dynamic information masking coverage consists of the subsequent components:

    Protecting rule - a hard and fast of residences that determine columns to which the protecting functions assigned via the coverage need to practice. The homes include a database schema call, desk name, and column name.

    Protecting area layout - the format that determines the algorithm to be implemented to the content material of the unique column. you've got the subsequent discipline codecs available to you:

        Default fee - the algorithm is depending on the statistics form of the fields you designate. mainly, for sting facts kinds (which include nchar, ntext, and nvarchar), the mask will include a series of XXXX characters. For numeric facts sorts (which includes bigint, bit, decimal, int, money, numeric, smallint, smallmoney, tinyint, float, and real), the ensuing fee can be simply zero. For date facts types (inclusive of date, datetime2, datetime, datetimeoffset, smalldatetime, and time), the masks will yield 01-01-1900. For any unique records types (as an example, timestamp desk, hierarchyid, GUID, binary, image, or varbinary spacial), a masked query will go back an empty price.

        Credit card cost - the set of rules consequences in displaying only the remaining four digits of the entire range, replacing all of the previous ones with a series of X characters.

        E-mail - the set of rules exhibits best the first letter of the email cope with and replaces the domain component with XXX.com. each of the remaining characters (with the exception of @) is substituted with X.

        Number (random number range) - the set of rules generates a random quantity, which fee relies upon on the underlying statistics type and the From-To variety which you designate.

        Custom string - the set of rules permits you to specify a distinct variety of characters from the start and the end of the text of the target subject. It also applies a custom-described padding string to the in-among part of the sphere. this option may be leveraged to mask entries containing Social protection Numbers.

    Excluded users - you have the option of granting the capacity to view unobfuscated statistics to individual, non-privileged database customers in addition to Azure active listing users and companies. notice that statistics covering does no longer practice to queries submitted by privileged users.

Returned on the Dynamic records masking blade, click on store to shop your trade. click review to return to the number one view of the database and next click on equipment. at the equipment blade, click on query editor (preview). be given the preview phrases and, from the query editor (preview) blade, click on Login. Use the SQL database server authentication option to log in with the admin account you created whilst provisioning the server.

Source : http://www.databasejournal.com

[sqlmasterclass]

Why you should run SQL Server on Windows Server [pt. 1]

If he lived nowadays, Sherlock Holmes is probably a records scientist, running to remedy cases quicker by using using superior analytics to enhance his legendary deductive powers. Sherlock could insist at the fastest way feasible of achieving insights. So what’s the excellent way to process large amounts of statistics quickly to get faster time to perception?

It’s simple: Sherlock could deduce that square Server 2016 and windows Server 2016 are an notable platform in delivering built-in fast analytics via going for walks queries at the point of creation.

at the OS stage, home windows Server 2016 gives you new ranges of performance with capabilities together with continual reminiscence (or storage elegance reminiscence), which improves latency via 3x, and storage spaces Direct, which offers you distinctly available, scalable garage area community (SAN) functionality on inexpensive enterprise-preferred servers and produces study speeds that could exceed 25GB/2nd.

those functions are integrated to the OS, so no additional licenses are required. For full details on windows Server 2016 rate/overall performance benefits, examine the weblog publish.

moreover, on the statistics platform degree, sq. Server 2016 grants revolutionary analytics gear along with square Server R offerings, actual-time operational analytics, and new R-models.

mixed, square Server 2016 and home windows Server 2016 provide multi-threading and hugely parallel processing for excessive-overall performance information evaluation.

With sq. Server 2016, you could do real-time operational analytics in two approaches: on disk-primarily based and reminiscence-optimized tables. this means you don’t must make adjustments in your packages when you perform real-time analytics.

sq. Server 2016 real-Time Operational Analytics lets you use columnstore indexes to run analytics queries without delay in your operational workload. discern 1 indicates a probable configuration, which makes use of evaluation Server in Direct question mode, however if you have different analytics equipment or a custom solution, you may use the ones, too. whilst you use both reminiscence-optimized and columnstore, you get the satisfactory of on line transaction processing (OLTP) performance and analytics question performance. learn extra about actual-time operational analytics the use of in-memory technology.

The cloud is built into sq. Server 2016, making it feasible that allows you to take advantage of multi-threading and big parallel processing (MPP) to obtain high-performance records analysis. Azure square records Warehouse uses an elastic MPP architecture constructed on the sq. Server 2016 database engine. this indicates you can maintain using the sq. Server-based equipment and BI programs which you use these days while you need to interactively question and examine data. It has built-in overall performance analytics and garage compression, the aggregation talents of sq. Server, and current question optimization competencies. further, with Polybase built in, you can question Hadoop systems immediately, so that you have a unmarried square-based query floor for all of your data.

Source : https://blogs.technet.microsoft.com

[sqlmasterclass]

Backup of SQL server through Azure

Inside the beyond we've got discussed the automated backup abilities of SQL database Server instances deployed to Azure digital machines. these capabilities depend on both a devoted Azure VM Agent extension or on device saved processes introduced in SQL database Server 2014, with a view to switch backup files at once into Azure garage blobs. In this newsletter, we are able to offer a extra comprehensive overview of the distinct backup alternatives relevant to Azure IaaS SQL database Server workloads.

In fashionable, you have the following alternatives for backing up databases residing on SQL database Server instances which can be hosted through Azure digital machines:

    local square Server backup at once to an Azure storage blob. This functionality, typically called backup to URL, was added in SQL database Server 2014 and further more desirable in square Server 2016. The preceding version of SQL database Server supported handiest page blobs. The present day one permits you to pick out among web page and block blobs. the selection of the blob type has implications in regard to the most backup size and throughput. greater specially, whilst using web page blobs, the ensuing backup cannot be large than 1 TB, in view that that is the maximum page blob length. similarly, standard garage throttles consistent with-blob throughput at approximately 60 MB/sec (backup to premium storage web page blobs is presently not supported). you may take away these restrictions via the usage of block blobs as a substitute. With this approach, it turns into feasible to stripe individual backups across as much as 64 block blobs. at the same time as the most supported length of a block blob is presently four.77 TB, square Server interacts with Azure garage thru an older API that restricts the size of a block blob to approximately 195 MB, yielding the most backup size of 12.8 TB. by way of virtue of counting on striping for disk writes, you also gain from increased throughput.

    native square Server backup to a neighborhood record machine volume.Such quantity is created by way of the usage of one or greater digital disks connected to the Azure VM in which the SQL database Server instance is hosted. starting with windows Server 2012, to create multi-disk volumes in Azure VMs, it's miles endorsed to use garage areas with a simple layout, which corresponds to traditional disk striping with out parity. to enhance performance, you ought to make certain that the variety of columns in a stripe fits the number of underlying disks. For up to 8 disks, this is configured robotically when creating a garage areas-primarily based quantity through Server supervisor, however while managing a larger number of disks, you'll want to apply windows PowerShell instead and explicitly specify the wide variety of columns. The potential of the volume is determined by way of the quantity of disks and their individual sizes. The most length of a disk matches the maximum size of a page blob (1 TB), when you consider that virtual disk files are saved as page blobs. the biggest Azure VMs (G5 and GS5) assist up to sixty four facts disks.

     when attaching data disks to the Azure VM, you have the choice of the use of both controlled or non-controlled disks. the first of these strategies gets rid of the want to remember storage account constraints. for instance, with non-managed popular garage disks, you need to remember that a unmarried garage account has the limit of 20,000 IOPS, which restricts the range of disks that should be saved in the same storage account to 40 (considering that every preferred garage disk offers more or less 500 IOPS). With controlled disks, placement of disks in an premiere way throughout a couple of storage debts is dealt with mechanically by means of the platform.

    From the disk I/O perspective, multi-disk volume traits depend upon the storage type. With popular storage, the overall throughput of a single extent is an aggregate of the throughput of character disks. this means that so one can calculate the most throughput, you virtually need to multiply the number of disks by means of 60 Mbps. With premium garage, with a view to determine the supported throughput, you need to remember no longer most effective the wide variety of disks and their individual I/O traits, but additionally the Azure VM size (the throughput and request fee are throttled at the digital machine level - for specifics, talk over with Microsoft Azure documentation). word that, in the context of a local SQL database Server backup, the reads from the source disks as well as writes to the goal disks count closer to the Azure VM bandwidth restrict.

    in an effort to protect the local backups, you should reproduction them to a long time storage across  Azure areas. One manner to perform that is to apply Azure Backup with geo-redundant recuperation services vault. whilst you could potentially place the virtual machine disk files in a geo-replicated fashionable storage account (top rate garage supports most effective the domestically redundant replication alternative), this is applicable simplest to unmarried disk volumes (multi-disk garage spaces-based volumes with disks stored in geo-replicated Azure garage accounts aren't supported), which limits the backup size to at least one TB.

     An thrilling variation of this technique entails backup to the neighborhood SSD-based transient disk, which is available with the general public of Azure VM sizes. even as it's far critical to remember that the brief disk (D: pressure on home windows running system) have to now not, because the call indicates, be used for any content material that ought to persist throughout the Azure VM lifetime (which include such events as a failure of the underlying Hyper-V host), there may be a great overall performance benefit to counting on it as an intermediate keep for local backups (which you may eventually replica to a chronic, lengthy-term garage) when the use of top rate garage records disks. The gain effects from the truth that the usage of local SSD disks does no longer count toward the Azure VM premium garage-related I/O constraints noted above. this means that you might be capable of completely make use of the throughput of the nearby SSD storage with out affecting the throughput of the premium storage-based totally disks. this applies as long as you do not rely upon the local SSD garage for top class storage caching.

     square Server report-level backup leverages the capacity to work independently with person square Server facts files and document businesses. As a result, you've got more flexibility in scheduling backup operations and site of backup documents. on the other hand, this technique additionally effects in accelerated control overhead, so the relevance of its blessings have to be cautiously taken into consideration. For more statistics, check with Microsoft docs.

    Azure storage-primarily based picture backup entails taking a image of character blobs representing person Azure VM disks. whilst handy and speedy (a photo is practically immediately), this method has a number of limitations and its viability for defensive SQL database Server workloads is notably limited. extra specially, snapshots are disk steady, which means that which will keep the transactional integrity of your databases, you need to continually prevent square Server prior to sporting out this operation. similarly, there's no aid for transaction log backups and restores, so effectively square Server ought to be used for databases configured with simple restoration mode best. This, in turn, will increase the recovery factor goal (RPO) together with the related potential statistics loss. eventually, observe that there is expanded complexity when managing multi-disk Azure VMs, when you consider that every disk must be dealt with one by one. For greater information concerning creating a picture of a blob, discuss with Microsoft docs.

     Azure VM-degree backup is an alternative included as part of the Azure Backup imparting, which gets rid of a number of the shortcomings of the Azure garage-primarily based photo backups defined above. It performs an application-constant backup of all disks attached to an Azure VM through leveraging the quantity Shadow replica provider (VSS) going for walks inside the operating machine being sponsored up. however, at the time of writing this article, it helps handiest digital gadget-level restores. It is also restrained to a single scheduled backup in keeping with day. you might, however, locate it available in situations that require developing a duplicate of your current deployment (for example, for testing or improvement functions).

     Microsoft Azure Backup service is some other method to again up software workloads that leverages Azure Backup abilties. inside the context of the topic covered in this text, it entails deployment of an Azure VM on which you set up the Microsoft Azure Backup service (MABS) thing. MABS is functionally equivalent to system center information safety supervisor (excluding guide for tapes, for the reason that in this example Azure recovery Vault serves as a long term garage). It gives support for utility consistent backups within the disk-to-disk-to-cloud configuration. For extra records, talk over with Microsoft Azure Documentation.

Source : http://www.databasejournal.com

[sqlmasterclass]

Microsoft targets AI for their brand new generation database platform

Microsoft has unveiled its statistics platform strategy that targets to “convey intelligence to in which the records lives’ because the company keeps its push into analytics.

Scott Guthrie, Microsoft’s government vice chairman, Microsoft Cloud and employer group and Joseph Sirosh, company vp of Microsoft facts organization announced the modern-day records platform strategy at its data Amp occasion final week.

Microsoft has persisted its journey into cognitive services. Face API is capable of locate human faces and examine similar ones, organise human beings into organizations based on visual similarity and perceive human beings the usage of preceding photo tags.

in the meantime, computer imaginative and prescient API offers tools to recognize photograph contents, create tags after which form sentences to describe the objects, beings or movements in the picture.

The corporation has also changed the call and structure of what become previously referred to as SQL database vNext.

the brand new generation, SQL database Server 2017 CTP 2.0 is the first manufacturing pleasant release that customers can run in home windows and Linux environments. The community generation Preview is to be had now.

“in this preview release, we are introducing in-database guide for a wealthy library of machine getting to know capabilities, and now for the first time, Python help (in addition to R),” remarks Sirosh.

SQL database Server 2017 CTP2.0 additionally features:

Device learning with R and functions local Python assist for the first actual time. facts scientists are able to run machine studying fashions directly in square Server.

Square Server now supports graphs for information complex information relationships within records for querying and analysis

Adaptive query processing to help system studying improve car-indexing capabilities in databases. SQL database Server tracks and learns from how lots reminiscence is utilized by a given question through the years to avoid over- or below-provisioning.

folks who use the Azure Square Database will also be able to work directly with ’Server instances’ as well as ‘Database instances’ and ‘Elastic swimming pools’.

The organisation will also be working on new migration offerings with a view to assist move present square Server and other 1/3 party databases to the cloud.

eventually, Microsoft has supplied new solution template as part of its Azure Facts Platform services, for not unusual scenarios such as call for forecasting, personalised offers and fine services.

Source : https://itbrief.com.au

[sqlmasterclass]

Microsoft SQL database Server database administrators and builders can now clone SQL database databases inner boxes by using the use of Windocks' trendy release, the Windocks Beta version.

The contemporary version, which become unveiled by way of the agency on April 12, offers developers the capability to oversee included management of pics, bins, clones and mount factors in the utility, which can be operated through a Docker command line interface or a web-primarily based user interface console. The application, which is built to be used with Microsoft's Hyper-V hypervisor, makes use of full or differential backups and snapshots to clone square databases, Paul Stanton, a Windocks vice president, told ITPro.com. The field surroundings are then handy with all trendy square gear.

 the discharge of Windocks v2.0 Beta comes about an entire year after the enterprise's unique model, which released in April 2016. the full model of the utility starts at 99.00$ consistent with month together with guide for 10 simultaneous SQL database Server containers with clones, at the same time as a confined network edition is available totally free down load. The community edition supports best two containers simultaneously.

 Windocks helps the creation of packing containers in square Server 2016, square Server 2014, square Server 2012, SQL database Server 2008 R2 or SQL database Server 2008, said Stanton.

 "SQL database Server DBAs and developers are inquiring for less complicated, low priced, container-native database cloning," Stanton informed ITPro.com. "Windocks delivers the primary box local one-click on [product] that fits any finances."

 Stanton stated the cloning talents were delivered to Windocks after clients asked for the addition of easy and cheap SQL database cloning functions.

 Windocks is made from a team of former Microsoft engineers who created their unbiased port of Docker’s open source code for windows in April of 2016, in keeping with the enterprise. Windocks products are constructed to enable. internet developers and the DevOps network to construct applications that are like minded with the Docker platform. The Windocks crew has been working to permit its merchandise with Microsoft platforms and also works collaboratively with Amazon, NetApp, Microsoft, Docker and other companions to provide migration paths for destiny Microsoft Docker-well matched merchandise, according to the corporation.

Source : http://windowsitpro.com

[sqlmasterclass]

SQL Server 2017 is a rocket !

Microsoft's push on the analytics front persisted this week as the enterprise rolled out a "go-stay" preview version of square Server 2017 observed by way of an up to date model of its R programming services and a new Python language interface.

The moves are supposed to extend square Server's use in analytics, particularly superior predictive analytics employing machine learning and other synthetic intelligence (AI) capabilities. the discharge -- firstly referred to as SQL database Server instead  formally being dubbed SQL database Server 2017 this week -- has many other functions, consisting of factors that improve IT stores' capabilities to move databases to the cloud and lower back once more. now not by the way, square Server 2017 can be the primary version of the software to run on Linux, in addition to home windows. It also supports Docker packing containers.

With the community era Preview (CTP) 2.0 replace of SQL database Server 2017, Microsoft's data management platform includes in-database guide for Python, a language that unearths huge use in gadget mastering. A renamed Microsoft machine gaining knowledge of services component allows Python to run immediately on the database server, or at the side of embedded T-square scripts.

  "these days, it's both Python or R for advanced analytics," stated Warner Chaves, a major representative for SQL database Server on the Pythian group Inc. and a Microsoft MVP. "Microsoft realizes it can not freeze out Python."

  He said it's miles very not unusual nowadays for people to use R for experiments or private prototypes. however many humans will pass that paintings to Python when it's time to enter manufacturing for operations.

  information of in-database Python library guide indicates a few bet hedging through Microsoft. Its largest analytical language wager so far has been on R, which has grown in use in recent years amongst information scientists and statisticians running on analytics.

  Hedging is a practical method for the employer to take, in line with Chaves, because Python finds as a good deal use as R on the subject of analytics these days.

Source : http://searchsqlserver.techtarget.com

[sqlmasterclass]

New SQL stuff & features for 2017

Microsoft announced the name and many of the new capabilities within the next launch of SQL Server at its information Amp digital occasion on Wednesday. even as square Server 2017 won't have as comprehensive of a characteristic set as square Server 2016, there may be nonetheless some large news and really thrilling new features. The motive for this is simple -- the development cycle for SQL Server 2017 is an awful lot shorter than the SQL Server 2016 development cycle. The huge information at Wednesday's occasion is the discharge of SQL Server 2017 later these 12 months on both home windows and Linux operating structures.

I was able to fast down load the today's Linux launch on Docker and feature it up and strolling on my Mac throughout present day briefing. (I’ve previously written about the Linux release right here.) That pace to improvement is one of the essential blessings of Docker that Microsoft hopes developers will leverage when building new applications. Docker is simply one in all many open source traits we have visible Microsoft adopt in latest years with SQL Server. Wednesday's soft release now not handiest added SQL on Linux, but also includes Python guide, a new graph engine and a myriad of different functions.

One of the predominant capabilities of SQL Server 2016 become the mixing of database, an open source statistical analysis language, into the SQL Server database engine. Members can use the sp to execute external script saved procedure to run R code that takes advantage of parallelism within the database engine. Savvy customers of this system may word the first parameter of this saved system is a language. Microsoft designed this saved technique to be open-ended, and now provides Python as the second one language that it supports. Python combines effective scripting with eminent readability and is widely utilized by IT admins, builders, records scientists, and information analysts. additionally, Python can leverage outside statistical programs to perform information manipulation and statistical analysis. while you combine this functionality with Transact-SQL (T-square), the result is strong.

It's far uncommon for a Microsoft release event to miss news approximately cloud offerings, and Wednesday's event become no exception. Microsoft Azure Square Database (formerly called square Azure), which is the business enterprise's Database as a provider supplying, has usually lacked complete compatibility with the on-premises (or in an Azure VM) model of square Server. over the years, compatibility has gotten a whole lot better, however there are still gaps which includes unsupported functions like square CLR and go-database query.

The new way to this trouble is a hybrid Platform as a Server (PaaS)/Infrastructure as a service (IaaS) solution that is currently known as Azure managed instances. simply as with Azure Square Database, the managed instances administrator is not accountable for OS and patching operations. but, the controlled times solution supports many features and capabilities that aren't currently supported in SQL Database. One such new characteristic is the pass-database query capability. In on-premises surroundings, more than one databases generally exist at the equal instance, and an unmarried query can reference separate databases by means of the usage of database Schema desk notation. In SQL Database, it is not viable to reference multiple databases in a single question which has limited many migrations to the platform because of the quantity of code that need to be rewritten. help for move-database queries in controlled instances simplifies the procedure of migrating programs to Azure PaaS offerings, and must thereby boom the number of independent software program vendor (ISV) programs which could run in PaaS.

Microsoft also showcased some of the information safety functions in Azure Square Database which might be now typically to be had. Azure square Database Hazard Detection detects SQL Injection, capacity square Injection vulnerabilities, and anomalous login monitoring. this will in reality be became on at the square Database stage by means of enabling auditing and configuring notifications. The administrator is then notified whilst the threat detection engine detects any anomalous behavior.

One of factors i was happiest to look in SQL Server 2017 become the advent of a graph database inside the center database engine. regardless of the call, relational databases conflict in coping with relationships among facts objects. The most effective instance of this battle is hierarchy control . In a traditional relational structure, an organizational chart can be a challenge to model -- who does the CEO file to? With graph database help in square Server, the idea of nodes and edges is added. Nodes represent entities, edges constitute relationships among any given nodes, and each nodes and edges can be related to information properties. square Server 2017 also makes use of extensions inside the T-SQL language to assist be a part of-much less queries that use matching to go back associated values.

Graph databases are especially useful in net of things (IoT), social network, recommendation engine, and predictive analytics packages. It has to be mentioned that many companies were investing in graph answers in recent years. besides Microsoft, IBM and SAP have also released graph database features in recent years.

[sqlmasterclass]

SQL Database and Virtualization for Server helps DBAs and Dev.

The trend towards virtualized computing assets suggests no signs and symptoms of abating. Compute, reminiscence, storage, and working structures are usually available on-call for. Code is accessed through Git website or other kind of repositories on the web, and that can be launch to an auto-pilot build, debug and test environments in seconds. Developers are unfastened to work with out worrying approximately infrastructure, except in terms of operating with databases. 

Relational databases are large and can take hours to copy or move and provisioning environments for Dev and take a look at is a project.   Surveys suggest most corporations update sq. Server environments for Dev and take a look at only two times month-to-month (or much less).   DBA’s are underneath growing strain to retool to deliver common, on-demand production information environments.    

Fortuitously, answers from red Gate and Windocks have these days been launched that supply easy to use and lower priced guide for sq. Server cloning.   In this article we’ll study the generation and blessings of cloning, and the solutions from purple Gate and Windocks.  full disclosure, i am a predominant at Windocks.

Supply production Databases for Dev and check with Database Clones

Database cloning is a exceptional exercise, and arguably the most effective sensible technique, for transport of huge facts environments for development and take a look at.  With cloning a manufacturing terabyte class surroundings may be delivered to every developer or tester, and environments may be refreshed each day.  

Both crimson Gate and Windocks clones are based totally on home windows virtual disks.   Cloning starts off evolved with a backup or photograph this is restored to a virtual tough Disk (VHD), growing a full byte copy of the database surroundings.  This “determine picture” becomes a examine-best source this is “cloned” by advent of differencing disks.   Differencing disks consist of hints to the determine picture for examine get entry to to the supply facts, however additionally save any modification made. Another important thing, clones are setup very fast, and require a small increment in garage.  As soon as some terabyte class surroundings is to be had in a discern photograph, clones can be created and brought to square Server times in seconds, with the use of only forty MB of memory!

Source : http://sqlmag.com

[sqlmasterclass]

An SQL Server launch on Linux - Microsoft

 A couple years in the past Microsoft launched into a “Microsoft Loves Linux” initiative to carry Linux into the fold of the entirety Microsoft.  For a business enterprise that has traditionally been regarded for windows and workplace that has now not traditionally been seen as specifically too Linux pleasant, there has been a piece of a stretch of the creativeness how Microsoft and Linux might become gambling nicely together.

Roll ahead a pair years, with the world very an awful lot a cloud-primarily based environment, and 1 out of each three virtual machines running in Microsoft’s Azure Cloud being a Linux system (and growing), together with increasingly more Linux boom in the Microsoft surroundings, the imaginative and prescient of a pair years ago is now very a good deal a fact.

  Very shortly, Microsoft might be freeing their mainstream square Server 2017 database platform that’ll equally run on Linux simply because it has been strolling on home windows Server for years.  CCO changed into an early adopter of the square on Linux platform, having moved a handful of our middle SQL programs over to square on Linux earlier this 12 months, and with the upcoming launch of square Server 2017 on Linux, we simply moved a pair key components of our maximum assignment important information programs to span SQL on Linux in addition to square on windows for split roles.

  Microsoft launched a case examine at the preliminary work we’ve executed on SQL on Linux  https://clients.microsoft.com/en-us/story/convergentcomputing and I’ll be supplementing this example study with a number of the new excessive availability cluster configurations for square on Linux in Microsoft Azure as the subsequent evolution of the paintings we’re doing melding together SQL + Linux + the Microsoft Azure cloud.

  Might no longer have concept few years in the past that I would be speaking approximately Linux + Microsoft, instead of Linux vs Microsoft.  It honestly is a totally new and specific world out there in recent times…

[sqlmasterclass]

Monitoring an SQL database

  Minimizing weekend and past due-night paintings by using database administrators changed into a quest close to and expensive to the hearts of many attendees at skip Summit in Seattle city (2014). At the conference, T. LaRock, the president of the professional association for sq. Server (skip) consumer organization, defined the dilemma of the modern-day DBA: habitual upkeep, updates, patches and hardware replacements all require database downtime -- but that's unacceptable except at night time or on weekends.

And as systems have grown more and more green, los angeles Rock brought, many database directors (DBAs) are being asked to take on workloads that used to be unfold across more than one people, requiring longer working hours to get the whole thing accomplished. "it's simplest ever greater, greater, more," he said in an interview.

"i've seen a massive increase charge of after-hours work that people are being demanded to do," agreed Carl Berglund, director of business improvement at DH2i Co., a seller of square Server monitoring tools and control software in fortress Collins, Colo. however, Berglund said, operating more nights and weekends outcomes in worn-out DBAs -- and tired human beings make more mistakes.

One issue that potentially can help square Server DBAs cut down on their off-hours workloads is the database overall performance monitoring and control software program offered by using Microsoft and diverse 0.33-birthday celebration providers. for instance, LaRock works as database control "head geek" at SolarWinds, a seller in Austin, Texas, that offers a tool known as Database overall performance Analyzer (DPA). The product, which SolarWinds acquired whilst it sold Confio software program last year, tracks and analyzes the "wait time" in applications strolling on pinnacle of a database. DPA pinpoints processes which might be inflicting holdups and affords guidance on a way to alleviate the troubles and accelerate processing time.

DH2i has additionally advanced tools especially supposed to combat lost nights and weekends for DBAs. DBAs "can do the general public of [updates and patching] inside the daylight hours and just a stop and restart at night," Berglund said.

[sqlmasterclass]

Domo - The machine learning

   Nowadays we're used to machine getting to know (ML) and synthetic Intelligence (AI) making their way via the developer network and into the device chains of a number of the largest tech businesses, consisting of Microsoft, Google and facebook. What we are now not but used to, even though, is sighting such technology very often in self-carrier analytics equipment and corporation/line-of-commercial enterprise software packages.

 This is certainly starting to trade now, as bulletins within the previous couple of weeks from Domo and Absolutdata orbit round AI/ML specially and another assertion from Alteryx ties in too, albeit a piece greater peripherally. Taken together, those bulletins provide anecdotal proof that ML/AI may be each beneficial and reachable to business customers.

Permit's start with Domo, which in late March introduced its "Mr. Roboto" AI service, at the corporation's annual Domopalooza event. even as Domo may be classified as a cloud BI vendor, it instead sees itself as a SaaS business software issuer that coalesces information from a couple of sources to offer you a comprehensive view of your commercial enterprise. And with that context in region, Domo has dispatched AI technology to raise alerts whilst it sees anomalies in that collective information pool.

Domo says Mr. Roboto makes use of models built on okay-approach, linear regression, logistical regression and other algorithms to hit upon anomalies in enterprise data and surface them quick. A centralized place for tracking such anomalies is Domo's Alert center, although it will also make use of the provider's "playing cards" to display any anomalies that might effect income forecasts and product renewals. And whilst the models underlying this anomaly detection functionality are reachable to fascinated information scientists, business users benefit from the device mastering directly, without having to master, or maybe observe, system gaining knowledge of basics and technology.

Of course, this begs the query of whether commercial enterprise software can do greater than document ML findings and pressure the consumer to interpret them and determine on responsive actions. What if, alternatively, the software program interpreted the ML findings and then encouraged suitable action? Domo is intentionally leaving that opportunity to its associate ISVs who can use Mr. Roboto as a platform to add device studying to their very own Domo accessories.

Source : http://www.zdnet.com/

Interesting website : https://www.domo.com

[sqlmasterclass]

Thank to Mashery, API reborn

   TIBCO puts some shade on the internal mechanics of API integration too, so what elements are concerned? inner API integration operations we discover touchpoints to microservices, so-termed ‘API choreography’, routing and API transformation functionality.

“API usage is evolving and becoming an increasing number of sophisticated; consequently the need to adapt the API control platform to offer all essential talents inclusive of API introduction, integration and management, within a unmarried cloud-based carrier,” said Matt Quinn government vice chairman, products and technology and leader generation officer, TIBCO. “To supply the various and growing needs of digital business, an API control platform now needs to offer abilities, such as advanced routing and transformation, that have traditionally been the domain of API improvement and integration middleware. Mashery enterprise brings those abilties together to provide a single, present day API platform.”

The firm says that Mashery business enterprise platform lets in users to show data and services for sharing with builders to extend marketplace reach and generate new revenue streams.

Mashery employer users can build and check APIs, define run-time governance regulations, migrate APIs between environments, and reveal and report on API usage.

Source : searchdatamanagement

Interesting link : https://www.mashery.com/

[sqlmasterclass]

The IDERA’s skills to manage a database

 In Oct 2015, IDERA nonheritable Embarcadero Technologies to reinforce its existing information performance management and administrator tools portfolio. the corporate currently offers a full spectrum of information, infrastructure and application management merchandise for app developers and DBAs.

IDERA's multi-platform watching tool, the Precise Application Performance Platform, is preponderantly associate degree application performance management tool, however it conjointly provides information performance watching choices for Oracle, DB2, SQL Server and SAP adaptive Server Enterprise. a standard interface permits an identical user expertise, notwithstanding the underlying information being accessed.

Using Precise, information directors (DBAs) will implement 24/7 heterogeneous information watching to research behavior to search out information objects and processes with performance problems like high I/O rates or protection issues. Precise will determine potential bottlenecks and take corrective action before finish users area unit adversely compact. It can even be wont to generate standardisation recommendations, perform what-if analysis, and for capability designing and management.

DB Optimizer may be wont to optimize SQL code across the foremost relative sound unitMSes. It assists DBAs in standardisation SQL statements via visual SQL standardisation diagrams for justify plans and a SQL standardisation wizard that gives machine-controlled performance improvement recommendations. The product's information identification capability simplifies standardisation with wait-time analysis mental image, creating performance issues straightforward to identify. It can even be wont to simulate the assembly setting in take a look at.

Rapid SQL may be wont to assist developers as they write code to formulate high-performing SQL against heterogeneous DBMSes. the merchandise offers a visible question builder; a code analyst for examining SQL code; and debugging aids for SQL statements, hold on procedures and functions.

DBArtisan will optimize information objects across heterogeneous DBMSes likewise as manage area, knowledge and performance details with constitutional analytics. DBAs will use DBArtisan across all supported platforms from one product license. It may be wont to read elaborate performance metrics and determine performance, capability designing and storage management problems before they become major issues. DBArtisan conjointly offers a method Monitor to spot connected users and their current activity and employment management perform that integrates with Microsoft Windows Task computer hardware.

DBArtisan conjointly provides performance analytics capabilities like those listed higher than within the coverage of Precise. However, DBArtisan could be a desktop tool, commissioned for every user, whereas Precise is commissioned supported the appliance, technology or direction system that is to be monitored.

Source : SearchDataManagement

Interesting link : https://www.idera.com

[sqlmasterclass]

SQL and wireless

 The encounter of three worlds already cited, information technology centered SQL Internet and wireless broadband transmissions (private intranet as public telecom network) will generate a new world in enterprise computing both in Relationships with customers, suppliers, partners and employees!

Informatica is one of the best option for data analysis and training.

The success of this meeting lies in the development of value-added information services that must be demonstrated. Let us note some revealing figures of this surge of wireless Internet: 'in 1999, it sold more mobile phones than PCs and cars; In 2003, the number of light terminals (phones, PDAs ...) exceeds the number of PCs to access the Internet (around 1 billion mobile phones, 60% of which have Internet access in 2003); In 2005 mobile data traffic exceeded voice traffic to 80% in 2010 (the phone will then be used as an accessory to make calls). This wave is changing completely the IT infrastructures, the tools with the need for universal standards, the modes of development and deployment of applications and services. The smaller the internet terminal linked to an individual, the more personal, geo-dependent and useful information will be. The era of very distributed databases on the one hand, and peer-to-peer infrastructures on the other, is just beginning.

[sqlmasterclass]

The SQL job in the web

             The Internet is not a new market but a new application communication platform for database publishers. The primary objective of a DBMS editor is to combine the power of a BD server with the ubiquity of access to data offered by a web browser present on increasingly lighter clients (WAP / GPRS / UMTS, PDA ...).

Code42 is the best option to secure your data data and app.

What is underlying the phenomenon of the Web is: 0 on the one hand, the great wave of digitization barely launched; Just 15% of the company's data are in a digitized format today. The first challenges of the new data models relate first to this niche, whose turnover will be double that of the management-production in the company in 2001 according to the Gartner group. 

On the other hand, the integration of SQL technology and web servers to make the transactional online. All client-server architectures (data warehouse, groupware ...) evolve towards the network infrastructure to benefit from the universal access made by a simple browser to the client workstation!

The lighter the client becomes, the more the database and server become important with the need to deliver customized data to the terminal! The expected increase in data server power for 2005 is around 106 compared to the number of servers existing in 2000! A distributed architecture is an alternative to centralization. The Web poses four major technological challenges for publishers and researchers in databases:

- the management of large quantities of digitized data (and thus the support of SQL engines parallelized as for the data warehouse) with new data models (Objects or hybrid Object-relational) in the context of networked infrastructures;

- the extensibility of the complex types supported via the object approach;

- content access interfaces favoring navigation on hypermedia links (" SQL-surf");

- Tools for developing and migrating applications integrating Java (a language defined by Sun in 1990 for PDAs - Personal Digital Assistant) with appropriate design methods. The object-oriented approach which implies java, a language independent of the hardware platform, is in the affiliation of C ++ (without pointers however) which is the de facto standard for object programmers in the technical world. Java transforms the Web into a client-server architecture by allowing the transfer of active objects, application programs (the applets) from the server to the universal client with a Java interpreter in addition to the browser; The HTML pages are in comparison, passive objects do not allow local processing on the client computer. If Java is in the public domain. . . The source code for the interpreter remains the property of Sun with licenses purchased by Netscape, Oracle, IBM ... and Microsoft.