Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 3) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. Tweaking for High Transaction Loads When it comes to updating your storage subsystem for use with a high transaction load type implementation, you know that getting information can get pretty confusing. I know […]

Featured Article(s) Preparing to Install Failover Clusters Before you set up failover clustering it is important to verify whether you have the minimum hardware and software checks in place. In this article we shall examine what "minimum hardware and software" requirement means. In-Person, Outstanding Training Options Looking to get up to speed with in-person, instructor-led activities that will make sure […]

Have You See The Latest *2* SQL Server Shows? From SSWUG.ORG, these are currently available: – SelectViews – the weekly show about the database world – SQLonCall – Tips, tricks, lessons learned in the field, from www.sqloncall.com Featured Article(s) Granting Privileges Quickly on SQL Server (For the Oracle or SQL Server DBA) Oracle DBA’s moving to SQL Server find it […]

Latest Weekly SQL Server Show is Live SelectViews: Mixed database environments and their impact on DBAs, upcoming events, tips and tricks for SQL Server. We’ll also be looking at how to set up a TSQL statement as a job and our 60-second SQL Server Tip of the Day… > Watch the show here Featured Article(s) Review: xSQL Software’s xSQL Object […]

Watch The Latest SQL Server Weekly Show Here Last chance to catch last week’s show before the new show posts tomorrow. > Watch Here Featured Article(s) Stopping your Jobs on a Schedule Do you ever need to make sure a job does not run in the next production day? If your code can be sectioned off to do smaller pieces, […]

SQLonCall: The Show About SQL Server Reality Black box software – Chris Shaw goes through specifics of working with vendors, selecting solid tools and more. Find out the key things you need to ask, how to get the most from your vendors and how to make your acquisition a success. > Watch the show here Pulling Information From Non-Relational Sources… […]

Featured Article(s) Understanding the SDLC Phases of a Software Project [Part III] This is the concluding part of this series that discusses the remaining SDLC phases and sums up what we have learnt so far in this series of articles on the standard SDLC phases in the life cycle of a Software Project. Watch Now: Using SQL Agent to Automate […]

Don’t Miss the Weekly SQL Server Show… Released on Fridays, available now. Watch it here. Featured Article(s) Importing a .csv File into SQLExpress Using Bulk Insert Have you wondered how to import text file data into SQLExpress without using DTS or SSIS? This article will show you a possible approach using the T-SQL Bulk Insert Command. Report Distribution Options Get […]

New Weekly SQL Server Show Posted SelectViews: Legacy application upgrade choices, T-SQL JOINs, upcoming events and more. Also looking at privacy expectations and business intelligence – a problematic match? This is show number 79, and you can also find out how to win $200 in the drawing, information about current SQL Server versions and service packs and all sorts of […]

Catch the Latest Weekly SQL Server Show Here Watch SelectViews, posted Friday, with another episode posting tomorrow. Watch here. Featured Article(s) Standard Operating Procedure I alluded to SOPs or Standard Operating Procedures in an article earlier and Sean Maloney was kind enough to mention that this is really something that I could expand on. In short, anyone could pick up […]