Data Science Introduction
In the simplest terms, data science is a way to dig out knowledge from data, either structured or […]
data
Excel Combine Worksheet Data
The objective for this post is to learn how to combine (merge) more than one Excel worksheet file […]
SQL Server Data Validation Part 2
2. Fruit Name and Fruit Code – Case 1 This post is a continuation of SQL Server Data […]
Statistics Introduction
Series of Posts This post is the first part of a short series of posts called Statistics. You […]
SQL Server Strings Concatenation
Numbers and Strings If you want to concatenate a number to a string you need to know how […]
SQL Server Export to Excel
https://www.microsoft.com/en-us/download/details.aspx?id=23734 Wizard From within SQL Server you can use the wizard to export a tables or tables (using […]
SQL Server Datetime
The topic of date and time in SQL Server requires more attention than any of the other data […]
SQL Data Numerics
This post is based on the stairway series at SQL Server Central called Stairway to Data, by Joe […]
SQL Server Introduction
Wikipedia says: “Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, […]
Database Model
Wikipedia says the following about the definition of a Database Model: “A database model is a type of […]
Metadata Introduction
What is metadata? Wikipedia says the following about Metadata: “Metadata is “data [information] that provides information about other […]
Lorem Ipsum
Here is what Wikipedia says about Lorem Ipsum: “In publishing and graphic design, lorem ipsum (derived from Latin […]