Skip to content
Performance Tuning And Infra Automation

I love performance tuning and building automation

  • Home
  • About Me
  • All Articles
  • Contact Me
  • Home
  • Pretty Links
  • Privacy Policy
  • SQL Resources
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe

tsql-functions

  • Home
  • tsql-functions
Heavy-SqlServer-Workload-against-StackOverflow-database
Posted inBaseline-SQL-Server TSQL

Time conversion from local to UTC and vice-versa

Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at SQL Server…
Posted by Ajay Dwivedi September 6, 2020
How to Verify Given Access/Permissions to User/Login
Posted inDatabase Administration

How to Verify Given Access/Permissions to User/Login

Hi Friends, I have seen DBAs to wait for user's confirmation for long after providing access/permissions. This is not required since we have very easy way to verify user permissions.…
Posted by Ajay Dwivedi November 8, 2017
Cast on variable Scale
Posted inTSQL

Get Decimal Scale Based on Variable Value

In recent past, while designing a report mailer I faced a requirement where I had to convert a float column into DECIMAL with dynamic precision value coming from outside of…
Posted by Ajay Dwivedi October 9, 2016
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 99 other subscribers
See what other community members think about SQLMonitor.
Recent Posts
  • Get StackOverflow2013 Database for PostgreSQL & SQLServer
  • Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
  • LogRotate Policy For PostgreSQL
  • Run Ansible Playbooks with Github Action
  • SQLServer Gradually Becomes Slow Until Reboot
Facebook With Ajay Dwivedi
Facebook With Ajay Dwivedi

CATEGORIES

  • Ansible 1
  • Baseline-SQL-Server 22
  • Database Administration 11
  • DevOps 1
  • Errors 15
  • Execution Plan 8
  • Growth & Development 2
  • Health Check 8
  • Internals 3
  • Linux 4
  • Performance Tuning 35
  • PostgreSQL 3
  • Powershell 8
  • SQL Alerts 5
  • SQLMonitor 17
  • TSQL 41
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloghash WordPress Theme
Scroll to Top