Compare Patch levels across all installed sql instances
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
339 reads
Scripts
Import Multiple Packages to SSIS server
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 […]
2021-09-27 (first published: 2021-09-22)
324 reads
Excel Formula to create SQL Script for a Values Table
Here is an Excel formula that generates a SQL script from an Excel table
2021-07-30 (first published: 2021-07-26)
999 reads
Index fragmentation on all databases
The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.
2021-07-12 (first published: 2021-07-06)
937 reads
PowerShell script to create SQL Server alias name
This script is useful for your environment having multiple always-on with replication setup and your listener value is persisted with RegisterallIP set to 1. When initiating the always-on failover, It will create/update the alias in the distributor server by pointing to the new primary server without RDP to each distributor server and that makes the […]
2021-07-07 (first published: 2021-06-28)
478 reads
Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2021-06-21 (first published: 2021-06-11)
3,570 reads
How to shrink tempdb database in SQL Server
This article discusses different methods that you can use to shrink the tempdb database in Microsoft SQL Server. Before you shrink the tempdb database using the methods described in this article, note the following: The tempdb size is reset to the final configured size (i.e. to the default size or the final size that was […]
2021-06-09
611 reads
Space allocated to the databases by disk letters
Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently. Note. This won't show correct information on Linux instances and if you use mounting points in Windows.
2021-04-23 (first published: 2021-04-19)
583 reads
A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2021-03-11 (first published: 2021-03-05)
1,020 reads
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
953 reads
Blogs
Daily Coping 3 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
How To Start And Run A Great Home Business
By Kapil Singh
With the current state of the economy, many people are seeking out opportunity in...
Proven Strategies For Your Home Business
By Kapil Singh
A home business is a popular choice for many people. But it can also...
Forums
how to identify BottleNeck by using the data of sys.dm_os_performance_counters
There are many many data to show the SQL Server current performance, May I...
SQL Query Help on Time based query
I have a following table (Contains script to generate the sample table with data):...
When to Use a Database
Comments posted to this topic are about the item When to Use a Database
Ask SSC