SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects.
2017-03-15
5,823 reads
Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.
2017-03-14
3,555 reads
Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal,...
2017-03-13
2,937 reads
Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.
2017-03-10
6,023 reads
If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.
2017-03-09
2,748 reads
Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.
2017-03-09
5,294 reads
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
2017-03-08
3,664 reads
Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.
2017-03-07
4,670 reads
Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.
2017-03-06
5,202 reads
Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.
2017-03-03
4,570 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers