The error message “SQL Server error 18456: Login failed for user <username>‘” may appear, under certain circumstances, when you attempt to access your SQL Server database using a specified username and password. In this article, we’ll be discussing about how you can resolve the issue. How to Resolve the “Login Failed for User” Error … Read more…
Database design is a critical aspect of SQL Server development. A well-designed database can improve data quality, increase performance, and reduce maintenance costs. In this article, we’ll cover various best practices for designing SQL Server databases, including normalization, data types, and relationships. Normalization Normalization is the process of organizing data in a database to … Read more…
Hi friends! In this article, we’ll be discussing about how you can easily set filters for OpenFileDialog and SaveFileDialog in C# and see some simple examples. What are Filters? Filters are used in OpenFileDialog and SaveFileDialog in C# to specify the type of files that can be opened or saved. A filter is a … Read more…
Hi friends, this T-SQL tips is about how you can retrieve the version name a SQL Server instance using the @@VERSION system function in SQL Server. The T-SQL Script for Retrieving the Version Name Here’s the script. As you can see, in order to retrieve the version name for the SQL Server instance we … Read more…
Hi friends, in this short article, we will be discussing about, how you can resolve the following issue that might occur under certain circumstances, when launching SQL Server Management Studio (SSMS) 19.x: Unable to load DLL ‘Microsoft.Data.SqlClient.SNI.x86.dll’ The Error Message The exact error message is the below: Cannot connect to [instance name] —————————— … Read more…
Hi friends, in this article, we’ll be discussing about an error message you might get under certain circumstances, when installing SQL Server. The title of the error is Rule “Setup account privileges” failed and more specifically it reports the following: The account that is running SQL Server Setup doesn’t have one or all of the … Read more…
SQL Server database backup and recovery is a critical task for any database administrator. Having a reliable backup and recovery strategy in place, can help ensure that critical data is not lost and operations can resume as soon as possible in the event of a hardware failure, software issue, or other data loss event. In … Read more…
Hi friends, in this article, we’ll be discussing about certain advanced SQL Server features and techniques, that can help experienced DBAs, to tune the SQL Server data platform even more, in terms of performance, security and scalability. So, as an experienced SQL Server DBA, you are probably familiar with the fundamentals of SQL Server. There … Read more…
Hi friends, in an older article, we have talked about how you can connect to SQL Server databases from a Python program. In this article, we will be discussing about the Python Data Access fundamentals, that is how you can connect to different databases from within your Python code. In general, Python provides the capability … Read more…
Hi friends, in this article, we will be discussing about the Azure Synapse Link in SQL Server 2022. Note that this topic, is also part of my course on Udemy “SQL Server 2022: What’s New – New and Enhanced Features“, so feel free to check it out on Udemy. What is Azure Synapse Analytics? … Read more…
Hi friends, in this article, we’ll be discussing about Query Store Enhancements in SQL Server 2022. Note that this lecture, is part of my online course on Udemy, titled: “SQL Server 2022: What’s New – New and Enhanced Features“. About Query Store in SQL Server Query Store, is feature that was originally shipped with … Read more…
Hi friends, in this article, we will be discussing about, how to resolve the below error, when working with CLR assemblies in SQL Server: An error occurred in the Microsoft .NET Framework while trying to load assembly id… The server may be running out of resources, or the assembly may not be trusted. Run the … Read more…
Hi friends! Today we are pleased to announce the availability of our free course, titled “Get Started with SQL Server on Linux – FREE Course For Beginners“. About the Course Via this short course, you will learn how you can easily get started with SQL Server on Linux. To this end you will learn: … Read more…
Hi friends, in this article, we will be discussing about how SQL Server evolved over the years in terms of Azure features, and why this release, makes SQL Server a hybrid data platform, with powerful capabilities, not only on premises, but also on the Azure cloud, via built-in integration mechanisms. Below, we list the major … Read more…
Yesterday, November 16 2022, Microsoft announced the general availability of SQL Server 2022. The long-awaited new release of SQL Server, includes many features in all aspects of the popular data platform, but also an additional set of features, that make SQL Server the most Azure-enabled release of SQL Server yet. Let’s discuss about the highlights … Read more…