SQL Server Central

SQLServerCentral Article

A Contest from APress

  • Article

Apress, one of the premier techincal publishers, is releasing quite a few titles based on SQL Server 2005. They've agreed to sponsor our Question of the Day and give away some books. Read how you can win and what they're offering.

You rated this post out of 5. Change rating

2006-05-01

2,447 reads

SQLServerCentral Article

SQL Server 2005 Logon Triggers

  • Article

One thing that many people tried to implement in SQL Server 2000 is the auditing of logins. However getting this to work was a complex process. In SQL Server 2005, however, there are a few ways you can handle this and new author Frederik Vandeputte brings us a method using Service Broker for handling this.

(14)

You rated this post out of 5. Change rating

2006-04-17

25,503 reads

SQLServerCentral Article

Help a Student

  • Article

One of our community is working on a thesis for his graduate degree on the effects of outsourcing on knowledge transfer among software engineers. He's got an anonymous survey setup, so if you have a few minutes, lend a helping hand.

You rated this post out of 5. Change rating

2006-03-28

2,652 reads

SQLServerCentral Article

SQL 2000 to SQL 2005: Where have all the old features gone?

  • Article

SQL Server 2005 is out and everyone is moving to test and deploy it. However many people are still managing SQL Server 2000 instances. New author Boris Baliner brings us a few tricks to find that information you are used to from Enterprise Manager.

(1)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

35,485 reads

Blogs

“We love to debate minutiae”

By

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

By

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

By

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

Windows logins for users migrated from DomainA to DomainB

By a.koopman

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

By Kunal Rathi

Comments posted to this topic are about the item How to Use sqlpackage to...

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?  

See possible answers