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.
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.
Quest Central For SQL Server (Freeware)
Quest Central® for SQL Server is an integrated database management solution designed to enable administrators to manage complex database environments and simplify everyday tasks. Quest Central for SQL Server provides DBAs with a set of tools to achieve higher levels of availability and reliability, leverage and extend native SQL Server administration capabilities, and adds multi-server and change management capabilities to make database management easier.
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers