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 […]

Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. I Can Hear the Users Now: "We Want (More) Reports!" Egad. Building reports and writing the applications to produce them, get them to the users and let them tweak them with parameters and […]