In Just Days: See YOU at the Virtual Conference 20 different speakers are pulling together their excellent content, approaches and ideas and presenting it to you! SQL Server tips, best practices, tools, tuning and much more. Business Intelligence tips, approaches and specific how-to information, SharePoint information on setting up and administering SharePoint systems – all of this and a ton […]

See YOU at the Virtual Conference 20 different speakers are pulling together their excellent content, approaches and ideas and presenting it to you! SQL Server tips, best practices, tools, tuning and much more. Business Intelligence tips, approaches and specific how-to information, SharePoint information on setting up and administering SharePoint systems – all of this and a ton of different, entirely […]

Time is Running for DBA School I’ll be teaching a 3-day class on SQL Server – from security to best practices to performance management and much more. 6 different segments over 3 days, complete with discussions about how best to apply these things specifically to your environment. I hope you’ll join us – click here for more information about the […]

DBASchool – Limited Seats Remain With only 15 total seats, we’re now down to only a few remaining for the April class. This is an in-person class that I’ll be teaching that focuses on the practical, immediately usable items you need to know when working with SQL Server. From security the planning to performance and best practices, we’ll be showing […]

Featured Script CheckErrorLog The script shows SQL Server’s error log without messages about differential and log backup. It is usfull if you want to chec… (read more) Database Design Feedback – a Different Perspective David wrote in with a different take and suggestion set on the database design questions. Agree? Disagree? Have different experiences/comments? Drop me a note here. "1) […]

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

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