Articles

SQLServerCentral Article

Monitoring and Recording DDL changes on SQL 2005 (NARC)

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.

(21)

You rated this post out of 5. Change rating

2008-02-29

7,502 reads

SQLServerCentral Article

Practical Methods: Naming Conventions

Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.

(13)

You rated this post out of 5. Change rating

2008-02-29 (first published: )

15,124 reads

SQLServerCentral Article

Using Parameters with Stored Procedures

It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.

(28)

You rated this post out of 5. Change rating

2008-02-29 (first published: )

119,715 reads

SQLServerCentral Article

My Projects Have Never Failed

As a SQL Server DBA or developer, how do you measure the success of your projects? What about your users? Here is an interesting look by Janet Wong at a few of her projects and how their success was perceived. See if any of your experiences are similar.

(16)

You rated this post out of 5. Change rating

2008-02-28 (first published: )

8,372 reads

Blogs

Think Twice Before Enabling Fabric’s Inbound Network Protection

By

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By

Most apps that call an LLM send every request to the same model. That...

Advice I Like: Responsibility

By

“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...

Read the latest Blogs

Forums

ALAMAT KANTOR BCA KCP Pondok Gede Telp:083831618008

By Layanan BCA_24jam

WhatsApp:0838-3161-8008 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota Jakarta Timur,...

AI Observability Challenges in FinOps as a DBA

By dbakevlar

Comments posted to this topic are about the item AI Observability Challenges in FinOps...

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers