As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. Read on to learn more about this data warehouse-as-a-service offering from Microsoft.
The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is probably going to lead to you being displeased with your fellow man. Luckily, we work in IT, so we can avoid politics. BWA-HA-HA-HA-HA! Politics goes way beyond […]
Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.
How to use the EXCEPT statement to perform row differences.
Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.
In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.
Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.
An introduction to the basics of current SQL Server vs v.Next Performance Testing.
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers