This article is about SQL Server’s TempDB System Database, and it is from my eBook: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More Introducing the TempDB System Database in SQL Server The tempdb system database in SQL Server is one of the databases that are shipped with every SQL … Read more…
This article discusses the importance of database indexes, how indexing in a database boosts performance, and it is from my eBook: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More | Buy What is a Database Index? Imagine that you have a large book and you are looking for a … Read more…
[Update: SQLArtBits is Now SQLNetHub!] You can find the latest version of DBA Security Advisor here. On April 5 2017, SQLArtBits releases DBA Security Advisor v2.0. This article gives a sneak peek of the upcoming new release of DBA Security Advisor v2.0. DBA Security Advisor is a powerful tool developed by SQLArtBits that allows Database Administrators (DBAs) … Read more…
We are all beginners. We are not experts or gurus. There is no such thing. This is just an illusion. In the end of the day, we are all beginners who constantly learn and evolve. The majority of articles I publish on my blog target topics that could be characterized as intermediate and sometimes advanced. … Read more…
There are many cases where a DBA needs to perform a task against all databases in a SQL Server instance. In order to avoid the process of just changing a part of the statement or switching to the target database and executing the T-SQL statement each time, there are some options that can help you. … Read more…
When you try to connect to a SQL Server database from a client application, under certain circumstances, you might get the below error message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 – No process is on the other end of the … Read more…
In my previous article of this blog series, I introduced SQL Server In-Memory OLTP and explained how it is possible to create an In-Memory OLTP – enabled database. Also, I showed via simple examples, how easy is to create memory-optimized tables (durable and non-durable). Today we are going to talk about naively-compiled stored procedures as well … Read more…
SQL Server In-Memory OLTP (MS Docs article) is a powerful engine integrated into the SQL Server Engine (version 2014 and later), optimized for Online Transaction Processing (OLTP). This article helps you getting started with SQL Server In-Memory OLTP and it is the first part in a series of articles focusing on SQL Server In-Memory OLTP. … Read more…
Until recently, enabling the frequent password expiration option in SQL Server was included in many security best practices. However, recent studies, revised this recommendation and support that it should not be further included in SQL Server’s security best practices. However, if this is the case, how can this recommendation be replaced with new, modern best … Read more…
Another year has passed…as always, full of everything! Events, blog posts, articles on well-known online SQL Server journals, software tools, and of course direct communication with you, my fellow SQL Server community members, via all available online and offline channels! This year was very important for me. Besides my blogs and user group events, I … Read more…
This article, provides a basic example, on how to establish a connection to SQL Server from a C# program with the use of the “using” statement in C# which help you better managing your database connections. Using the System.Data.SqlClient Use the System.Data.SqlClient namespace in the top section of your code as below: using System.Data.SqlClient; … Read more…
When developing a .NET application (i.e. in C#), under certain circumstances, you might get the error message: Cannot implicitly convert type ‘string’ to ‘System.Windows.Forms.DataGridViewTextBoxColumn Why you got the implicit conversion error If you get the above error, then you have most probably set as a column name for one of your datagridview column the reserved … Read more…
This article discusses how to patch a SQL Server Failover Cluster. Patching SQL Server is one of the main administrative tasks in the DBA’s life. However, patching SQL Server is a procedure that needs to be planned, tested, and performed very carefully. Below you can find a suggested methodology for patching a failover … Read more…
Sometimes, when working with T-SQL scripts, you might want to skip the message “(N row(s) affected)” message. This article explains how to suppress the “N Row(s) Affected” output message in SQL Server. About the N Row(s) Affected” output message in SQL Server You get this message when you execute T-SQL statements or stored procedures … Read more…
I love being an active member of the SQL Server and .NET communities. There is something magical in this. I don’t know. Maybe it’s the thrill of writing a new article giving solution to a technical problem, or an article on a new technology or feature, or a webcast maybe? Perhaps it’s the excitement when … Read more…