SSAS – Automatic Inventory Generation – 24 Columns – HTML Attachment
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2013-06-18
1,068 reads
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2013-06-18
1,068 reads
The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option....
2013-06-12
1,858 reads
There are different ways to take Cube database backups.
SQL Agent JobXMLA script for backupROBOT jobASCMD commandSSIS PackageSSIS packageAMO (Analysis Management...
2013-06-11 (first published: 2013-06-05)
2,716 reads
One of my friend requested me to give a mutli server script to pull SQL Service related details. Here is...
2013-06-10
1,728 reads
One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying...
2013-05-30
1,527 reads
This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...
2013-05-24
1,083 reads
There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and...
2013-05-20
1,849 reads
We came across a scenario where database bak files being created from long time which are no more in use...
2013-05-17 (first published: 2013-05-13)
2,426 reads
One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...
2013-05-16
608 reads
We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...
2013-05-15
10,821 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers