Database administration Archives - {coding}Sight https://codingsight.com/category/database-administration/ 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 Database administration Archives - {coding}Sight https://codingsight.com/category/database-administration/ 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.

]]> SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets  https://codingsight.com/understanding-sql-partition-by/ Fri, 21 Jul 2023 16:27:34 +0000 https://codingsight.com/?p=25208 Is SQL Server PARTITION BY clause giving you a brain freeze?  Beginners feel like entering a complex maze at first glance of code complexity. But you want to tackle this like a piece of cake, without the confusion. And without hair-pulling. So, this article is for you. We’ll make it plain and simple.  The complication …

The post SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets  appeared first on {coding}Sight.

]]> T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time  https://codingsight.com/char-vs-varchar-in-sql/ Fri, 07 Jul 2023 13:06:46 +0000 https://codingsight.com/?p=25079 Is it a big deal to choose between CHAR and VARCHAR? What if your choice between CHAR vs. VARCHAR results in a nightmare of query lags?  When I was a newbie in SQL Server, it was not a big deal to me. Both store strings of characters so I thought it was just the same.  …

The post T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time  appeared first on {coding}Sight.

]]> How to Download, Install and Restore AdventureWorks Database in SQL Server https://codingsight.com/restoring-sample-dw-database-adventureworksdw2019/ Sun, 18 Sep 2022 12:02:00 +0000 http://codingsight.com/?p=19232 Sometimes, we need a sample database that has all the required objects along with a large set of data inside the database for our various testing needs or our learning purpose. Microsoft has developed several sample databases for each type of workloads like the AdventureWorks database for OLTP workload and the AdventureWorksDW database for data …

The post How to Download, Install and Restore AdventureWorks Database in SQL Server appeared first on {coding}Sight.

]]> What is SQL Server? (Definition, Versions, Editions) https://codingsight.com/what-is-sql-server-definition-versions-editions/ Thu, 07 Oct 2021 13:37:46 +0000 http://codingsight.com/?p=16843 Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You don’t know where to start. Learning SQL Server for the first time feels the same. And that’s what this article is about. It will answer the very first …

The post What is SQL Server? (Definition, Versions, Editions) appeared first on {coding}Sight.

]]> SSDT (SQL Server Data Tools) for Visual Studio: Main Features https://codingsight.com/overview-of-sql-server-data-tools-ssdt-features/ Mon, 27 Sep 2021 08:33:17 +0000 http://codingsight.com/?p=17443 SQL Server provides SQL Server developers and administrators with dedicated client tools for day-to-day usage. Namely, they are SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT). Since SSMS is widely popular among all SQL Server developers and administrators, we will focus on the SSDT client tool more to understand the value of …

The post SSDT (SQL Server Data Tools) for Visual Studio: Main Features appeared first on {coding}Sight.

]]> Get Your SQL Server Database Size with Ease: Stored Procedures in Action https://codingsight.com/stored-procedure-to-get-server-storage-information-in-server/ Mon, 27 Sep 2021 08:24:33 +0000 http://codingsight.com/?p=17145 As popular as the cloud services are nowadays, there’s still a good chunk of on-premises deployments of SQL Server that still require our services to support them. One of the areas of on-premises setups that we must keep an eye on is storage, right where the data is saved. I’m going to present you a …

The post Get Your SQL Server Database Size with Ease: Stored Procedures in Action appeared first on {coding}Sight.

]]> The Importance of SQL Server Data Tools (SSDT) https://codingsight.com/sql-server-data-tools-ssdt/ Mon, 13 Sep 2021 05:56:50 +0000 http://codingsight.com/?p=16993 Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features. In this article, we will go through various Client Tools offered by SQL Server itself and learn about SQL Server Data Tools and its hidden potentials to make the lives of DBAs and Developers …

The post The Importance of SQL Server Data Tools (SSDT) appeared first on {coding}Sight.

]]> Machine Learning {.NET} Image Classification https://codingsight.com/machine-learning-net-image-classification/ Tue, 07 Sep 2021 04:05:48 +0000 http://codingsight.com/?p=16798 One of the best scenes from Silicon Valley is Jian Yang demoing his “Hotdog, not hotdog” application. In this article, we will build our own “Hotdog, not hotdog” solution using ML.NET. After all, who would not want to determine if that dish is, or is not a hot dog? Just take a picture, upload it …

The post Machine Learning {.NET} Image Classification appeared first on {coding}Sight.

]]> How to Read and Interpret SQL Errors https://codingsight.com/how-to-read-and-interpret-sql-errors/ Fri, 03 Sep 2021 05:30:52 +0000 http://codingsight.com/?p=16608 Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on the SQL version you’re using, but they usually indicate the inability to perform a requested operation. The easiest way to explore it is the simplest programming language called BASIC and its programs …

The post How to Read and Interpret SQL Errors appeared first on {coding}Sight.

]]>