RECENT POSTS
Converting VARBINARY to STRING on SQL Server
November 29, 2021
I recently had a requirement to load some data from a source table to another destination table. The destination columns were exactly the same as the source columns with the same data types and length. The only difference was that some columns on…
Installing AdventureWorks database
Tips & TricksSQLSample databases
November 27, 2021
In this blog post, I will be showing you how to install the AdventureWorks database on SQL Server. AdventureWorks is a sample database that is common amongst new and experienced database developers. It's a fictitious company that covers scenarios…
Installing SQL Server 2014
November 26, 2021
In this video, I show the steps for installing Microsoft SQL Server 2014. You can download it here: SQL Server 2014 Download Support for SQL Server 2014 ended July 9, 2019 but there's an extended support till July 9, 2024. You can read more details…
Install and Configure SQL Server 2017
November 26, 2021
In a previous post, I shared a video on how to install SQL Server 2014. Since SQL Server 2014's mainstream support ended on July 9, 2019. I have added a step by step instruction on how to install the 2017 version. You can download SQL Server 2017…
Sample SQL Server Database Downloads
SQL ServerBrent OzarAdventureworks databaseSample databases
March 28, 2017
As a database developer, one of the common questions asked is “where can I get sample data to practice with?” Whether you are a beginner, intermediate, or even an expert SQL developer, there is a high chance you have used the famous…
SQL SERVER – Sample Interview Questions and Answers (Series One) – Updated
SQLSQL ServerSQL Tips and TricksSQL Interview Questions and Answers
January 24, 2017
I will be sharing a series of interview questions and answers. The topics will be focused on: Data Modeling Transact SQL Data Warehouse Design SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS)…
Removing duplicate records from a table in SQL server
temporary tablesSQLSQL Servertsqlduplicate-removalCTE
January 23, 2017
Sometimes as a SQL developer, you might find a need to detect and remove duplicate records from a table. Duplicates often occur due to improper database design. There are quite a few methods of eliminating duplicate records. The method you decide…
Abayomi Obawomiye
I am a SQL Server/Business Intelligence Developer in Chandler Arizona. I share resources on beginner & advanced concepts in SQL Server.
Abayomi Obawomiye
I am a SQL Server/Business Intelligence Developer in Chandler Arizona. I share resources on beginner & advanced concepts in SQL Server.
RECENT POSTS
Converting VARBINARY to STRING on SQL Server
November 29, 2021
I recently had a requirement to load some data from a source table to another destination table. The destination columns were exactly the same as the source columns with the same data types and length. The only difference was that some columns on…
Installing AdventureWorks database
Tips & TricksSQLSample databases
November 27, 2021
In this blog post, I will be showing you how to install the AdventureWorks database on SQL Server. AdventureWorks is a sample database that is common amongst new and experienced database developers. It's a fictitious company that covers scenarios…
Installing SQL Server 2014
November 26, 2021
In this video, I show the steps for installing Microsoft SQL Server 2014. You can download it here: SQL Server 2014 Download Support for SQL Server 2014 ended July 9, 2019 but there's an extended support till July 9, 2024. You can read more details…
Install and Configure SQL Server 2017
November 26, 2021
In a previous post, I shared a video on how to install SQL Server 2014. Since SQL Server 2014's mainstream support ended on July 9, 2019. I have added a step by step instruction on how to install the 2017 version. You can download SQL Server 2017…
Sample SQL Server Database Downloads
SQL ServerBrent OzarAdventureworks databaseSample databases
March 28, 2017
As a database developer, one of the common questions asked is “where can I get sample data to practice with?” Whether you are a beginner, intermediate, or even an expert SQL developer, there is a high chance you have used the famous…
SQL SERVER – Sample Interview Questions and Answers (Series One) – Updated
SQLSQL ServerSQL Tips and TricksSQL Interview Questions and Answers
January 24, 2017
I will be sharing a series of interview questions and answers. The topics will be focused on: Data Modeling Transact SQL Data Warehouse Design SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS)…
Removing duplicate records from a table in SQL server
temporary tablesSQLSQL Servertsqlduplicate-removalCTE
January 23, 2017
Sometimes as a SQL developer, you might find a need to detect and remove duplicate records from a table. Duplicates often occur due to improper database design. There are quite a few methods of eliminating duplicate records. The method you decide…