Skip to main content

Posts

Featured

Empower Consistency: Enforce Pascal Case Naming Convention with T-SQL Policy

Introduction: In the realm of database design, consistency is the cornerstone of a well-organized and scalable database. One crucial aspect of consistency is adhering to a uniform naming convention. Pascal case, a popular naming convention, offers numerous benefits, and enforcing it with a T-SQL policy ensures a robust and maintainable database. In this post, we'll delve into the reasons behind Pascal case, its advantages, and provide a clear and powerful prompt to create a policy that ensures all object names are Pascal case upon creation. The Case for Pascal Case: Pascal case naming convention is a widely accepted standard in programming and database design. It's characterized by the first letter of each word being capitalized, including the first word. This convention makes code and database object names more readable and easier to understand. For example, "GetCustomerDetails" is more readable than "getCustomerDetails" or "getcustomerdetails". B

Latest Posts

The Role of Information Systems in Knowledge Management

Slowly Changing Dimension Type II: My Simple Personal Alternative To Merge

Twenty Signs Your SSAS Implementation Will Fail Even If You Did Hire The Right SSAS Consultant

Compare Data from Two Tables

How Can I Find How Much Space Each Table Uses In Powerpivot

Handling Slowly Changing Dimension Type II in PowerPivot

Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration

OLEDB vs ADO.Net error in SSAS Tabular Models

SQL Server: Attach MDF without LDF

Microsoft SQL Server Reporting Services - The value of the Top property for the text box "Textbox1" is negative. Negative sizes are not allowed