Skip to content
The KenteCode AI Blog
  • KenteCode AI
  • Home
  • General
  • Data Analytics
The KenteCode AI Blog
  • KenteCode AI
  • Home
  • General
  • Data Analytics

About:vincentamedekah@gmail.com

Posts by vincentamedekah@gmail.com :

How to add a new column as a primary key to an existing table with data

Posted on May 21, 2025 by Vincent Amedekah

Merry Christmas and Happy new year to all my visitors. Thank you all for the support and continue the good work of liking the blog on facebook and referring others to visit here for support with some interesting topics. This is my last post of 2013 and l hope to continue contributing interesting topics to […]

Read More

Save your self by Trimming all white spaces around your data before storing in your data warehouse

Posted on May 21, 2025 by Vincent Amedekah

This week l had to show on the fly to a colleague of mine why it is very important to always clean data coming from different sources before storing it in the data warehouse. Most often than not, when you are building data warehouse and you are pulling data from other system, developers do not […]

Read More

The Danger of using NOLOCK in SQL Server queries

Posted on May 21, 2025 by Vincent Amedekah

This is a topic most of us never consider carefully when using nolock in our select queries. This week, one of the database administrators came out with a clear note to really discuss this topic with many developers at my work and l think its good to share some of those discussions on here.  Most […]

Read More

SQL Server Output Clause Illustration Using Texas Smart Meter Interval File

Posted on May 21, 2025 by Vincent Amedekah

I am watching the Houston Texans play Oakland while writing this post. Case Keenum, JJ Watt and the rest are all doing their best and Coach Kubiak is up here checking on the boys but l have to admit this season really sucks for the Texans. They have been beaten straight 8 or 9 times […]

Read More

  • «
  • 1
  • …
  • 17
  • 18
  • 19
  • 20
  • 21
  • …
  • 78
  • »
Vincent Kofi Amedekah

  • AI Automation: The Skill Powering the Future of Work
  • Airflow on Autopilot: Our CI/CD Workflow
  • From Reactive Firefighting to Proactive Resolution: The AIOps Revolution in IT Operations
  • How to ensure high quality data in our data systems
  • SQL Interview prep quiz 2 : Explain the difference between CTE and a subquery and give some advantages of using one over the other in OLAP vs OLTP systems
  • SQL interview prep quiz 1: Write sql code to print the letters of the English alphabet in upper case without explicitly writing the letters.
  • Evaluating car class using the k nearest neighbor algorithm from the scikit-learn Machine learning library in Python
  • Predicting the future price of Bitcon using time series analysis
  • Supply Chain Big Data Analysis To Predict Late Delivery Risk Of Customer Orders
  • Differences between aggregation and composition in Python Class
  • How to use analytic functions First_value and Last_value introduced in SQL Server 2012
  • How to use SQL Server extension ROLLUP to summarize data
  • Data profiling using SQL Server Integration Services – SSIS
  • OS questions
  • Restore database in sql server
  • Back up database in SQL Server.
  • Ping database in sql server.
  • Shrink database in sql Server.
  • Next word prediction application- Data Science Capstone
  • SQL Script to populate Date Dimension table in the Data warehouse.
  1. Home
  2. Articles Posted by Vincent Amedekah
  3. (Page 19)
© 2025 KenteCode AI - All rights reserved.