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
739 reads
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
311 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
548 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,623 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
548 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
656 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,571 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
774 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
411 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
505 reads
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers