Why Object Databases will always be Tomorrow's Technology
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
Getting Started with Azure SQL Data Warehouse - Part 1
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.
Approaching Politics in IT
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 […]
New CREATE OR ALTER statement in SQL Server 2016 SP1
Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.
Using EXCEPT to Determine Row Differences
How to use the EXCEPT statement to perform row differences.
Introduction to SAP HANA on Azure
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.
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
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.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers