Featured Script
dba3_DynamicSql_Demo
see link(http://www.sswug.org/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?...(more)
(Krzysztof Dol) As productive databases containing important information systems rapidly grow larger and larger, automated space management becomes more and more important. Although Informix Dynamic Server (IDS) does not currently offer an integrated space management feature, it does already include tools and capabilities that you can use to avoid outages caused by running out of disk space.
(gstolarov) This article touches on couple of issues related to geo-coding, in particular:
--Converting ESRI shape file to XML
--Parsing address
--Geo-coding address
(Kasper de Jonge) Having played with Data mining in combination with PowerPivot in a previous blog post, i wanted to do data mining at the company i�m currently consulting at, they use Excel 2007 in combination with SSAS. In excel 2007 we do not have the power of the flattened pivot table. So i had to think of a way to convert the pivot table to a regular excel table. And i found a way, since i have converted all my excel version to 2010 i had to find an older image with Excel 2007 to make this post. I have used the dutch Excel version in the screenshots, i hope you can follow it.
(Eric Johnson) SQL Server 2008 shipped with several enhancements to the T-SQL language. In a recent blog, we looked at the new MERGE syntax; today we are going to look at the new EXCEPT and INTERSECT syntax. Both of these operators allow you to compare results of two queries. Using EXCEPT, you can find all the rows that exist in one query but not the other. Using INTERSECT, you can find all the rows that are the same in both tables. This makes more sense with an example so let�s take a look. I took a copy of the HumanResources.Employee table from AdventureWorks and made two copies called Employee1 and Employee2. Then to give us different results, I ran the following delete statement.
(Susan Visser) Back by popular request, the DB2Night Show is doing another CRUNCHING THE NUMBERS episode wherein a live performance health check will be performed for a real DB2 LUW production database. If you would like to see how this works, watch the replay of Episode #9.
(Beth Massi) Starting in Visual Studio 2008 Service Pack 1, you can create ADO.NET Data Services to easily expose data models via RESTful web services. So if you are building a remote CRUD data access layer then this is a technology that you're probably using or are looking into.
(Willie Favero) Yup, you read that correctly. It's never to early to start planning for your upgrade to the bigger and better DB2 for z/OS. There is another new release of DB2 on the horizon, DB2 10 for z/OS. With every new DB2 comes you migration/fallback PTFs; that stuff you apply to your existing system so everyone plays well together.
There have been quite a few enhancements in SSRS in R2. Some of the ones that we have played with so far are:
--Report Builder 3.0: Right now, it is not bundled with the CTP. You need to download it separately from here.
--Support for the Map and Spatial Data
--AJAX Report Viewer
--RDL enhancements like new lookup functions and support for geospatial data
--ATOM Data Feeds: SSRS data can be exposed using ATOM Data Feeds. So, that data can be easily consumed by any client that can consume ATOM data feeds.
--New Data Visualization Report Items like the sparklines, Indicators etc.
(Eric White) Some time ago, I blogged about an approach for converting an XElement object to an XmlNode object, and vice versa. This is useful when you want to use a programming interface that takes and returns objects of type XmlNode, but you want to use the expressiveness and power of LINQ to XML for your code that modifies the XML tree. There are a few occasions where this isn�t good enough � you need to convert from an XDocument to XmlDocument and back. If you need to control encoding, round-trip the XML declaration, or round-trip processing instructions, then you need to use documents, not elements.
(Peter Vogel) In my last column (Reduce Maintenance with Routing in ASP.NET 4) I looked both at how routing reduces maintenance costs and how ASP.NET 4 simplifies implementing routing. This column goes into the details of integrating routing with your application.
(Chintan Shah) I have two different type of XML files, both have multiple namespaces in it. First one contains prefixes along with namespaces, where second one doesn't. The question is how do I find title (Organization->Person->title) using XPath or XQuery?
The full list of Oracle parallel execution features currently includes the following
--Parallel Query
--Parallel DML
--Parallel DDL
--Parallel Data Loading
--Parallel Recovery
--Parallel Replication
--How Parallel Execution Works
(Steve Muench) Many enterprise applications include at least one table that stores different logical kinds of business information in its rows. For example, in the EMP table you�ll work with in this column�s application, the rows represent employees with different job types. Although all job types share some attributes (such as hire date and salary), other attributes and logic are specific to certain types of jobs. This column illustrates how to use inheritance in the entity object and view object layers to simplify building applications in which the business logic and attribute list vary by type.
(AzamSharp) Dependency injection is a process of supplying an external dependency to a component. In this article we will learn how to use StructureMap as our dependency injection container.
(Hemant K Chitale) The documentation on the RMAN command RESTORE ... VALIDATE (link to the 10.2 documentation) is likely to be misunderstood. It says "Lets RMAN decide which backup sets, datafile copies, and archived logs need to be restored, and then scans them to verify their contents. No files are restored. Use VALIDATE to verify that the backups required to restore the specified files are intact and usable."
However, the fact of the matter is that a RESTORE DATABASE VALIDATE only checks the BackupSets corresponding to a Database Backup. You must remember that BackupSets corresponding to ArchiveLog Backup(s) are *separate*. These are NOT validated by a RESTORE DATABASE VALIDATE command. Furthermore, ArchiveLogs are required at the RECOVER phase. Therefore, in principle, there is no reason for a RESTORE VALIDATE to check ArchiveLogs as they are not required in the RESTORE phase ! (I know : Many DBAs will not agree with the last sentence !. But it is mportant to realise the difference between RESTORE and RECOVER).
(Michael Pedersen) I've begun working on translating a board game into a computer game. In order to do so, I need to be able to represent the state of the game and its many (many) tokens. In addition, I need to be able to store and load that state quickly. Finally, I need that state to be something that I can represent with a single string.
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 Entit...(more)
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 ...(more)
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 Intell...(more)
Featured Article(s)
Useful undocumented SQL Server 2008 log shipping stored procedures
In this article, Alexander Chigrik looks at six undocumented SQL Server log shipping stored procedures that shipped with SQL Server 2008.
Learning SQL Server, SharePoint, Business Intelligence... ...(more)
Manual testing for SQL injection requires a lot of effort with little guarantee that you'll find every vulnerability. Fortunately, there is a better way.
It's not uncommon for DBAs to be lulled into a false sense of security by log shipping, without realizing the negative effects it could have on disaster recovery.
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.
Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.
The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.
Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.
The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.
Maintaining a secure environment means not only shoring up your highly visible systems, but also staying on top of the smaller installations that tend to slip through the cracks.
Whether you've already implemented SharePoint, or are only preparing to, backup and recovery should be a priority. Discover how to use SharePoint's out of the box backup and restore capabilities to protect your data in case of calamity. This session will take a quick trip through the built in backup options available with SharePoint; suggest some tips, tricks, and best practices; and focus on some techniques concerning how to restore that data before disaster strikes.
Presented by: CA Callahan
Sponsored by: EMC (www.EMC.com)
Report Builder can be an extremely useful tool for generating reports in SSRS. This page provides resources on how to properly utilize all of its functionality.
This presentation introduces a new mechanism in SQL Server 2008 that can report on and enforce server states, using Policy Based Management. You will learn how this feature works, where you can apply it, and how it can save you time in managing your systems. You'll learn to run a compliance report across your SQL Server 2000, 2005 and 2008 systems and act on that report to find databases that are not backed up, naming standards that are not enforced and more.
Presented by: Sarah Barela
Sponsored by: Idera (www.Idera.com)
As databases continue to grow in size, the time it takes for backup and recovery grows in length of time. Attend this session and learn methods to minimize the time it takes for your backups to complete, as well as how to minimize the amount of time it takes to recover.
Presented by: Thomas LaRock
Sponsored by: BakBone Software (www.BakBone.com)
With failover clustering, data mirroring, peer-to-peer replication, and log shipping available there is an option or two for every scenario. While each technology has a place in the world, they aren't interchangeable and provide the greatest benefit when applied to the proper solution. A walkthrough of each of these technologies and where they fit in your environment.
Presented by: Jason Strate
Sponsored by: BakBone Software
Even when your gauge is complete, there are still a few tweaks to be made in the name of data visualization. Learn how to add the right finishing touches with Report Builder 3.0.
When working with gauges, three key components can influence the overall effectiveness of your reports. Understanding them can help you get the most out of Report Builder 3.0.
No matter how much we prepare, when disaster strikes we all feel a moment of panic. For some that panic quickly passes as we get down to work to fix the problem. For others the panic continues to grow as we search for a solution. Of course back up is crucial, but in this session Sarah will provide useful real world best practices that will show how to recover from disaster and more importantly how to prepare for the inevitable. Specifically how to recover from common disaster scenarios. For example, what to do when the master database is corrupt, a drive array with half your database files fails, a hardware failure, a SQL injection attacks wipes out whole tables and many more.
Presented by: Sarah Barela
Sponsored by: BakBone Software (www.BakBone.com)