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

Category: SQL Server

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

SQL Server Output Clause Illustration Using Texas Smart Meter Interval File

Posted on November 17, 2013 by Vincent Kofi 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
  • …
  • 4
  • 5
  • 6
  • 7
  • 8
  • …
  • 31
  • »
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. Archive by Category "SQL Server"
  3. (Page 6)
©2025 All Rights Reserved. KenteCode.ai