Skip to content

Chad Franklin

Database Administrator Passionate About Automation, Performance and Security

  • Blog
  • About
  • Contact

Category: T-SQL

Development, T-SQL

How to Rename a Table Name or a Column Name

May 11, 2021 Chad Franklin

So, you want rename a table, or a column name? It's a simple command, but it's one of those commands I don't use often and therefore forget how to write it every time I need to use it. Maybe you're like me and can't remember how it should be written too. Keep reading... To do… Continue reading How to Rename a Table Name or a Column Name

Tagged Rename, sp_rename, SQL ServerLeave 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

  • Database Settings
  • Development
    • T-SQL
  • Maintenance
    • Backups
    • Restores
  • Me
  • Monitoring
  • Performance
  • Security
  • Server Configuration
  • SQL Server Management Studio
  • SSRS

Recent Posts

  • Restoring a Database With CDC Enabled
  • What Firewall Port does the DAC require
  • Enable the Dedicated Admin Connection (DAC) and How to Use it
  • How to Rename a Table Name or a Column Name
  • Partial Database Backups and Restores with Read-Only Filegroups

Popular Posts

  • How to Move TempDB to a different Drive or Folder
  • How to Silently Install SQL Server Management Studio
  • Quick Way to Check Which is the Active Node in a Failover Clustered Instance
  • Installing Multiple SSRS Instances on a Server is a Thing of the Past
  • Partial Database Backups and Restores with Read-Only Filegroups

Top Tags

Automation Backup DAC Database Maintenance Database Settings Install Login Moving Database Files Server Configuration SQL Server

Follow Us

  • LinkedIn
  • RSS Feed
Blog at WordPress.com.
  • Follow Following
    • Chad Franklin
    • Already have a WordPress.com account? Log in now.
    • Chad Franklin
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...