Tomorrow: Kim Tripp and Paul Randal interview from DevConnections. Featured Article(s) Oracle 2-Day DBA in x Days Post 1 We just got started. Follow along as we go through Oracles 2-DBA guide. It should be fun. Cure For The Mysterious SQL Server Slow-Down As a DBA have you ever received that call from the boss asking why the database is […]

Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 2) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems. Virtual Server Protection and Recovery Building out your infrastructure with virtual servers brings with it the requirement that you be […]

Featured Article(s) Understanding Software Testing (Part III) This is the last and concluding part in this series of three part articles on Software Testing. In this part we will discuss few other types of testing methodologies. Webcast Today Performance Monitoring, Scaling and Watching Over Your SQL Server. We’ll look into pulling baseline information, things you can do to chart and […]

Latest Shows to Watch Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision. Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day Watch: SQLonCall: How to Hire a DBA – Part 2/3 – How to review resumes, what to look for, […]

Featured Article(s) One of the common problems, mostly misunderstood! (Vadivel Mohanakrishnan) This article explains the power of ‘EXECUTE’ keyword in SQL Server. I would explain a common issue which to my knowledge is mostly misunderstood by most of the folks (At least whom i have met so far :)). The target audience for this article are: Basic to Intermediate level […]

Featured Article(s) Easy SQL Server Database Monitoring for the Oracle (and SQL Server) DBA – Part 2 This article is the second in this series. It describes how to develop your own SQL Server polling and monitoring system. This article presents the repository ERD and the polling mechanism allowing you to easily retrieve instance, database, and failed jobs into the […]

Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 1) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems. Don’t Throw Away Your Reporting Services Masterpieces… Once you’re done creating the reports your users need, you know you’re almost […]

Featured Article(s) Understanding Software Testing (Part II) This is the second part in the series of three part articles on Software Testing. In this part we will explore the common types of software testing. Software Testing can be classified into several types based on treating the subject from various angles. Let us look into some common classifications for Software Testing. […]

Featured Article(s) Find all tables and schemas without a primary key constraint The following procedure generates a list of all tables in all schemas and in all server’s user databases that a PK constraint is NOT defined on them. Read: Integration Studio Review Friday we published a review of Relational Solutions BlueSky Integration Studio – if you’re building SSIS projects, […]

New SelectViews Show Posted Watch: SelectViews: Special On the Road Edition – Images in the Database, Push vs. Pull Replication and More. Previously… Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision. Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day […]