SQLServerCentral.com - Featured Site!!
It's not often that we toot our horn, but SQLServerCentral.com was chosen as the feature site by GotDotNet.com, one of Microsoft's premier .Net sites. Check it out!
Making Good Use of Sysforeignkeys Table - Part 1: Display table relati
Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.
Reminiscing
Steve Jones has been working with SQL Server for 10 years. Join him for a stroll down memory lane.
SQL Server 2005 Beta 2 Gets Close
Microsoft began taking sign ups for participation in the SQL Server 2005 Beta 2 program this week at its Microsoft TechEd show here as the long-awaited test version of the product gets close to availability.
Database Tools for SQL Database Editing Released
Apex SQL Tools has released Apex SQL Edit 3.0, database Tools for database editing. Apex SQL Edit is an integrated development environment (IDE) for SQL Server including powerful editing capabilities, deployment capabilities, full integration with Visual Source safe as well as SQL Server Reporting services and much more.
Microsoft to Step Up Server Product Release Schedule
Microsoft Corp. is planning to deliver updates to its Exchange Server product every two years and is considering a similar move to deliver SQL Server updates in a more timely manner, company officials said at the TechEd 2004 conference.
Change Management in Your Database
SQL Server has no change management integrated with the native tools. This means that each person must develop their own method of handling changes, or live with the chaos that will inevitably ensue. There are a number of articles written about various ways to handle change management and Dinesh Asanka shares his here. Read on and see if this helps you get a handle on changes in your environment.
Replication Gotcha - Columns with Defaults
Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.
Every DBA Should Know Which Databases are be Backed Up
Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.
Don't Get Left Behind
Production DBAs may be a dying breed. At least according to some sources. While we're not sure that we agree with that, there is definitely a trend that should have you working on your career. The day of the DBA that only manages the operational data store is waning. Today's DBAs need to be flexible and have a number of other skills. Brian Knight looks at a few of the skills that you might to add to your arsenal to be prepared for the future of SQL Server.
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers