Database deployments, like the sheep of exasperated hill-farmers, often find strange and unexpected ways to self-destruct. Phil Factor describes the most common things that can go wrong, and how a reliable automated database build process can prevent messy accidents.
2019-10-03
In this tip we look at how to use an If Condition activity in an Azure Data Factory pipeline for conditional logic.
2019-10-02
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
2019-10-01
SQL Monitor 9.1 offers a new PowerShell Alert API to control and fine tune your alert configuration, across a group of servers, and a new Server Permissions Overview table, which summarizes who has access to a server via a “super-privileged” server-level role. Here Redgate's Rebecca Woof dleves into the details.
2019-10-01
Last September Redgate University opened its doors online, since then, with their selection of getting started courses they have been helping customers get up and running with their tools. Now, along with a brand-new look, new courses have been added to help you advance your skills past the basic usage of the tools. Come and check it out and leave your suggestions for future courses.
2019-09-30 (first published: 2019-09-16)
Robert Sheldon continues his DevOps series with a look at security, privacy, and compliance. He recommends that these critical areas are tackled early in the DevOps pipeline.
2019-09-30
Brent continues his DBA Training Plan: Whenever your queries need to wait on something – storage, locks, memory, whatever – SQL Server tracks what it’s waiting on, and for how long. It’s like you’re seeing INSIDE the server, with all kinds of possible debug points being tracked. All you have to do is ask SQL Server, “What have you been waiting on?”. Here Brent shows you how.
2019-09-27
We want to hear from you on the approaches you take and the challenges you face when delivering test data to development and testing environments. Take part now for an advance copy of the research and a chance to win a $250 Amazon voucher.
2019-09-27
You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance requirements. In this article, Joshua Feierman explains how to set up the audit and collect the data in Azure Log Analytics when running SQL Server in an Azure VM.
2019-09-26
SQL Change Automation's Development component for developing new databases and modifying existing databases, using migrations, now integrates directly into SQL Server Management Studio as well Visual Studio. It allows teams to collaborate effectively during development, regardless of their preferred IDE, and in a way that integrates easily with common build/integration servers and release management tools.
2019-09-26
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Next up in my series talking about The Burrito Bot is diving into the...
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers