Getting Started with CQRS – Part 3
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
2020-04-20
Additional Articles
Updated First Responder Kit and Consultant Toolkit for March 2020
In the immortal words of “Orange” Julius Caesar as written by Shake’s peer, “Beware the bugs of March.” It took us 2,064 years, but we’ve finally fixed those bugs, plus added a couple of new features.
2020-04-17
Solve SQL Server Agent Job Dependencies with Data Driven Solution
In this tip I will demonstrate a simple way of launching a SQL Agent job when the job it depends on completes successfully.
2020-04-16
Take the 2020 State of Database Monitoring Survey
The State of Database Monitoring survey is open. How are you currently monitoring your database estate? Are you working cross-platform? Tell us your opinions in our annual survey on the State of Database Monitoring for your chance to win a $500 Amazon voucher.
Take the survey.
2020-04-16
Advanced Performance Tuning for Microsoft SQL Server
No matter where you run your SQL Server® instances—on-premises, in a virtual machine, or in an Azure SQL Database Managed instance—the challenge is the same. How do you ensure you get optimum performance? Is the virtual machine impacting your database instance performance? Which queries cause the most blocking or deadlocking? Are you consuming more DTUs in your Azure SQL Database than you budgeted for?
2020-04-15
Adding Reports Users to SQL Monitor
SQL Monitor 10.0.5 now supports a user role called "Reports user". A user added to this role, by an administrator, will be able to 'self-serve' SQL Monitor reports but won't be able to configure any other aspect of the monitoring service. Jeremiah Peschka explains how it works.
2020-04-14
Considerations for Deploying Azure SQL Database Managed Instances
While Microsoft provides a number of different deployment options for its Azure SQL Database offerings, one in particular warrants special attention from the standpoint of its infrastructure dependencies: Azure SQL Database Managed Instance.
2020-04-14
How to ACTUALLY save money in the cloud with SQL Server
We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.
2020-04-14
Getting Started with SQL Data Masker: I Need to Mask some Columns
Grant Fritchey explains the core rules and features of Data Masker, and how you go about using them to mask columns, so that when the data is used outside the production system it could not identify an individual or reveal sensitive information.
2020-04-13
Reduce CPU of Large Analytic Queries Without Changing Code
Microsoft introduced several features called Intelligent Query Processing for SQL Server in 2017 and 2019 that can improve performance without making changes to code. In this article, Greg Larsen demonstrates the feature Batch Mode on Rowstore.
2020-04-13
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 KCP Jelambar Baru Raya Telpon/WA:08137887595
BCA KCP Jelambar Baru Raya Telpon/WA:08137887595.Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol...
BCA KCU SUKABUMI Tlpn/wa:085373737551
Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
BCA Finance Kelapa Gading Layanan Mobil Telpon/WA:0851•8812•0691
BCA Finance Kelapa Gading Layanan Mobil Telpon/WA:0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...
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