Releasing Databases in VSTS with Redgate SQL CI and Octopus Deploy
You can still do Database Lifecycle Management (DLM) workflows in the hosted version of Team foundation Server (TFS) in Visual Studio Team Services (VSTS) . If you are doing your database development in SSMS, you can use a mix of tools to set up the functionality in VSTS. Jason Crease demonstrates how to build and deploy a simple database into the test environment using SQL CI, SQL Source Control, Octopus Deploy, tSQLt, SQL Cop and SQL Release, all with the minimum of hassle and effort.
Five Online Database Modelling Services
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation. Now that browser technology has progressed so rapidly, the online database modelling tools have become viable and are starting to attract the attention of database designers. Are they good enough to use now? Robert Sheldon finds out.
Building Better Software
Steve Jones discusses the idea of building software better, and why that's a challenge for many of us.
Find a String in a String in SQL Server
Learn how you can find data in a string and extract it, no matter where it's located.
Getting Started with JSON Support in SQL Server 2016 – Part 2
Arshad Ali talks about using OPENJSON to read and parse JSON data and looks at how to convert it to tabular format.
The Slack Integration
Slack has become a popular phenomenon in the technical world, especially for software developers. Should we join in?
Disabling SQL Server Optimizer Rules with QUERYRULEOFF
Daniel Farina shows how to disable the optimizer rules by using QUERYRULEOFF, an undocumented hint.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCU TANGERANG CITY Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal Sudirman...
Alamat kontak resmi BCA KCP MERR Tlp/Wa:0817866887
WhatsApp:0817-866-887 Jl. Dr Ir H Soekarno, Ruko promenade. 8 Surabaya 60298, Kedung Baruk, Kec....
Alamat kontak resmi BCA KCP Tidar Telp:0817866887
WhatsApp:0817866887 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers