SQLServer

Technical Article

Import Multiple Packages to SSIS server

  • Script

We cannot import multiple packages on the SSIS server. So, loading 100 packageS from  file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]

You rated this post out of 5. Change rating

2021-09-27 (first published: )

1,608 reads

SQLServerCentral Article

Fixing "Login failed for user" error in SQL Server

  • Article

In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]

You rated this post out of 5. Change rating

2020-11-24

45,173 reads

SQLServerCentral Article

Block user objects from being created in a master database

  • Article

Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]

5 (7)

You rated this post out of 5. Change rating

2020-11-10

3,979 reads

Blogs

When It’s Still Viable

By

If a technology is still viable, don’t overlook it. Don’t get caught up chasing...

T-SQL Tuesday #179: The Detective’s Toolkit

By

It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

Read the latest Blogs

Forums

What are the dimensions of a 55-inch TV?

By getassistnet

55 inches represent the diagonal length of the TV screen. The dimensions are important...

Starting to Estimate Disk Storage for Memory-Optimized Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting to Estimate Disk Storage...

Keep. It. Simple.

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Keep. It. Simple.

Visit the forum

Question of the Day

Starting to Estimate Disk Storage for Memory-Optimized Tables

If I have durable memory-optimized tables, what is the starting point for estimating storage space?

See possible answers