If you worked -or still working- with SQL Server 2005 (or even earlier), you must have noticed that when you installed these SQL Server versions, the local Windows group “Built-In\Administrators” was automatically included in the SQL Server instance along with getting the role “SysAdmin” server role. This actually, when it comes to SQL Server security, … Read more…
I have been writing software since I was 10. I enjoy the challenge of solving different problems with the use of simple, yet powerful software tools. My latest initiative in the last few years was SQLArtBits, and before that, Artemiou Data Tools. Via Artemiou Data Tools and SQLArtBits, I have released useful SQL Server tools. … Read more…
When is TempDB Used? That’s a very good question! In this SQL Server Administration quick tip, we will be discussing about, when the TempDB SQL Server system database is used. About the TempDB System Database in SQL Server TempDB is one of the system databases of SQL Server. As its name implies, it is … Read more…
This short post discusses SQL Server Support for TLS 1.2. It is a recommended security best practice, to upgrade to Transport Layer Security (TLS) protocol 1.2 as several known vulnerabilities have been reported against SSL and earlier versions of TLS. Many of us who work with SQL Server, we needed – or will need at a … Read more…
Hey folks all around the world! I hope you are having a great time! I do, and I’m super excited to announce today that I’m launching a new post category on the SQLNetHub Blog. The name of this category is “Quick Tips“. I really enjoy writing long and comprehensive articles which explore all those amazing … Read more…
If you are trying to start SQL Server Agent and you get the error message SQLServerAgent could not be started (reason: Unable to connect to server ‘(local)’; SQLServerAgent cannot start) then read below, in order to see what you can try for resolving the issue. How to Resolve the Issue Go to computer management … Read more…
This short post examines the error message “Cannot declare instance members in a static class” when developing in C# in Visual Studio. This article provides useful information such as how you can reproduce the error message in order to better understand its root cause, as well as how you can resolve the issue. Reproducing the … Read more…
Microsoft SQL Server is one of the most powerful Relational Database Management Systems (RDBMSs) in the world and it is absolutely logical the fact that many people are looking for the best way to learn SQL Server. By learning SQL Server, you acquire a competitive advantage in the job market. Read on to find out … Read more…
In this article, we will be discussing about the CONCAT_WS string function, which was first introduced in SQL Server 2017 About the CONCAT_WS String Function in SQL Server The CONCAT_WS string function, is function that was originally shipped with SQL Server 2017. This function, provides more flexibility for string operations. Definition CONCAT_WS concatenates a … Read more…
This article provides different SQL Server index rebuild scripts. Script 1: Rebuild all indexes in a SQL Server database with specifying the Fill Factor: –Rebuild all indexes in a database –Note: You need to specify the fill factor USE [DatabaseName] GO EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 90)”; GO Script 2: … Read more…
When writing T-SQL code, at some point, under certain circumstances, you might get the error message: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Explaining the Error Message with an Example But let’s take things from the beginning with the use of an example. First, let’s create a temporary … Read more…
In this article, we will talk about the SQL Server error message “An object or column name is missing or empty” and see how you can easily overcome this error. More about this error message So, you ran a query and got the error message: An object or column name is missing or empty. For … Read more…
Sometimes, under certain circumstances, when you develop in SQL Server and especially when you try to convert a string data type value to a float data type value, you might get the error message: error converting data type varchar to float. As the error message describes, there is a conversion error and this is most … Read more…
Wow! Another year has passed! Another great year! Full of SQL Server power! Events, blogging, community building, software, webcasts, discussions, tweets, guest article writing, book writing, and more! Besides the intensive blogging and article writing, another major contribution this year, was the transformation of my blog “The SQL Server and .NET Hub” to the “SQLNetHub” portal. SQLNetHub … Read more…
This article discusses what’s New in Microsoft SQL Server Management Studio v17.4 One of the best things Microsoft did regarding SQL Server tools, was the separation of the SQL Server Management Studio’s (SSMS) distribution from SQL Server’s installation media. This allowed Microsoft to proceed faster with updating and enhancing SSMS on a frequent basis. Therefore, … Read more…