Skip to content

Chad Franklin

Database Administrator Passionate About Automation, Performance and Security

  • Blog
  • About
  • Contact

Tag: Login

Trying to login as sa
Security

Renaming and disabling the sa login

November 9, 2020December 31, 2020 Chad Franklin

In theory, nobody should be using the sa login for anything. In reality however, I've seen many applications and processes configured to use it. Trying to change the way these applications and processes are setup, or convince people to change them, is a challenge to say the least... a challenge which I wont try to… Continue reading Renaming and disabling the sa login

Tagged Automation, Install, Login, sa, Security, SQL Server, sysadminLeave a comment
Development, T-SQL

Login Default Languages and the Effects of Getting it Wrong

November 1, 2020December 31, 2020 Chad Franklin

There have been countless times where I've seen dates in SQL Server being interpreted differently to what people have expected. Sometimes the date is interpreted in the format dd-mm-yyyy whereas other times the date format is interpreted in the mm-dd-yyyy format. This can greatly change the results of queries or change the date that was… Continue reading Login Default Languages and the Effects of Getting it Wrong

Tagged Dates, Login, Server Configuration, SQL ServerLeave a comment

Hi! I’m Chad. I love data, travelling and anything to do with sport. I live in Auckland, New Zealand with my family.
Feel free to reach out to me for any SQL Server DBA assistance or questions

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

Categories

  • Development
    • T-SQL
  • Maintenance
  • Me
  • Monitoring
  • Performance
  • Security
  • Server Configuration
  • SQL Server Management Studio
  • SSRS

Recent Posts

  • Quick Way to Check Which is the Active Node in a Failover Clustered Instance
  • Recovering a Database in Restoring State Leaves Broker Disabled
  • How to Silently Install SQL Server Management Studio
  • Performance Testing a New SQL Server
  • Configure Database Mail and Test it – All using T-SQL

Popular Posts

  • Installing Multiple SSRS Instances on a Server is a Thing of the Past

Top Tags

Automation Chad Database Maintenance Database Settings Install Introduction Login Moving Database Files Server Configuration SQL Server

Follow Us

  • LinkedIn
  • RSS Feed
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×