sql server Archives - {coding}Sight https://codingsight.com/tag/sql-server/ Blog for SQL Server DBAs and Developers Thu, 14 Mar 2024 21:25:42 +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 sql server Archives - {coding}Sight https://codingsight.com/tag/sql-server/ 32 32 How to Get SQL Percentage Calculation as Easy as Pie  https://codingsight.com/sql-percentage-calculation/ Thu, 14 Mar 2024 15:54:32 +0000 https://codingsight.com/?p=26091 Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a beginner, it’s easy to get lost in a maze of numbers and functions. You may stumble over pitfalls that can lead to incorrect results. But fear not because we’re about to make SQL percentage calculations as easy as pie!  …

The post How to Get SQL Percentage Calculation as Easy as Pie  appeared first on {coding}Sight.

]]> Best FREE SQL Server Tools for Database Developers and Administrators! https://codingsight.com/free-tools-for-mssql-database-developers-and-administrators/ https://codingsight.com/free-tools-for-mssql-database-developers-and-administrators/#comments Thu, 07 Dec 2023 12:48:20 +0000 http://codingsight.com/?p=84 This article has recently been extensively revised. In particular, we reworked the article structure, and navigation, and updated descriptions of the tools featured. We have also thoroughly checked all links to guarantee their active status and ensured that the information regarding all tools is current and accurate. The current material comprehensively lists the best SQL …

The post Best FREE SQL Server Tools for Database Developers and Administrators! appeared first on {coding}Sight.

]]> https://codingsight.com/free-tools-for-mssql-database-developers-and-administrators/feed/ 1 dbForge Edge: Your Best Universal Tool for Multidatabase Challenges https://codingsight.com/introducing-dbforge-edge/ Tue, 06 Jun 2023 11:34:26 +0000 https://codingsight.com/?p=24719 Handling several database management systems simultaneously is inevitable in working on multiple projects. At the same time, each system requires a proper set of relevant tools to perform database tasks. These tools should be powerful and flexible enough to adapt to the project’s evolving needs. One moment, your goal is to design a new database …

The post dbForge Edge: Your Best Universal Tool for Multidatabase Challenges appeared first on {coding}Sight.

]]> 31 Must-Know SQL Server DBA Interview Questions – Are You Prepared? https://codingsight.com/sql-server-dba-interview-questions-and-answers/ Tue, 01 Nov 2022 08:52:01 +0000 http://codingsight.com/?p=20295 This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and answers in this article. If you want to get more information, visit all the attached links. All interview questions have been segregated between the below headings. Please give your feedback in the comment section …

The post 31 Must-Know SQL Server DBA Interview Questions – Are You Prepared? appeared first on {coding}Sight.

]]> SQL Aggregate Functions: Easy Tips for Newbies https://codingsight.com/what-are-sql-aggregate-functions-easy-tips-for-newbies/ Wed, 28 Sep 2022 07:59:00 +0000 http://codingsight.com/?p=15123 SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these calculations on data sets: But there’s more. Statistical calculations like standard deviation and variance are also part of the tools. Mix it with grouping and sorting, and you’ll have something fantastic for your new report. So, …

The post SQL Aggregate Functions: Easy Tips for Newbies appeared first on {coding}Sight.

]]> User-Defined Data Types In SQL Server https://codingsight.com/user-defined-data-types-in-sql-server/ Fri, 18 Mar 2022 17:29:01 +0000 http://codingsight.com/?p=16863 SQL Server platform comes with many data types, but there are cases when they are not sufficient. Or, custom data types could help make code cleaner and more transparent, and maintainable. Custom data types are, in SQL Server wording, user-defined types (UDT). They are internally implemented as .NET objects requiring .NET Framework to be installed …

The post User-Defined Data Types In SQL Server appeared first on {coding}Sight.

]]> SUBSTRING Command in SQL: A Primer https://codingsight.com/substring-command-in-sql-a-primer/ Tue, 15 Mar 2022 15:47:13 +0000 http://codingsight.com/?p=19722 Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to the STUFF command in regards to the parameters it accepts. In the vast landscape of data manipulation, one function that consistently proves its worth is the ‘SUBSTRING’ in SQL Server. As …

The post SUBSTRING Command in SQL: A Primer appeared first on {coding}Sight.

]]> Getting Started with the SQL Server T-SQL CASE Expression Statement https://codingsight.com/getting-started-with-the-sql-server-t-sql-case-expression-statement/ Tue, 15 Mar 2022 15:44:46 +0000 http://codingsight.com/?p=19931 SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple conditions in the CASE..WHEN expression and get the associated output defined in the THEN or ELSE statement. CASE expression offers two approaches to compare and return a condition-based result. As per MSDN, the Simple …

The post Getting Started with the SQL Server T-SQL CASE Expression Statement appeared first on {coding}Sight.

]]> SQL Server Primary Key https://codingsight.com/primary-keys-in-sql-server/ Tue, 22 Feb 2022 14:20:47 +0000 http://codingsight.com/?p=18566 Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely. Hence, we should choose Primary Keys server carefully during the table design to improve the performance. In this article, we’ll learn what a Primary Key constraint is. Also, we’ll see how to …

The post SQL Server Primary Key appeared first on {coding}Sight.

]]> SQL Server Triggers – Part 2 DDL & LOGON Triggers https://codingsight.com/sql-server-triggers-part-2-ddl-logon-triggers/ Mon, 18 Oct 2021 11:26:37 +0000 http://codingsight.com/?p=19344 In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server. Triggers play a key role in achieving business requirements like alerting targeted people based upon a condition achieved, starting a job, or other operations. In the previous article on DML triggers, we talked about …

The post SQL Server Triggers – Part 2 DDL & LOGON Triggers appeared first on {coding}Sight.

]]>