Last Updated: May 7th, 2018 If you're looking for SQL Server Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportun…
PolyBase One of the more intriguing features included with SQL Server is PolyBase, a transparent access layer that facilitates connectivity between the databas…
HDInsight is a Hadoop-based platform that you can use to process data of all kinds in the cloud. In particular, HDInsight is useful for processing high volumes …
Big Data is large amount of the data which is difficult or impossible for traditional relational database. Big data, the term has seen increasing use since the …
Power BI for Mobile is a touch-optimized Windows 8 app for a tablet. By using this app, you can view any workbook saved to Office 365. Preparing a workbook for…
POWER BI Q&A is a self-service BI feature available only online. First, you upload a workbook to the Power BI site. Then, you can type your own questions or sel…
Self-service BI is only as good as the information that people can find on their own. The purpose of Power BI is to help users find the data they need, obtain a…
Power BI for Office 365 is a new self-service business intelligence (BI) solution delivered through Excel and Office 365 which provides information workers with…
Power Map is the latest self-service business intelligence (BI) tool from Microsoft. It helps users visualize geographic information using 2D and 3D maps. Let u…
Power View Power View, is an interactive, web-based data exploration, visualization, and presentation technology. Power View in SharePoint was introduced in SQ…
Power Pivot is a great tool for gathering together data from disparate sources and combining it into a single model for analysis, but it presumes that you know …
Exploring self-service BI in Microsoft Excel 2013 Self-service business intelligence (BI) is not new to Microsoft Excel. Since Excel S2000, users have been abl…
Backup and Restore enhancements A robust backup strategy is always required even if an organization employs high-availability, disaster-recovery, and hybrid-cl…
Platform for Hybrid Cloud SQL Server 2014 is meeting the increasing demands of organizations to reduce operational and hardware costs, provide high availabilit…
Always On SQL Server Every organization’s success and service reputation is built on ensuring that its data is always accessible and protected. In the IT world…
High-availability, hybrid-cloud, and backup enhancements It’s become clear that the cloud has become an increasingly important option to IT organizations every…
Using In-Memory OLTP The following examples outline how to use In-Memory OLTP and memory-optimized tables to improve performance of OLTP applications through e…
In-Memory OLTP application migration A before-and-after illustration is the best way to compare the internal behavior of SQL Server when transactions are proce…
In the next few sections, we shall discuss In-Memory OLTP fundamentals, architecture, concepts, terminology, hardware and software requirements, and some myths …
SQL Server In-Memory OLTP In the previous two releases of SQL SERVER, Microsoft built into the product a number of in-memory capabilities to increase speed an…
The licensing models affiliated with SQL SERVER 2014 are simplified to better align to customer solutions and also optimized for virtualization and cloud deploy…
Similar to the previous version, SQL Server 2014 is available in three principal editions. All three editions have tighter alignment than their predecessors and…
SQL Server 2014, the latest complete information platform from Microsoft, embodies the new era of Microsoft’s Cloud OS, which provides organizations and custome…
Microsoft SQL Server 2014 is the next generation of Microsoft’s information platform, with new features that deliver faster performance, expand capabilities in …
If you're looking for SQL Server Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed c…
If you're looking for SQL Server Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed compa…
Introduction: R is one of the most powerful business analytics tool that has strong and seamless integration with SQL Server 2016, Tableau and many more tools …
The SQL Server 2016 release added new security features, querying capabilities, Hadoop and cloud integration, R analytics and more, along with its numerous impr…
Introduction Constraints are used to prevent invalid data entry into our tables. Generally constraints are created on table columns. Oracle server having …
Introduction Exception is an error occurred in Run-time. Whenever the run-time error is occurred use an appropriate exception name in exception handler unde…
Introduction Cluster is a database object which contains groups of tables together and also shares same data block. In all databases cluster database object…
Introduction Joins are used to retrieve data from multiple table. In all databases if we are joining “n” table then we are using (n-1) joining condition. Orac…
Last Updated: May 7th, 2018 If you're looking for SQL Server Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportun…
PolyBase One of the more intriguing features included with SQL Server is PolyBase, a transparent access layer that facilitates connectivity between the databas…
HDInsight is a Hadoop-based platform that you can use to process data of all kinds in the cloud. In particular, HDInsight is useful for processing high volumes …
Big Data is large amount of the data which is difficult or impossible for traditional relational database. Big data, the term has seen increasing use since the …
Power BI for Mobile is a touch-optimized Windows 8 app for a tablet. By using this app, you can view any workbook saved to Office 365. Preparing a workbook for…
POWER BI Q&A is a self-service BI feature available only online. First, you upload a workbook to the Power BI site. Then, you can type your own questions or sel…
Self-service BI is only as good as the information that people can find on their own. The purpose of Power BI is to help users find the data they need, obtain a…
Power BI for Office 365 is a new self-service business intelligence (BI) solution delivered through Excel and Office 365 which provides information workers with…
Power Map is the latest self-service business intelligence (BI) tool from Microsoft. It helps users visualize geographic information using 2D and 3D maps. Let u…
Power View Power View, is an interactive, web-based data exploration, visualization, and presentation technology. Power View in SharePoint was introduced in SQ…
Power Pivot is a great tool for gathering together data from disparate sources and combining it into a single model for analysis, but it presumes that you know …
Exploring self-service BI in Microsoft Excel 2013 Self-service business intelligence (BI) is not new to Microsoft Excel. Since Excel S2000, users have been abl…
Backup and Restore enhancements A robust backup strategy is always required even if an organization employs high-availability, disaster-recovery, and hybrid-cl…
Platform for Hybrid Cloud SQL Server 2014 is meeting the increasing demands of organizations to reduce operational and hardware costs, provide high availabilit…
Always On SQL Server Every organization’s success and service reputation is built on ensuring that its data is always accessible and protected. In the IT world…
High-availability, hybrid-cloud, and backup enhancements It’s become clear that the cloud has become an increasingly important option to IT organizations every…
Using In-Memory OLTP The following examples outline how to use In-Memory OLTP and memory-optimized tables to improve performance of OLTP applications through e…
In-Memory OLTP application migration A before-and-after illustration is the best way to compare the internal behavior of SQL Server when transactions are proce…
In the next few sections, we shall discuss In-Memory OLTP fundamentals, architecture, concepts, terminology, hardware and software requirements, and some myths …
SQL Server In-Memory OLTP In the previous two releases of SQL SERVER, Microsoft built into the product a number of in-memory capabilities to increase speed an…
The licensing models affiliated with SQL SERVER 2014 are simplified to better align to customer solutions and also optimized for virtualization and cloud deploy…
Similar to the previous version, SQL Server 2014 is available in three principal editions. All three editions have tighter alignment than their predecessors and…
SQL Server 2014, the latest complete information platform from Microsoft, embodies the new era of Microsoft’s Cloud OS, which provides organizations and custome…
Microsoft SQL Server 2014 is the next generation of Microsoft’s information platform, with new features that deliver faster performance, expand capabilities in …
If you're looking for SQL Server Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed c…
If you're looking for SQL Server Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed compa…
Introduction: R is one of the most powerful business analytics tool that has strong and seamless integration with SQL Server 2016, Tableau and many more tools …
The SQL Server 2016 release added new security features, querying capabilities, Hadoop and cloud integration, R analytics and more, along with its numerous impr…
Introduction Constraints are used to prevent invalid data entry into our tables. Generally constraints are created on table columns. Oracle server having …
Introduction Exception is an error occurred in Run-time. Whenever the run-time error is occurred use an appropriate exception name in exception handler unde…
Introduction Cluster is a database object which contains groups of tables together and also shares same data block. In all databases cluster database object…
Introduction Joins are used to retrieve data from multiple table. In all databases if we are joining “n” table then we are using (n-1) joining condition. Orac…