Skip to content
We are working on our new AI Platform. Contact info@kentecode.ai for more info
  • Home
  • General
  • SQL Server
  • Data Analytics
We are working on our new AI Platform. Contact info@kentecode.ai for more info
  • Home
  • General
  • SQL Server
  • Data Analytics

About:vincentamedekah@gmail.com

Posts by vincentamedekah@gmail.com :

How to find stolen or lost Samsung Galaxy S4 or make phone useless in the United States after it gets stolen or lost

Posted on January 25, 2019 by Vincent Kofi Amedekah

Happy New year, I thought my last post on sql server would be my last of 2013 but something just came and with the unfortunate experience, l quickly want to write on some ways to insure your smartphone especially Samsung Galaxy S4 becomes useless when someone stole it or when you lost it. You may […]

Read More

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

Posted on December 28, 2013 by Vincent Kofi 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 December 8, 2013 by Vincent Kofi 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 24, 2023 by Vincent Kofi 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

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

  • 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.
  • 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
  • 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.
  • Machine Learning predicting quality of exercise performed using smart wearable device data.
  • Comparing accuracy of prediction of Alzheimer’s diagnosis by Machine Learning Algorithms Random Forest, Boosted Trees and Linear Discriminant Analysis to a stack prediction of all the three Algorithms.
  • Brief introduction to the R package caret for Machine Learning.
  • Notes on SDLC Models
  • SQL Procedure to allow registration of only employees of your company for your site.
  • ETL Process in Data Warehouse
  1. Home
  2. Articles Posted by Vincent Kofi Amedekah
  3. (Page 18)
©2025 All Rights Reserved. KenteCode.ai