Redgate Software has teamed up with Northwest Cadence to present a workshop on May 15, 2015. Come learn how to implement continuous integration in your database development software pipeline.
If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?
Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.
The DBA role is changing with the growth of DevOps as a way to better build software in an organization.
Say you have a SQL Server Integration Services (SSIS) package with a Foreach Loop container. Inside that container you have a task that sometimes can fail. Koen Verbeeck provides a tip on how to implement SSIS so that, if it fails, the loop will just continue, skip the current step and go to the next iteration.
Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.
A company Steve Jones knows uses a diverse network infrastructure to help provide security.
Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by the jargon of principals, securables, owners, schemas, roles, users and permissions, but beneath the apparent complexity, there is a schema-based system that, in combination with database roles and ownership-chaining, provides a relatively simple working solution.
In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.
There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Comments posted to this topic are about the item We Are Eating Our Own...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers