The Justification Database
Having a good process for managing security is important, but how many of us enforce that?
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.
Top 10 Methods to Improve ETL Performance Using SSIS
Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.
Bad Culture Bad Security
Another company has hard-coded credentials, which Steve feels are a sign of bad culture.
Transform your Winning team into a Champion Team
Businesses worldwide now operate on a team basis, and a high-performing team is crucial for high-performing organizations. Winning teams are more focused and better than regular teams. They focus on synergies and achieving significant results. They are an extension of regular teams with a higher sense of commitment to objectives and mutual purpose. Winning teams have a clear mission and achievable performance goals for each member, aiming for extraordinary goals. They are more committed to the vision and have a passion for achieving the mission. Winning teams work collaboratively to discover new work approaches, principles, and practices, focusing on decision-making, creative problem-solving, industry standards, and effective communication. They establish processes from beginning to end to complete tasks effectively. The difference between winning team and a regular team is very clear. However, what makes a winning team a champion team. This paper aims to provide valuable insights into the differentiating factors of a champion team from a winning one.
The promise – and the perils – of GitHub Copilot
There’s been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation.
Understanding Locking, Data Modification and Committing Data in SQL Server
Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.
Celebrate THEIR Accomplishments
I can't hide this in any way. I love it when I accomplish something. It's such a great feeling. Even more than that, I really do love getting some acknowledgement for it. Almost as good, is when I see others, especially friends and acquaintances, doing well. So many people I know, regularly just knock it […]
Declining Work for Mental Health
A busy year got a little too busy for Steve and he is taking steps to improve his work life balance.
What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Learn how to use CTEs through the use of a number of examples.
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 KCP Buah Batu Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Buah Batu No.192, Cijagra, Kec. Lengkong, Kota Bandung, Jawa Barat 40226
Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Alamat kontak resmi BCA KCP Taman Melati Telp:0817866887
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers