This is a question one of my friends asked me today at work and l decided to write it out and share with anyone who might need it. How do you ping a database on a server to see if its in a healthy state. Assuming your writing an application and you want to test […]
Have you been in a situation where you wanted to make a backup of a database and restore to another server and realized you couldn’t backup and restore to the new location because of the size of the database? How about even after dropping or truncating huge tables and still the database size is not […]
So l just completed my data science specialization with John Hopkins University via coursera today. I am actually excited completing this study because l’m new to data science and l need an introduction to know where to go next in my career as a sr. data developer. For the past 10 months, l have been […]
This is a simple script l wrote in SQL server 2012 which can be used to populate the Date table for use in a data warehouse. It provides components of the date which can be used in any situation. IF OBJECT_ID(‘tempdb..##Dates’) IS NOT NULL DROP TABLE ##Dates CREATE TABLE ##Dates(DateValue Date, YearValue INT, MonthValue INT, […]