Transparent Data Encryption known also known as TDE (learn more), encrypts SQL Server, Azure SQL Database and Azure SQL Data Warehouse data and log files on the OS-level. Moreover, a derived benefit is that also SQL Server-based backups of encrypted databases are also encrypted. This type of encryption can be…
Microsoft Azure SQL Database is a fully managed cloud database service, provided as part of Microsoft Azure. That means, that via the Microsoft Azure Portal, among other, you can easily create database servers, and thus host your databases. Moreover, you can still continue to use the same SQL tools you…
We have some amazing news about Snippets Generator! We are proudly announcing the general availability of Snippets Generator v3.3! With an a brand new, intuitive GUI, Snippets Generator helps you to easily create T-SQL code snippets for use in SQL Server Management Studio (SSMS). Moreover, you can edit existing T-SQL…
Back in 2008 I started “The SQL Server and .NET Blog” having as a mission to share my knowledge and experiences on SQL Server with you, the SQL Server Community. Throughout all these years, The SQL Server and .NET Blog was constantly evolving with new topics, and the most important,…
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. However, since SQL Server…
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…
![[Quick Tip] When is TempDB Used?](https://www.sqlnethub.com/wp-content/uploads/2018/02/help-icon-230x160.jpg "[Quick Tip] When is TempDB Used?"){kind=icon}
When is TempDB Used? That’s a very good question! TempDB is one of the system databases of SQL Server. As its name implies, it is being used for holding temporary stuff. However, after different discussions I had with a lot of people, I believe that many people have a misconception…
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 point – to check SQL Server’s…
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…
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 this is what you can try: Go to computer management – local users and groups, and add the service…
This short post examines the error message “Cannot declare instance members in a static class” when developing in C# in Visual Studio. Consider the below example: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Test { static class testClass { string sampleString = “Hello World!”; } }…
Microsoft SQL Server is one of the most powerful Relational Database Management Systems (RDBMSs) in the world. A RDBMS is a Database Management System (DBMS) based on the relational model which was invented by E. F. Codd. A database is an organized collection of data. This collection may include tables,…
The CONCAT_WS String Function in SQL Server 2017 is a new function that provides more flexibility for string operations. Definition CONCAT_WS concatenates a variable number of arguments setting as a delimiter the first argument in the function. Examples Before checking out some examples of using CONCAT_WS, let’s create a temporary table with…
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 (‘?’, ‘ ‘,…
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. But let’s take things from the beginning with the use of an example. First, let’s create a temporary table: CREATE TABLE…