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.Sep 29, 2020Sep 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.Aug 31, 2020Aug 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.Aug 11, 2020Aug 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…Aug 11, 2020Aug 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.Jul 23, 2020Jul 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.Jul 22, 2020Jul 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.Jul 22, 2020Jul 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…Mar 19, 20201Mar 19, 20201
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.Dec 20, 2019Dec 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 ServerAug 14, 2019Aug 14, 2019