SQL Canada (SQLCAN)

This is a continuation of the post from last week. Where I discovered by accident smart guides. Next thing I discovered was Syntax Highlight. Again

Power BI Smart Guides for Aligning Objects

It seems all I am teaching for last year is PowerBI. In my on journey to learn PowerBI development, one of the biggest things I

Many times the administrators ask about the transaction log size limit and how to shrink it. Even the log records are not managed properly and

If you are an SQL admin or user, you must be familiar with the term” fragmentation.” In every SQL Server, indexes get fragmented as the

“Recently, my system has encountered a severe breakdown. I lost most of my files and applications attached to it. Luckily, the MDF file of the

Query 1: “Hello friends, I am writing for the first time hoping that some of the learned friends can help me sort out the problem.