iLearnSQL

MCSA 2012, MCDBA, MCITP, MCP, MCTS(SQL Server 2005), MCTS (Database Development, 2008), ITIL v3
  • Tagline: Data knows everything ...

SQLServerCentral Article

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]

5 (2)

You rated this post out of 5. Change rating

2022-12-26 (first published: )

21,743 reads

SQLServerCentral Article

Application down after SQL Service logon account change

I was working on one of my clients server recently. This was during a normal maintenance monthly activity to reboot the database server every first weekend. I rebooted the machine, and as per the defined steps, I checked the SQL services after the reboot to ensure they were up. I verified all SQL Services and […]

5 (5)

You rated this post out of 5. Change rating

2020-10-05

4,502 reads

SQLServerCentral Article

SQL Server 2017 Installation Error with KB2919355

Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]

5 (1)

You rated this post out of 5. Change rating

2020-09-14

8,088 reads

SQLServerCentral Article

Using Recommendations for MAXDOP and Max Memory During Installation

Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]

4 (4)

You rated this post out of 5. Change rating

2020-09-01

10,198 reads

Blogs

Moving to Rancher Desktop

By

I’ve been very happy with Docker Desktop for years, running it on both laptop...

Logging in Azure Data Factory data flows

By

(2025-June-15) Long gone are the days when a data engineer could simply focus on building...

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Read the latest Blogs

Forums

What is Between?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is Between?

skipping the second line in a spreadsheet being read by ssis

By stan

hi, my new user provided a new multi tab (sales, customer etc. not what...

disable remote access

By goodtimecharlie

If I configure remote access to 0 on my servers, am I right in...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers