I'm working on reports and I'm finding most of the resources on the net are basic using the wizard or using one or two databases and I'd like something more indepth for my reports. I'm using a relational database on MS SQL Server 2008 and BIDS to develop and the users will access the reports through our Sharepoint site. There is also a lot of information on new cube databases and warehousing but the system we have is tied to an accounting program so its not likely we'd upgrade to newer technology or correct any database design issues.
I'm finding that some relationships set up in the database are incorrect. I'll have two primary keys linked (ie. client (ID) tied to invoice (ID) and then down a few fields will be a ClientID). When designing the query I'll correct these but will my data still be incorrect?
If the application or a unique index prevent doubles, no wories. Not semantical correct but you can have 100 tables without primary key and handle everything yourself. Database engine lacks info to optimal
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…