Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
One of my Code Project article on SQL Trigger has...
2019-01-09
239 reads
Vivek Johari
- Interests: SQL, database, Oracle, Big Data, Azure
Point In Time Restore for Azure SQL Database
Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...
2019-01-08
148 reads
Merry Christmas
Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!
From Technology with Vivek Johari
2018-12-24
150 reads
SQL Triggers – An Introduction
This article will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work....
2018-12-08
242 reads
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool
In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In...
2018-11-25
337 reads
2018-11-19
4 reads
Know How to Import SQL Server database From One to Another
Looking to import SQL Server database from one server to another ? Confused how to copy from one to another or...
2018-10-05
546 reads
Blog trasfering to new hosting server
Hi Friends,
This blog is now transferring to different hosting server. So you may got some issue in accessing it. Sorry...
2018-04-10
255 reads
SQL Script to find the database & their files details on a SQL Server
Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server...
2018-03-30
3,672 reads
SQL Script: - How to find the database restoring history of SQL Server databases
Sometime we need to find out the history of database restoration to get the answers of following questions: -
1) Do...
2018-03-30
5,714 reads
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
How to find index usage by stored procedure?
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
Odd things with Report Builder (also tried VS 2019)
This is kinda hard to explain, maybe I can make sense of it. So...
PBM policy to check empty passwords
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...
Ask SSC