Archive

Archive for the ‘Microsoft’ Category

SQL Server 2022 preview announced, some awesome new features !!!

November 8, 2021 Leave a comment

 

SQL Server 2022 is coming !!!

 
On 2nd November 2021 in MS Ignite 2021 event Microsoft announced the preview of new version of SQL Server i.e. SQL Server 2022.

 
SQLServer2022

 
SQL Server 2022 will be more focused on Azure-enabled cloud and big data space, here are some excerpts from the announcements:

 
1. Azure Synapse link integration with SQL for ETL free and real time reporting & analytics: Here you can setup a Synapse Link relationship between SQL Pool in Azure Synapse and SQL Server as a data source and link required tables in Synapse Workspace. You can create PowerBI reports on top of these tables available in Synapse Workspace with real time data, without requiring you to write/setup an ETL from SQL Server to Synapse SQL Pool. This will also let you combine/JOIN datasets from different sources, data lake, files, etc. Similarly Data Scientists can create ML Models by using Synapse Spark Pools with PySpark language.

 
2. Azure Purview integration: with also work with SQL Server, for data discovery and data governance. Here you can use Purview to scan and capture SQL Server metadata for data catalog, classify the data (PII, non-PII, etc), and even control access rights on SQL Server.

 
3. Bi-directional HA/DR between SQL Server and Azure SQL MI: Now you can use Azure SQL Managed Instance as a Disaster Recovery site for your SQL Server workloads. You can setup Disaster Recovery as a Managed Service with Azure SQL Managed Instance (SQL MI). A Distributed Availability Group is created automatically with a new Azure SQL MI as READ_ONLY replica. This way you you can do failover from SQL Server to Azure SQL MI, and also back from Azure SQL MI to SQL Server.

 
4. QueryStore and IQP enhancements: Parameter Sensitive Plan optimization for handling Parameter Sniffing issues. Now the SQL optimizer will cache multiple plans for a Stored Procedure which uses different parameter values having big gap in cardinality providing consistent query performance. Enhancements on Cardinality-Estimation & Max-DOP feedback, and support for read replicas from Availability Groups.

 
5. SQL Server Ledger: Built on Blockchain technology, this feature will allow you to create and setup smart contracts on SQL Server itself. With ledger based immutable record of data you can make sure the data modified over time is not tampered with, and will be helpful in Banking, Retail, e-commerce, Supply Chain and many more industries.

 
6. Scalable SQL Engine and new features coming:
– Buffer Pool parallel scan
– Improvements on tempDB latch contention (System page GAM/SGAM concurrency)
– In-Memory (Hekaton) OLTP enhancements
– Multi-write replication with last writer wins
– Redesigned and improved SPANSHOT backups
– Polybase (REST API) for connecting to various files formats (parquet, JSON, csv) in Data lake, Delta tables, ADLS, S3, etc.
– Backup/Restore to S3 storage
– JSON enhancements and new functions
– New Time series T-SQL functions

 
For more details on SQL Server 2022 please check here” Microsoft official SQL Server Blog.

 



SQL Server 2019 released, awesome new features – download now !!!

November 4, 2019 Leave a comment

 
Today on 4th November 2019 Microsoft in MSIgnite2019 event announced the release of new version of SQL Server i.e. SQL Server 2019.
 

New stuff in SQL Server 2019 is all about Big Data Clusters for SQL Server, which will allow you to:
– Deploy scalable clusters of SQL Server, Spark, HDFS on Kubernetes
– Read, write, and process big data from Transact-SQL or Spark
– With Polybase query data from external SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources with external tables
– and many more, we will check below…

 
–> Download SQL Server (evaluation version):

To download SQL Server 2019 you can Register and Download the Full or Evaluation version (180 days) here.

Or you can directly download the installer SQL2019-SSEI-Eval.exe
 

–> Free Developer Version:

Back in March 2016 Microsoft announced that going forward the Developer version of SQL Server any release will be free for Developers and Learning purpose. Register and Download the Developer version.

This Developer version is meant for development and testing only, and not for production environments or for use with production data. For more info please check my previous blog post.
 

–> Download SSMS (separate install):

Microsoft starting with SQL Server 2016 decoupled SSMS from SQL Server setup and is available as a separate installer. This is basically to support the move to make a universal version of SSMS for both SQL Server on-Prem & Azure SQL Database, that will ship every month or so. The SSMS setup is available separately as free download.
 

–> Download SSRS (Reporting Services):

Just like SSMS, now SSRS is also separately available for install from Microsoft Download Center, link.
 

–> Check new features in SQL Server 2019:

1. Big data clusters with scalable compute and storage composed of SQL Server, Spark, and HDFS. It provides key elements of a data lake – Hadoop Distributed File System (HDFS), Spark, and analytics tools deeply integrated with SQL Server. [more info]

2. A complete Data Science & AI platform to train and operationalize models in SQL Server ML Services or Spark ML using Azure Data Studio notebooks.

3. Data virtualization allows queries across relational and non-relational data without movement or replication. PolyBase enabled you to run a T-SQL query inside SQL Server to pull data from Hadoop and return it in a structured format—all without moving or copying the data.

4. Intelligent Query Processing improves scaling of queries and Automatic Plan Correction resolves performance problems. [more info]
  – Table variable deferred compilation
  – Batch mode on row store
  – T-SQL Scalar UDF inlining
  – Approximate QP (Approximate COUNT DISTINCT)
  – Memory grant feedback, row mode

5. In-memory improvements for analytics on operational data using HTAP. Higher concurrency and scale through persistent memory (PMEM). [more info]
– Hybrid buffer pool
– Memory-optimized TempDB
– In-Memory OLTP support for Database Snapshots

6. Greater uptime with more online indexing operations. [more info]

7. Data Discovery & Classification labeling for GDPR and Vulnerability Assessment tool to track compliance.

8. Support for your choice of Windows, Linux, and containers. SQL Server on Linux for Docker Engine [link].

9. High Availability with, five synchronous replica pairs, Secondary to primary replica connection redirection, Run Always On availability groups on containers using Kubernetes. [more info]

10. Accelerated Database Recovery [more info]

11. SQL Graph enhancements, support of MATCH predicates in a MERGE statement, SHORTEST_PATH inside MATCH, and support for derived tables or view aliases in graph match query.
 

Check all the above and many more new features of SQL Server 2019 in MSDN Blogs.


Download SQL Server 2017 for free (with full MSBI stack)

March 1, 2018 Leave a comment

 
With SQL Server 2014 Microsoft made its SQL Server Developer Edition free for Development and Test database in a non-production environment. This edition is not meant for Production environments or for use with production data.

SQL Server 2014 Dev Ed free

With SQL Server 2017 Developer edition developers can build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server.

So, with this free edition you get the Database Engine as well as full MSBI stack with DW/BI capabilities ( i.e. SSIS /AS /RS) for free 🙂
 

Downloads here:

SQL Server 2017 Developer Edition

SQL Server Management Studio (SSMS, latest version)

– Sample databases for SQL Server [AdventureWorks] [Wide World Importers]

SQL Operations Studio


Migrate from Oracle to SQL Server for free !!!

August 29, 2017 Leave a comment

 

Microsoft is encouraging people/customers who are currently using Oracle, IBM Db2, Sybase, or Netezza database, to migrate to SQL Server 2017 for free (free license), get subsidized migration support services, hands-on labs, and instructor-led demos as part of this offer.
 


 

With SQL Server 2017 not only its available in Windows, but also on Linux, Mac & Docker too, you get in-memory performance across workloads, mission-critical high availability, end-to-end mobile BI, and in-database advanced analytics with security features to protect your data at rest and in motion, all on your choice of language and platform – now including Linux and Docker.
 

– Migration Offer Broucher Details

– Download the Microsoft SQL Server Migration Assistant v7.8 for Oracle
 


 


Microsoft hosts its first-ever Accessibility Summit in India to enhance technology access for people with disabilities

May 30, 2017 Leave a comment

 
Continues its efforts to bridge technology divide and drive digital inclusion to empower people to achieve more


(From L-R)

Dr. Jitender Aggarwal, Founder & CEO Sarthak Educational Trust, Shri M. Jagadeeshwar, IAS, Department of Women and Child Development, Government of Telangana,

Shri Navreet Kang, Secretary, Department of Empowerment of Persons with Disabilities, Ministry of Social Justice and Empowerment, Government of India,

Shri Jayesh Ranjan, IT Secretary, Department of IT, Electronics & Communication, Government of Telangana,

Madhu Khatri, Associate General Counsel and Accessibility Lead, Microsoft India

… at the first-ever Microsoft Accessibility Summit in India that is focused on enhancing technology access for people with disabilities.
 

Hyderabad, 30 May 2017: Microsoft India today hosted its first-ever Accessibility Summit (#ThinkAccessAbility) in the country to enhance technology access for people with disabilities. The summit aimed at demonstrating the business value of accessible technology for organizations, the need for a collaborative effort as well as assessing policy’s role in creating an accessible India. The summit brought together leaders from the government, non-profit organizations, filmmakers, entrepreneurs and budding technologists to present their views and best practices around accessibility and technology’s potential in aiding inclusion.
 

Shri Navreet Kang, Secretary, Department of Empowerment of Persons with Disabilities, Ministry of Social Justice and Empowerment, Government of India said, “We believe that inclusion of persons with disabilities is imperative for India’s growth. It is therefore, critical that we empower them with equal access and opportunity. We look forward to public-private partnerships that can enable better social inclusion and help people with disabilities achieve more.”
 

Speaking at the summit, Shri Jayesh Ranjan, IT Secretary, Department of IT, Electronics & Communication, Government of Telangana said, “Our vision is to ensure that persons with diverse abilities have equal access to the physical environment, transportation, information and communication technologies, and to other facilities and services. The Microsoft Accessibility Summit provides an ideal platform to bring together policymakers and influencers to understand the policy environment and chart a direction for making life, experiences and opportunities accessible to all.”
 

A platform to discuss, imagine and bring new perspectives for innovative use of technology
Through a series of constructive sessions, the conference focused on the role of technology in creating accessible businesses, scalable and sustainable models for skilling youth with disability. It also examined how assistive technologies can help in treating Autism Spectrum Disorders and Special Learning Disabilities (SLD). There was a special focus on the need for regulatory policies for innovation on accessible technologies and inclusive hiring practices. These interactions also provided insights into regulations, specifications and standards in terms of accessibility along with an understanding of optimization of existing hardware and software configuration to drive accessibility. Shri M. Jagadeeshwar, IAS, Department of Women and Child Development, Government of Telangana also contributed to the discussions as part of the summit.
 

Technology innovations for driving accessibility
The summit featured unique technology-based projects that empower people with disabilities. These included innovations from non-profit organizations, assistive technologies developed by Microsoft partners as well as Microsoft solutions. A young team of three students from IIT Kharagpur showcased White Cane, a personal assistant device for the visually impaired, which they have developed as part of Microsoft Imagine Cup.
 

According to Dr. Jitender Aggarwal, Founder & CEO Sarthak Educational Trust, “Accessibility is one of the dire necessities for creating an inclusive environment. The difference between the able bodied and disabled is not so much because of physical challenges, as due to the fact that everything around us is designed from the perspective of able bodied people only. In such a scenario, accessible and adaptive technologies act as a support system to promote inclusion and empowerment of persons with disabilities.”
 

Speaking at the conference, Madhu Khatri, Associate General Counsel and Accessibility Lead, Microsoft India said, “At Microsoft we believe there are no limits to what people can achieve when technology reflects the diversity of everyone who uses it. We are committed to transparency, accountability, and inclusion in our products and our culture, and we are deeply inspired by the opportunity to work with others around the world to explore what’s possible. A market-driven ecosystem is the best environment for encouraging greater accessibility for all users. The Summit is a significant step forward in advancing our efforts towards sensitizing stakeholders and partners on the need for the business and social value of accessibility.”
 

Please find more information to Microsoft’s approach to accessibility on Microsoft Accessibility Website and see Microsoft India’s video on Empowering for Inclusion.
 

About Microsoft India
Founded in 1975, Microsoft (Nasdaq “MSFT” @microsoft) is the leading platform and productivity company for the mobile-first, cloud-first world, and its mission is to empower every person and every organization on the planet to achieve more. Microsoft set up its India operations in 1990. Today, Microsoft entities in India have over 8,000 employees, engaged in sales and marketing, research and development and customer services and support, across 11 Indian cities – Ahmedabad, Bangalore, Chennai, New Delhi, Gurugram, Noida, Hyderabad, Kochi, Kolkata, Mumbai and Pune. Microsoft offers its global cloud services from local datacenters to accelerate digital transformation across Indian start-ups, businesses, and government agencies. In 2016, Microsoft opened one of its eight Cyber Security Engagement Centers in the country, to address security needs of both public and private sectors.
 

For further information, contact
Anindita Phukan
Microsoft Corporation India Pvt. Ltd.
Email: Anindita.phukan@microsoft.com
+919811402847

Dhairya Chaudhry
Edelman India
dhairya.chaudhry@edelman.com
+9199689 84563
 

FOR MORE INFORMATION:
Microsoft India news: http://news.microsoft.com/en-in/
Log onto: http://microsoft.com/india/news
Follow us on: Twitter | Facebook


Categories: Microsoft