SQL Server Management Studio is as Relevant as Ever
In this Simple Talk editorial Kendra Little discusses how SSMS is as relevant as ever.
2019-10-10
Additional Articles
Getting Started with SQL Server Azure Container Instances ACI
Learn how to quickly deploy a new SQL Server instance on Azure using Azure Container Instances ACI.
2019-10-09
SQL Compare 14 now available on Linux
The latest version of SQL Compare now offers a Command Line Interface on Linux for the first time. Now teams can benefit from the industry standard tool for comparing and deploying SQL Server databases, whether they choose to work on Windows, Linux, or both.
2019-10-09
Implementing SQL Server Integration Services with Azure Data Factory
Azure SQL Database, unlike its on-premises counterparts, restricted its integration capabilities to those implemented directly by the database engine. To remediate this shortcoming, Microsoft provided equivalent functionality by relying on integration runtime of Azure Data Factory. In this article, you get an overview of this Azure-based SSIS offering.
2019-10-08
Integrating SQL Server Tools into SQL Change Automation Deployments
Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group.
2019-10-08
DevOps Self-Service for Databases with SQL Clone
Phil Factor describes the freedom of being able to "self-serve" databases, during testing and development, and explains how it works with SQL Clone.
2019-10-07
How to Use Parameters in PowerShell
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.
2019-10-07
Database Build Blockers: Cross-Server Database Dependencies
Phil Factor demonstrates how to tackle builds when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
2019-10-04
Entity Framework Core Raw SQL Queries Examples
In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.
2019-10-04
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
2019-10-03
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Menteng Telpon/WA:085355042311
BCA KCP Menteng Telpon/WA:085355042311 Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta...
Perlu menghubungi Halo BCA? Bisa melalui fiktur resmi BCA bebas pulsa
Ya,Layanan Halo BCA melalui 08137753549 tersedia 24 jam sehari, 7 hari seminggu untuk melayani...
Alamat kantor resmi BCA KCP Banda Telp:083178278662
Wa:083178278662Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat 40115
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers