Find All Databases with Less Than 20 Percent Free Space and Grow Them

Here is my final code: /* Finds all db files with less than 20% free space and create statements to grow to an appropriate size. */ SET NOCOUNT ON DECLARE @dbname NVARCHAR(200) DECLARE @SQLStr NVARCHAR(4000) DECLARE @filetype VARCHAR(10) DECLARE @filesizeMB INT DECLARE @logicalname NVARCHAR(200) DECLARE @queryonly BIT SET @filetype = ‘DATA’ — Use DATA for […]

Read More

Long running MS SQL QUERIES

B. Obtain information about the top five queries by average CPU time The following example returns the text of the SQL statement and average CPU time for the top five queries. SQLCopy C. Provide batch-execution statistics The following example returns the text of SQL queries that are being executed in batches and provides statistical information […]

Read More

SOFTWARE ENGINEERING SENIORITY LEVELS

SOFTWARE ENGINEERING SENIORITY LEVELS All software engineers are the same, right? Well, not exactly. There is a strata of different seniority levels, each with its own expectations for experience, responsibilities, and pay. This article is a concise collection of my observations on seniority levels for software engineers. The levels Every company is different, but I’ve seen […]

Read More

How to Turn A DevOps Pipeline Into a DevSecOps Pipeline: A Shift Left Concept Overview | HackerNoon

How to Turn A DevOps Pipeline Into a DevSecOps Pipeline: A Shift Left Concept Overview September 9th 2023 12min by @goal23  6,190 reads EN VI ES HI ZH FR PT JA CLOUD#devops#devsecops#devops-tools#shift-left#ci-cd-pipelines#software-development#devops-security 1x Read by Dr. One (en-US) Audio Presented by @goal23 Sofia Konobievska Ukrainian DevOps expert with great experience. Worked in … Receive Stories from @goal23SUBSCRIBE Hi, […]

Read More

BOK – Bank of Khartoum

Introduction URL: bok.itserver.bizTech Stack: CodeIgniter, PHP, SQL ServerType: Banking application BOK is an account registration application for Bank of Khartoum, it allows users to sign up, and agents to view and approve/reject their applications. After an application is approved, it is synced to the “staging server”. Signup Form The signup form has ten steps. All […]

Read More

universallab.cartzlink.com

Step   Start Date Days EST Dt Actual Dt Remarks Customers Step 1 Payment   1      Complete   Step 2 KYC   7      Done   Step 3 Basic Setup   3      Done    Step 4 Your Data   3      Done    Step 5 Training   28   […]

Read More