Evgeniy GribkovinTowards Data ScienceBest Database design tools for Forward and Reverse EngineeringThis article highlights the basic requirements for visual tools meant for the forward and reverse database engineering.9 min read·Sep 29, 2020----
Evgeniy GribkovinTowards Data ScienceSQL Unit Testing Stored Procedure for SQL ServerIn this article, we are going to apply SQL unit testing for the stored procedure of an SQL Server database for a recruitment service.9 min read·Aug 31, 2020----
Evgeniy GribkovinTowards Data ScienceSearching for invalid objects in the SQL Server databaseThe article sets out to solve the problem of finding and fixing invalid objects in SQL Server databases.4 min read·Aug 11, 2020----
Evgeniy GribkovinTowards Data ScienceSearching for Database Objects and Table Data in SQL ServerLet’s look into the intricacies of database data and object search in SQL Server and see how to conduct it with standard scripts and with…6 min read·Aug 11, 2020----
Evgeniy GribkovinTowards Data ScienceExporting and Importing JSON DataThe article reveals valuable information on how to perform data export and import in a SQL Server database.7 min read·Jul 23, 2020----
Evgeniy GribkovinTowards Data SciencePopulating the Employee Database with Test DataProceeding with the example of an employee database, this time we will figure out how to populate a database with test data.5 min read·Jul 22, 2020----
Evgeniy GribkovinTowards Data ScienceSQL Database Design Basics with ExampleThis article explains the basic concepts of database design and shows how to create a database schema providing a vivid example.11 min read·Jul 22, 2020----
Evgeniy GribkovinTowards Data ScienceCreating custom SQL Server replication for read-only databasesLet’s discuss SQL Server replication using T-SQL. And consider the general algorithm for replicating tables in one direction from source…6 min read·Mar 19, 2020--1--1
Evgeniy GribkovinTowards Data ScienceImplementing Components of Database DevOps ProcessLet’s look at how some components of the database DevOps process can be implemented, on the example of a database of potential employees.7 min read·Dec 20, 2019----
Evgeniy GribkovinTowards Data ScienceFormatting Capabilities in SQL Complete for MS SQL ServerGetting back to the issue of time optimization. One more way of quick scripts understanding and defining objects in MS SQL Server6 min read·Aug 14, 2019----