Featured Article(s) Useful Undocumented SQL Server 2008 Database Engine Stored Procedures In this article, Alexander Chigrik looks at ten undocumented SQL Server database engine stored procedures that shipped with SQL Server 2008. Feedback on Database Design Experiences I posted several questions yesterday asking about your experiences designing databases for lots of volume. Some great responses, ironically some of them are […]

Will You Be Joining Us at the Virtual Conference? Time is getting short to register. Design Questions – What Has Been Your Experience? After our workshop last week, I had a reader/attendee write in and ask some great questions that I know others have asked about as well. I thought I would toss these out there for you all to […]

DBASchool – 3 Days of In-Person Training Stephen Wynkoop (SSWUG.ORG Founder/Editor!) will be presenting an exclusive three-day course on what you need to know about SQL Server for your every day support of your systems. The class has very limited seats available and will focus on real-world instruction, discussion about how it applies specifically to your systems and focus on […]

Data Cleansing with SSIS – Brian Knight In this session, Brian Knight will show how to cleanse your data and apply business rules to your data in SSIS. Learn how to solve complex data problems quickly in SSIS using simple techniques in the data flow. Brian will start by showing you an easy package to bring you up to speed […]

Last Day to Register for Workshop Tomorrow – Learn More or Register: Virtual Workshop: SQL Server Performance (Mar 12!)– key concepts, learning and how-to information for working with SQL Server SelectViews Video Program Talking to experts – the show today features Kevin Kline, talking about his experiences in field. Also, Adam Jorgensen is on the show today talking about his […]

Time is Running Out to Register for Friday’s Workshop – Learn More or Register: Virtual Workshop: SQL Server Performance (Mar 12!)– key concepts, learning and how-to information for working with SQL Server SelectViews Video Program Talking to experts – the show today features Kevin Kline, talking about his experiences in field. Also, Adam Jorgensen is on the show today talking […]

Featured Script dba3_DynamicSql_Demo see link(http://bitonthewire.wpengine.com/forum/ShowPost.aspx?PostID=3256)… (read more) Fighting with Data Sources… Have you tried working with data sources, pulling information from Excel or CSV files, then making it available to other applications for analysis? It can be very … challenging. This can be a great place to use DataDefractor – it’s a visual data mapping and processing tool that will […]

Featured Article(s) Top 10 Agile Database Development Practices Many organizations like the idea of rapid application development without a long waterfall Software Development Life Cycle (SDLC). They recognize the effort to generate a complete "to be document", such as a database Entity Relationship Diagram meeting all system requirements, to be an exercise in futility. Rather than swinging to an opposite […]

Learning SQL Server, SharePoint, Business Intelligence… – Learn More or Register: Virtual Workshop: SQL Server Performance (Mar 12!)– key concepts, learning and how-to information for working with SQL Server – Register: Spring 2010 SSWUG.ORG Virtual Conference (Apr 7, 8, 9) – SQL Server, Business Intelligence, SharePoint – 75 sessions, 20 speakers… – Register: DBA School – (60% sold-out already) 15 […]

Learning SQL Server, SharePoint, Business Intelligence… – Learn More or Register: Virtual Workshop: SQL Server Performance – key concepts, learning and how-to information for working with SQL Server – Register: Spring 2010 SSWUG.ORG Virtual Conference – SQL Server, Business Intelligence, SharePoint – 75 sessions, 20 speakers… – Register: DBA School – (60% sold-out already) 15 ppl max – Apr 19, […]