Kenneth Igiri
  • Sign In
  • Create Account

  • My Account
  • Signed in as:

  • filler@godaddy.com


  • My Account
  • Sign out

  • Home
  • Blog
  • iis
  • Learn
  • About
  • Contact
  • More
    • Home
    • Blog
    • iis
    • Learn
    • About
    • Contact
Kenneth Igiri

Signed in as:

filler@godaddy.com

  • Home
  • Blog
  • iis
  • Learn
  • About
  • Contact

Account


  • My Account
  • Sign out


  • Sign In
  • My Account

Free MS SQL Server Training

An Introduction to MS SQL Server Part I

We had this session with a few friends and it turned out to be quite a deep introduction to the basics of SQL Server. 


I worked with Microsoft SQL Server hands-on for about 11 years up till June 2019. Before then I was well versed in Service Management (ITIL) and Application Support. I have  written articles for SQL Server Central, MS SQL Tips and CodingSight. 

An Introduction to MS SQL Server Part II

We had this session with a few friends and it turned out to be quite a deep introduction to the basics of SQL Server.  


I worked with Microsoft SQL Server hands-on for about 11 years up till June 2019. Before then I was well versed in Service Management (ITIL) and Application Support. I have  written articles for SQL Server Central, MS SQL Tips and CodingSight. 

MS SQL Server Databases & Storage Part I

In this session we examined the basics of SQL Server Databases - logical and physical structures, files and filegroups, and ways to move databases. The video is broken down to four parts, do well to watch all of them.  

Basics of Troubleshooting Using 3 DMVs

 In this session we examine sys.dm_exec_connections,  sys.dm_exec_sessions and sys.dm_exec_requests. We explore the information they expose and use this information for performance troubleshooting. 

Microsoft SQL Server Articles

Microsoft SQL Server Logo

Creating Maintenance Plans in SQL Server

Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the databases that are hosted therein are kept in shape. 

Read this Article

Basics of Working with JSON in SQL Server

JSON is an acronym for JavaScript Object Notation, that became popular a little over seventeen years ago. JSON is essentially a data format, it was popularized by Douglas Crockford, a well-known programmer with an interesting history who was also involved in the development of JavaScript. 

Read this Article

Accelerated Database Recovery in SQL Server 2019

As with all relational database systems, SQL Server guarantees the durability of data by implementing crash recovery. Durability in the acronym ACID which refers to the characteristics of transactions in relational databases means that we can be assured that if the database fails suddenly, our data is safe. 

Read this Article

Using Alerts and Operators in SQL Server

With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still available. They are the key SQL Server Agent features that are related to anything in SQL Server automation.  

Read this Article

Deploying a SQL Server Docker Container

Containerization has become the dominant topic after the Server Virtualization and Cloud Computing Eras. While many thought leaders assert that current computing paradigms are not particularly new, containerization, as we have it today, can be viewed as having been born after cloud computing. Using containers on-premise allows us to perform migration to the cloud while building a containerized environment mimics the features of solutions deployed in the cloud. 

Read this Article

Five Useful SQL Server Management Practices

As organisations seek more cost efficient ways to manage their environments, the demand on IT to deliver and manage shops on a tighter budget is increasing. The typical IT person must think not just about what must be done but how it must be done not only with the least administrative effort but with the least financial cost. 

Read this Article

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Amazon AWS offers two main options for deploying SQL Server in the cloud: Elastic Compute Cloud and Relational Database Service. I recently did a few experiments with both types of instances and learnt a lot about what is and is not possible with the two options. It is worth noting that I have previously worked with MySQL on RDS and found it very satisfactory and very much like any other MySQL instance. For SQL Server, it does appear that there is some significant difference between deployments on EC2 and those on the RDS offering. 

Read this Article

Database Snapshot Use Case: Service Migration

In this article we highlight the benefits of Database Snapshots and a specific way in which the feature was of use to use in a recent service migration excercise. We shall highlight briefly the concept of Database Snapshots, general use cases and the simple process of creating and dropping a database snapshot. 

Read this Article

Copyright © 2023 Kenneth Igiri - All Rights Reserved.

Designed and Maintained by Kenneth Igiri

  • Home
  • Blog
  • Books
  • Tech
  • Testimonials
  • About
  • Contact
  • Downloads
  • Iwineti
  • Kabila
  • Privacy Policy
  • referrals

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data. Privacy Policy

DeclineAccept