Featured Article(s) Microsoft Access or SQL Server? The major consideration when trying to decide what database system to choose from for an application development, is the size of the database – the quantity of data expected, and it depends on the vision of the developer. Open question in the forums… Jason is asking about auditing SSIS packages – and trying […]

New Weekly Show Posted [Watch] SelectViews #126 – We had some more amazing people in the office this week and we have some great interviews. Watch the interviews with Chris Shaw, Daniel Galant, Rachel Appel and Rebecca Isserman – great information sharing! Also Available: [Watch] Adam Levithan, Vishal Shukla, Sarah Barela and Shannon Callaway. From SharePoint to cloud computing lessons […]

Featured Article(s) MySQL Basic SQL Part VI — Hierarchical Queries It doesn’t matter if you call them hierarchical structures, tree structures, or self-referencing tables, the tables we will be dealing with in this article often pose quite the SQL challenge to traverse. Come JOIN along. Do You Have Your Reservation Yet? Have a question? SQL Server, Business Intelligence, .NET Development, […]

Do You Have Your Reservation Yet? Have a question? SQL Server, Business Intelligence, .NET Development, SharePoint. All the biggest name, most expert presenters. All to your desktop. Stop paying thousands for admission plus travel plus rooms, food and other things. This is a time to keep learning and stay on top of the technologies, stay focused and at the same […]

Featured Article(s) Records count for each table in a database Procedure that will display all the tables present in a database with its corresponding record count. Do You Know SQL Server, SharePoint, .NET Development, Business Intelligence? If so, I’d love to work with you – we’re actively looking for even more to write about their experiences with these technologies, or […]

Featured Article(s) How to Use the SharePoint PeopleEditor Control: Saving Data The PeopleEditor control is a common control that you’ll find implemented throughout SharePoint. If you’re building any custom web parts or application pages, you may want users to enter people specific information. The PeopleEditor is a good choice, however, there isn’t much out there in terms of documenting its […]

Follow me on Twitter – http://www.twitter.com/swynk Featured Article(s) Disaster recovery plans Oracle 10g Physical Standby — Part 1 Disaster recovery plans Oracle 10g Physical Standby — Part 1 MySQL Basic SQL Part V – Counting with SQL Many counting problems I see in answering reporting questions centers around the ability to sum, count, group, and select rows. Most SQL practitioners […]

Featured Article(s) MySQL Basic SQL Part V – Counting with SQL Many counting problems I see in answering reporting questions centers around the ability to sum, count, group, and select rows. Most SQL practitioners can count or sum values just fine but when they must answer questions on how the counting or summing relates to other information they don’t quite […]

Featured Article(s) Tips for designing SQL Server 2005 tables (Part 2) Here you can find some useful tips to design SQL Server 2005 tables. Big News from Microsoft on SQL Server Data Services… Microsoft’s SQL Server team today started talking publicly about concrete directions for the cloud-based services that will be offered for SQL Server solutions. Essentially, the net-net of […]

Featured Article(s) Your Next Interview With the economy the way that it is today, I can understand why there are so many articles that are appearing with what to do and what not to do at an interview. Some of these suggestions are just ridiculous. I have hired a number of DBAs and I thought I would add my two […]