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,083 reads
PowerSQL By Prashanth Jayaram
SQLCMD – Explicit and Implicit calls – Examples
The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option....
2013-06-12
1,874 reads
PowerShell – Identify Service Account & Other Details of SQL Services – Multi Server Script
One of my friend requested me to give a mutli server script to pull SQL Service related details. Here is...
2013-06-10
1,741 reads
SSAS Cube Backup strategies and Step by Step approach to setup and configure backup
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,936 reads
SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances
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,538 reads
SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup
This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...
2013-05-24
1,095 reads
SQL – SQL Server Script to Iterate through All SQL Instances – Example Transaction Log Shrinking
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,863 reads
Bill Gate’s speech
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
613 reads
SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server
We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...
2013-05-15
10,870 reads
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers
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,444 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers