tools Archives - {coding}Sight https://codingsight.com/tag/tools/ Blog for SQL Server DBAs and Developers Fri, 14 Jul 2023 15:48:09 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png tools Archives - {coding}Sight https://codingsight.com/tag/tools/ 32 32 How to Capture and Analyze SQL Server Events https://codingsight.com/how-to-capture-and-analyze-sql-server-events/ Fri, 15 Nov 2019 00:01:41 +0000 https://codingsight.com/?p=8123 When working as a SQL Server database administrator, you should have the skills to dive deeply into the ocean of the SQL Server Engine and find what is happening internally, in order to be able to detect, troubleshoot and fix any problem that you may face. You can take benefits from the logs that are …

The post How to Capture and Analyze SQL Server Events appeared first on {coding}Sight.

]]> 10 Best MySQL GUI Tools https://codingsight.com/10-best-mysql-gui-tools/ Tue, 10 Sep 2019 00:28:26 +0000 https://codingsight.com/?p=7723 MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes of designing, creating, and administering databases easier and more convenient. However, with all of the possible options, it can be difficult to choose one tool that will fit your requirements best. …

The post 10 Best MySQL GUI Tools appeared first on {coding}Sight.

]]> .NET – Tools for working with multithreading and asynchrony – Part 2 https://codingsight.com/net-tools-for-working-with-multithreading-and-asynchrony-part-2/ Sun, 14 Jul 2019 22:27:12 +0000 https://codingsight.com/?p=7421 This article comprises the second part of my speech at the multithreading meetup. You can have a look at the first part here. In the first part, I focused on the basic set of tools used to start a thread or a Task, the ways to track their state, and some additional neat things such …

The post .NET – Tools for working with multithreading and asynchrony – Part 2 appeared first on {coding}Sight.

]]> How to Document Your SQL Server Database https://codingsight.com/how-to-document-your-sql-server-database/ Mon, 01 Jul 2019 22:26:55 +0000 https://codingsight.com/?p=7325 The process of documenting a SQL Server database is a complete and continuous process that should start during the database design and development phases and continue during all database related life cycles in a way that ensures having an up-to-date version of the database documentation that reflects reality at any point in time. If performed …

The post How to Document Your SQL Server Database appeared first on {coding}Sight.

]]> .NET: Tools for working with multi-threading and asynchrony – Part 1 https://codingsight.com/net-tools-for-working-with-multi-threading-and-asynchrony-part-1/ Wed, 22 May 2019 22:28:24 +0000 https://codingsight.com/?p=7027 The need to do things in an asynchronous way – that is, dividing big tasks between multiple working units – was present long before the appearance of computers. However, when they did appear, this need became even more obvious. It is now 2019, and I’m writing this article on a laptop powered by an 8-core …

The post .NET: Tools for working with multi-threading and asynchrony – Part 1 appeared first on {coding}Sight.

]]> How to Automate the Process of SQL Server Database Schema Synchronization https://codingsight.com/how-to-automate-the-process-of-sql-server-database-schema-synchronization/ Sun, 19 May 2019 23:04:33 +0000 https://codingsight.com/?p=6700 The goal Keeping two databases in sync is a task we often encounter when working on SQL database development and maintenance. One particular case is this – the versions of a database present on testing and development environments need to be consistently synchronized to make sure that tests are running on the most recent version. …

The post How to Automate the Process of SQL Server Database Schema Synchronization appeared first on {coding}Sight.

]]> How to Write T-SQL Queries Like a Pro https://codingsight.com/how-to-write-t-sql-queries-like-a-pro/ Thu, 10 Jan 2019 12:36:07 +0000 https://codingsight.com/?p=5984 The skills of writing different types of SQL Server queries require you to have good knowledge in the SQL Server T-SQL language. T-SQL stands for Transact Structure Query Language, which is a database procedural programming language that is extending the SQL language for Microsoft SQL Server RDBMS product. The best and direct way of learning …

The post How to Write T-SQL Queries Like a Pro appeared first on {coding}Sight.

]]> Creating and Deploying Multiple Versions of Database through Schema Snapshots https://codingsight.com/creating-and-deploying-multiple-versions-of-database-through-schema-snapshots/ Fri, 28 Dec 2018 08:00:19 +0000 https://codingsight.com/?p=5850 Overview This article talks about using database schema snapshots to maintain different versions of a database to be deployed to different environments. Database schema snapshots are point-in-time copies of the current state of the database which are normally used to reconcile the differences when deploying changes from one environment to another environment. This article will …

The post Creating and Deploying Multiple Versions of Database through Schema Snapshots appeared first on {coding}Sight.

]]> Using Working Folder to Source Control Database https://codingsight.com/using-working-folder-to-source-control-database/ Mon, 05 Nov 2018 13:00:13 +0000 https://codingsight.com/?p=5498 This article is a walkthrough of how to use the working folder option of source control for managing SQL Server databases. In this article, I am also underlining some of the benefits and limitations of using a working folder as compared to other available options to use with source control. Let us discuss some key …

The post Using Working Folder to Source Control Database appeared first on {coding}Sight.

]]> How to Generate Test Data in SQL Server https://codingsight.com/generating-test-data-in-sql-server/ Thu, 01 Nov 2018 12:15:13 +0000 https://codingsight.com/?p=5425 When testing the functionality of your application or the performance of a specific stored procedure or an ad-hoc query in the development environment, you need to have data stored in your development databases typical or similar to the data stored in the production databases. This is because the performance of a query that is processing …

The post How to Generate Test Data in SQL Server appeared first on {coding}Sight.

]]>