Changing Replication Passwords
A how-to guide for configuring replication agents after a password change
2016-08-02
7,816 reads
Articles
Strengthening the Foundations of Software Architecture
The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.
2016-08-02
5,788 reads
How to Run Scheduled Jobs in Azure SQL Databases
This article will help you to schedule jobs in Azure SQL.
2016-08-01
14,185 reads
Introduction to Azure SQL Database Temporal Tables
As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.
2016-08-01
4,507 reads
Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation
Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.
2016-07-29
4,889 reads
Data Quality - Addressing non-stated requirements
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
2016-07-28
1,330 reads
A Real-World React.js Setup for ASP.NET Core and MVC5
React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.
2016-07-28
3,666 reads
Temporal Data Part 2 - Creating and Deleting System-Versioned Tables
Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.
2016-07-27
2,927 reads
Azure SQL Limitations compared with a SQL Server Enterprise
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
2016-07-26
15,138 reads
Redgate’s 2016 Roadmap
What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more.
2016-07-26
3,068 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA JLN. ANGGREK RT01/RW12 Hub:Cs.083831618816
WhatsApp:083831618816 Perum Bumi Cikarang Asri Blk. F5-F6, Ciantra, Cikarang Sel., Kabupaten Bekasi, Jawa Barat...
BCA KCP Saharjo Telp:08213111109
Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan, Daerah Khusus...
BCA KCP Parung No.Tlp.083179431643
Jl. Raya Parung Gg. Kp. Jati Ruko Blok A-B, Parung, Kec. Parung, Kabupaten Bogor,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers