Mohit Gupta (@SQLCAN) profile picture

Mohit Gupta

@SQLCAN

Microsoft Data, Analytics & AI PFE @ Microsoft Canada. Blogging @ https://nitter.cf/t.co/imPPUSJXeI

 Canada
sqlcan.com
Joined September 2011
  • Tweets277
  • Following137
  • Followers123
7Media
Photo by Mohit Gupta (@SQLCAN)Photo by Mohit Gupta (@SQLCAN)Photo by Mohit Gupta (@SQLCAN)Photo by Mohit Gupta (@SQLCAN)Photo by Mohit Gupta (@SQLCAN)Photo by Mohit Gupta (@SQLCAN)Photo by Mohit Gupta (@SQLCAN)
Who has access to your SQL Server infrastructure? sqlcan.com/2022/12/21/sqlops…
SQLOpsDB Reports: Security Lookup

SQLOpsDB Reports: Security Lookup

Ever had a person leave the organization or your team and wanting to know where do they have access? What explicit permissions, logins, or database users you have to clean up? If are like many orga…

sqlcan.com
1
31
SQLOpsDB Reports: Application sqlcan.com/2022/12/20/sqlops…
9
SQLOpsDB Reports: Dashboard – Drill Through sqlcan.com/2022/12/19/sqlops…
SQLOpsDB Reports: Dashboard – Drill Through

SQLOpsDB Reports: Dashboard – Drill Through

As stated in previous reports, all the dashboard elements offer drill through. To investigate the additional details behind the summary data. The summary layout is saved in Snapshot.* tables and ar…

sqlcan.com
1
27
SQL Health, Configuration Health, and Disk Capacity Planning. Single Stop! sqlcan.com/2022/12/16/sqlops…
SQLOpsDB Reports: Dashboard

SQLOpsDB Reports: Dashboard

SQLOpsDB Dashboard is primary report where all investigation starts for data collection. The database dataset is generated at the end of execution of the SQLOpsDB_DataCollection.ps1 PowerShell scri…

sqlcan.com
6
SQLOpsDB PowerShell Module sqlcan.com/2022/12/15/sqlops…
SQLOpsDB PowerShell Module

SQLOpsDB PowerShell Module

The PowerShell model is the primary code for collecting and updating the information. The command-lets in this module are broken into three categories. I have tried to follow modular development st…

sqlcan.com
6
Windows Task Scheduler for SQLOpsDB sqlcan.com/2022/12/14/window…

Windows Task Scheduler for SQLOpsDB

The Windows Task Scheduler executes the PowerShell script for data collection for both SQLOpsDB data collection and configuration health. These collections can be completed via the SQL Agent jobs a…

sqlcan.com
SQLOpsDB Reports sqlcan.com/2022/12/13/sqlops…

SQLOpsDB Reports

All the report files are accessible directly or indirectly from the primary report “SQLOpDB Dashboard.” I would recommend after deployment to hide all the reports and folders not needed…

sqlcan.com
SQL Server Policies for SQLOpsDB sqlcan.com/2022/12/12/sql-se…

SQL Server Policies for SQLOpsDB

The SQL Server policies are part of collection from Microsoft default best practice policies plus additional policies I have written over the year. The policies typical follow the naming convention…

sqlcan.com
Central Management Server (CMS) for SQLOpsDB sqlcan.com/2022/12/09/centra…

Central Management Server (CMS) for SQLOpsDB

The CMS is the driver of all the data collection needs. When registering a server in CMS, follow these best practices. Register only the replicas, stand-alone, or failover cluster instances. That i…

sqlcan.com
SQLOpsDB Requirements sqlcan.com/2022/12/08/sqlopd…
SQLOpsDB Requirements

SQLOpsDB Requirements

As stated in SQLOpDB Architecture, there are three components to configure, collect data, and do reporting. The requirements are briefly discussed on the GitHub page. A single virtual or a physical…

sqlcan.com
SQLOpsDB Architecture sqlcan.com/2022/12/07/sqlops…

SQLOpsDB Architecture

Over the years I have tried to minimize number of moving parts in the architecture. The overall architecture can be broken down into three primary components. SQL Server Instance Central Management…

sqlcan.com
Deploying SQL Server Operational Dashboard sqlcan.com/2022/12/06/deploy…

Deploying SQL Server Operational Dashboard

I have tried to automate parts of the deployment. When deploying the current version, there is no way to upgrade from an existing deployment.  In later posts I will talk about how you can use Micro…

sqlcan.com
1
One spot to see the over on all health of the SQL Server infrastructure. Make this part of morning DBA Top 5 tasks. Don't guess the database sizes & disk space. An application cost on SQL Infrastructure. Or who has access to the entire infrastructure. sqlcan.com/2022/12/05/sql-se…

SQL Server Opertional Dasbhoard

I am releasing a solution that I have worked on for on-and-off for many years for many different customers. The solution is combination of the feedback and the requirements collected over many year…

sqlcan.com
While studying my I asked my daughter what is Stanley Cup. She said hockey teams win it. I asked all of them? She said #Oilers win it. I said nope, not recently. So her reply, well they need to win it next time! So how about it #Oilers?
DBAs Stop Restoring Databases Manually! sqlcan.com/2021/10/20/dbas-s…

DBAs Stop Restoring Databases Manually!

DBAs stop restoring database manually, automate it!

sqlcan.com
1
#AHS Vaccine proof website had 118K+ people in queue today. I waited for 3H+ and now I get this error. Wait starts again? :(.
Image from Mohit Gupta (@SQLCAN)
1
1
2
It let me retry again and again for 10-minutes to same login failure. Now I am in queue of 118K+ again yeeh!
2
So another 2H wait again both wife login and my login both errored out. Did the #AHS Vaccine proof work for anyone today?
Ransomware Awareness for SQL Server sqlcan.com/2021/06/28/ransom…
Ransomware Awareness for SQL Server

Ransomware Awareness for SQL Server

As I am seeing Ransomware attacks increase around the globe, I have been engaged with multiple customers whose SQL Server infrastructure has been infected.  I do not know the variant these cus…

sqlcan.com
1
#SQLServer Smart Index Management (SQLSIM) V2.06.01 Released! sqlcan.com/2020/12/18/smart-…
Smart index management (SQLSIM) V2.06.01 Released!

Smart index management (SQLSIM) V2.06.01 Released!

Another approach to Index Management in #SQLServer. Learn & Manage Indexes based on Learning!

sqlcan.com
Load more