With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.
In this tip we look at a simple way to import a simple XML document into a SQL Server table.
A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.
If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.
Have you ever had a difficult time explaining what your job entails to your parents or other family members? You may be working in a field that didn’t exist 20 years ago, such as mobile device development, or your job may be so specialized that non-technical people will never understand. Now that my job title […]
In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.
On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
Comments posted to this topic are about the item The Vector Data Type
What is the vector data type in SQL Server?
See possible answers