From Source Control to Database using SQL Compare Command Line
Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
How Does Accelerated Database Recovery Work?
Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for rolling back large operations and database recovery. In this article, Forrest McDaniel explains how it works.
Analyze and Improve SQL Server Backup Schedule
Daily Operations | Database Backup Schedule | Time Savings - In this tip we look at a script you can use to help you better schedule when SQL Server backups are run so there is not contention with backups running on multiple instances at the same time.
Product Platform Teams
Today Steve notes that DevOps isn't going to eliminate Ops, even if developers support their own applications.
SQL Server Name Convention and T-SQL Programming Style
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
Deploying Data and Schema Together with SQL Compare or SQL Change Automation
You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.
SSRS is Still Around
The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the ease of use and features of Power BI. Despite all the news about the general availability of SQL Server 2019, I had not heard any recent news about SSRS, so I could only say that I didn’t know.
Data for Defense
The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.
Increase Query Speed with Covering Indexes
Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.
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 Taman Tekno Telp/wa 085169998765
Telp/wa 085169998765 Kavling Tofi, Blk. A No.3, RW.Sektor XI, BSD City, Kec. Serpong, Kota...
BCA KCP Intercon Megah. Tlp/wa:08218168235
Komp.Intercom Megah, Jl. Joglo Raya Blok W-IV No.27, Srengseng, Kec. Kembangan, Kota Jakarta Barat,...
Kantor BCA KCP Taman Tekno Telp/wa 085169998803
Telp/wa 085169998803 Kavling Tofi, Blk. A No.3, RW.Sektor XI, BSD City, Kec. Serpong, Kota...
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