SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...
2014-04-14
745 reads
PowerSQL By Prashanth Jayaram
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
554 reads
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
317 reads
PowerShell GUI Tool – Network Ping – Version 2
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
1,628 reads
PowerShell GUI Tool – Network Ping – Version 2
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
552 reads
PowerShell – System Information
Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...
2014-03-17
1,575 reads
PowerShell – System Information
Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...
2014-03-17
662 reads
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...
2014-03-11
782 reads
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...
2014-03-11
414 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
780 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers