In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.
Is it better to copy and distribute data or centralize it? Steve has a few thoughts today.
A common debate in table architecture is whether to use a natural or surrogate key. In this article, I discuss some of the advantages to each method.
In this article, you will explore tools and extensions that can be used with Visual Studio 2019 to improve your database experience irrespective of what database you use.
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
As we grow and evolve in our careers, we face new challenges all the time. Steve highlights on of those that some tech workers worry about today.
Machine learning is a skill that many data professionals are learning as they plan their careers over the next five to ten years. In this article, Supriya Pande gives an overview of machine learning and walks through a practical example.
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Raya Jakarta-Bogor No.8, Cirimekar, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16917
8M98+J42, Babakan, Kec. Pangandaran, Kabupaten Ciamis, Jawa Barat 46396
Jl. Surya Kencana Ruko D5-D6, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
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