Database
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. Due to the disconnected way our objects were going to work we decided to use guid or unique identifiers for our primary keys in our data model and assign guids in the middle tier. Of course, our DBAs weren't too keen on the idea and...
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 so this may come in handy. But according to my boy Jason SQL Server 2008 is a minor release. The course is free nonetheless. Via Tim Mitchell.
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 some routine user maintenance and was trying to delete a single role but I forgot to comment out my test SELECT statement in the DELETE query. So when the script ran the table data got whacked. I reviewed the row counts and immediately saw what...
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 Service API Using Forms Authentication in Reporting ServicesBrian Welcker's Blog, Group Program Manager for SQL Server Reporting ServicesTeo Lachev's Blog, Reporting Services Consultant and AuthorHow to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file...
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 Designer." Just what I wanted to know.
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 Profiler can now be run outside of the admin role. You can manage SQL Sever 2000, SQL Server 2005 and SQL Express from the SQL Management Studio. Source Safe (anything that uses the Windows Source Control API) integration is included into SQL Management...
Speaker: Amir Netz, Richard Tkachuk Analysis Services Proactive Caching Attempting to combine OLAP query performance Real Time data access (as needed) Hands off operation Automatic synchronization with the relational database No more explicit "cube processing"! Technically, caches all share very challenging problem: Coherency - maintaining consistency with the primary source of the data Low Latency - reflecting changes in the primary source in a small amount of time. Proactive Caching Challenges Efficiency How do we not drive the system insane with frequent updates How...
Speaker: Vineet Rao CLR goes thought SQL OS for Memory, Threads/fibers, Synchronization SQL-CLR host co-ordinates Assembly Loading, Security Management, App domains, Escalation policy for exceptions Memory Management Most of CLR memory (GC Heap_ comes from multi-page memory allocator (outside Buffer-pol, from "MemToLeave"). Max server memory setting does not cover CLR memory Performance counters can be used within SQL-CRL SQL Server sets a pre-defined list of FX assemblies that can be referenced in users assemblies. The list is set by SQL server at the time of CLR initialization Certain restrictions apply ie.. cannot call...
Speaker: Jason Carlson, Brian Welcker
Report Builder for SQL Server 2005 will allow users to build their own reports (ad-hoc).
Driven from a business model of the data so users do not need to understand the underlying data structures. Exposes a meta data model.
Not a full analytical client or replacement for Pivot Tables.
Report Builder is a "Click Once" App
Requires .Net 2.0
Built on top of MS Office paradigms: Excel, PowerPoint.
Can build reports from templates.
This looks simplistic. How can you build complex queries? Or can you?
Headers can float with the report. If you scroll to the...
Microsoft has just released the latest and greatest service pack for SQL Server 2000. SP 4 will contain a new version of MSXML and enhancements for 64-bit hardware. But here is the big reason to install the service pack, 230 bugs have been fixed in this release. For a full description of SP4 read this article on Tech Target.
Full Database Archive