While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month.
2023-11-01
There are good reasons why business leaders should care about their databases—and hidden costs for neglecting them. Our CMO, Kate Duggan, wrote about the risks and potential costs in this article on Bloomberg.
2023-11-01
In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
2023-10-30
If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes!
2023-10-30
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years.
2023-10-27
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
2023-10-27
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.
2023-10-25
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.
2023-10-25
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.
2023-10-23
Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.
2023-10-23
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Telp/Wa 628218200203 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok...
Telp/Wa 628218200233 Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten 42112
How many types of DML triggers are there?
See possible answers