Dear Developers, DBA’s and Power Users, There is something that I’ve been seeing in your SQL that it annoys me so much that it’s forcing me to bring it to your attention. Developers, DBA’s and power users hear my plea. Table aliases are wonderful things. They make SQL easier to read and more compact. I’m(…)
Recently, I’ve been working on databases that I’ve never touched before. Of course, when dealing with a “new to you” database there some are challenges. What’s the schema of the database? What’s the “cleanliness” of the data? Is there any useful metadata? When I look at a database for the first time I want to(…)
A few months ago we started development on a new system. From the ground up we redesigned everything from our business processes to how we store data. Part of the redesign was deciding on using SOA technology in our middle tier. This will allow us to separate our UI from our middle tier even further.(…)
Microsoft is offering free SQL Server 2008 online courses. The offered titles are: What’s New in SQL Server 2008 for Enterprise Data Platform What’s New in SQL Server 2008 for Business Intelligence What’s New in SQL Server 2008 for Database Development We’ve been keeping our ear pretty close to the ground on SQL Server 2008(…)
I just did something that was bound to happen. I deleted data from a production database. But it wasn’t just any data; it was the user’s role information on our website. It wasn’t just some, a little, or most of the data; I deleted the whole freakin’ table. Good job. Yay me. I was performing(…)
Harden MS Reporting Services Using Custom ExtensionsHarden MS Reporting Services Using Custom Extensions, Part 2SQL Server 2000 Reporting Services Deployment GuideHitchhiker’s Guide to SQL Server 2000 Reporting ServicesTutorial: Adding Conditional Formatting into Reporting ServicesChris Hays’s Reporting Services Sleazy Hacks WeblogReport-enable Your Web Apps with Microsoft Reporting ServicesSQL Reporting Services Tree Navigation Sample using a Web(…)
I found a good article on the new version of Reporting Services. According to Welcker, “Everything will be upgrade-in-place for Report Server. Reporting Services 2000 reports can be run on 2005 though there won’t be support for any features that are new in 2005. Reports will be automatically upgraded if opened in the 2005 Report(…)
Speaker: Kimberly Tripp SQL Server stared from a team of five (Sybase) to 400 (for 7.0) to over 1,000 (for 2005). Geez, do you think that they’ve put some money into this thing? Query Analyzer and SQL Enterprise Manager are now lumped in to SQL Management Studio Analysis Manager turns into BI Developer Studio(…)