Who is online?  0 guests and 0 members
Home  »  search results

Search Results: TDE

31 results found
  • Summing Values in a Tablix
    Here is the Sql: Select A.ScenarioType , A.ClientType , A.SiteName , D.ReportDeptName , C.RoleName , A.ProjectName , B.HoursNum , E.FirstName , E.LastName , E.FteFctr From dbo.Project A , dbo.Template B , dbo.Role C , dbo.ReportDept D , dbo.Employee E Whe
    Author: bluize76 bluize76     Date: 8/4/2011     Section: Forum
  • Upcoming Community Events!
    Just a head's up. I've got a few speaking engagements coming up in the near future. Come out and join me at these fantastic free community events! 3/10/2012 - SQL Saturday #110 Tampa Introduction to Master Data Services 2012 More Info | Session Info 3/13/
    Author: cprice1979 cprice1979     Date: 2/9/2012     Section: Blog
  • Removing Header/Footer/Junk from text data file (bonus convert to csv)
    I see you have the variable intdelimcount set to 11, but the rows do not have 11 space delimiters. For example the first rows you have: 1 100 abc company mike davis 8005551212 9005551212 Knight, Brian there are only 9 spaces in this row so the rows would
    Author: MikeDavis MikeDavis     Date: 7/27/2010     Section: Forum
  • Encrypting individual columns during data flow using EncryptByKey?
    This would fall under an answer to "Thoughts? Suggestions?" since I haven't tried doing exactly what you're after. I don't know if this would meet your requirements, but you also might want to look into TDE ( Transparent Data Encryption ) if you're using
    Author: KeithHyer KeithHyer     Date: 11/23/2011     Section: Forum
  • Additional xml code appears in my SSRS 2008 report when saving it
    Currently I am having a problem with a report which I have been developing with SSRS 2008. My platform is Windows 7. The reports was created in BIDS a while back and so far it has been working well. Yesterday, after I made some small modification to it an
    Author: sibir1us sibir1us     Date: 5/24/2010     Section: Forum
  • PowerPivot Client - How To archive a PowerPivot Template for reuse
    We process on a monthly cycle basis and we do not freeze the state of the data for each cycle used in the database for PowerPivot analysis. The initial PowerPivot spreadsheet is the template (baseline). I would like to save the spreadhseet in the followin
    Author: thehitman thehitman     Date: 1/16/2013     Section: Forum
  • Accessing SSAS Cube from C# Web page
    check out this webcast from MSFT: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032293592&CountryCode=US
    Author: sundanceca sundanceca     Date: 12/2/2009     Section: Forum
  • How to Use SSIS to Loop through First 49 Diagnoses, Procedures and POA Flags
    Keith, I've gone with the stored procedure approach and have updated your syntax to reflect the various joins, fields and where clause. Note that I need to pivot up to 49 procedure codes as well. I've attempted to adapt your syntax but receive an error ne
    Author: schilders schilders     Date: 8/1/2011     Section: Forum
  • Encrypting individual columns during data flow using EncryptByKey?
    If I understand this correctly you wan to encryption the data into data flow task before putting it in the SQL table. In my opinion you can achieve this but you might have to apply Non-SQL encryption logic. As you have used EncryptByKey mechanism, your da
    Author: vksingh24 vksingh24     Date: 11/23/2011     Section: Forum
  • SSRS Error while deploying
    Hi, I am trying to deploy a SSRS report on Report Manager but it throws the below error. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdef
    Author: sneha19.m sneha19.m     Date: 3/29/2013     Section: Forum
    tags : KPIs
  • Deploying SSRS Solutions (DataSources,DataSets,Reports,etc)
    Check out BI-XPress from Pragmatic Works http://www.pragmaticworks.com/Products/BI-xPress/Features/ReportDeploymentTool.aspx The Report Deployment tool does transfer the reports, data sources and shared data sets.
    Author: KathiKellenberger KathiKellenberger     Date: 11/25/2012     Section: Forum
  • Parent/Child Help
    I think I see what you're after. You would not put only the "children" values into your "Sub P" table. You put both the "Parent ID" and the "Child ID" in that table. I've moched up an example that might help ( I apologize for the length of it ). There are
    Author: KeithHyer KeithHyer     Date: 5/20/2011     Section: Forum
    tags : CTE, association
  • KPI - ScoreCard - Dashboards
    I like really like how PerformancePoint displays KPIs. Do you already have MOSS 2007? I believe PerformancePoint licensing is included with Sharepoint now. http://www.microsoft.com/presspass/features/2009/jan09/01-27kurtdelbeneqa.mspx . I haven't used Rep
    Author: DevinKnight DevinKnight     Date: 12/17/2009     Section: Forum
  • Make an SSIS package Delay or Wait for Data
    Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. When the table has data then the package will beg
    Author: MikeDavis MikeDavis     Date: 11/12/2009     Section: Blog
  • SSAS error when processing the cube
    Every couple of weeks I see this SSAS error when processing one of my cubes: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. An error occurred while parsing the ‘StorageMode’ element at line
    Author: jamserra jamserra     Date: 6/15/2011     Section: Blog
    tags : SSAS, SQL Server
  • trying to calculate a group item's percent in relation to its group/column intersection total ... a scope issue
    Try this. For this example I will assume that your textbox for the Numerator is named txtNumerator, and the textbox for your Denominator is named txtDenominator Use this as your expression =ReportItems!txtNumerator.Value / ReportItems!txtDenominator.Value
    Author: Daniel Daniel     Date: 12/9/2011     Section: Forum
  • Find table name in Reports
    This is a useful script I picked up on sqlserverpedia.com. It can do a number of things, but I tweaked it a bit to let you look up ad hoc query information. DECLARE @TableName VARCHAR(50) SET @TableName = 'PutYourTableNameHere'; WITH XMLNAMESPACES ( DEFAU
    Author: Daniel Daniel     Date: 2/10/2012     Section: Forum
  • Find table name in Reports
    If all your reports are developed in VS8.0 then this does not apply If you have report builders using Report Builder 3.0 this only gives you half the picture as the XML definition is different for RB 3.0 than VS 8.0 You will need to run the following stat
    Author: syale syale     Date: 2/14/2012     Section: Forum
  • expression to do alternate color in background
    hi i m trying to give alternate color in my report =iif(RowNumber(nothing) Mod 2 , Code.StyleSheetValue("AltDetailBackgroundColor2"),Code.StyleSheetValue("AltDetailBackgroundColor1")) it gives me error like StyleSheetValue is not known identifier. any hel
    Author: ssrsnew ssrsnew     Date: 4/5/2012     Section: Forum
  • expression to do alternate color in background
    hi i m trying to give alternate color in my report =iif(RowNumber(nothing) Mod 2 , Code.StyleSheetValue("AltDetailBackgroundColor2"),Code.StyleSheetValue("AltDetailBackgroundColor1")) it gives me error like StyleSheetValue is not known identifier. any hel
    Author: ssrsnew ssrsnew     Date: 4/5/2012     Section: Forum
  • expression to do alternate color in background
    hi i m trying to give alternate color in my report =iif(RowNumber(nothing) Mod 2 , Code.StyleSheetValue("AltDetailBackgroundColor2"),Code.StyleSheetValue("AltDetailBackgroundColor1")) it gives me error like StyleSheetValue is not known identifier. any hel
    Author: ssrsnew ssrsnew     Date: 4/5/2012     Section: Forum
  • expression to do alternate color in background
    hi i m trying to give alternate color in my report =iif(RowNumber(nothing) Mod 2 , Code.StyleSheetValue("AltDetailBackgroundColor2"),Code.StyleSheetValue("AltDetailBackgroundColor1")) it gives me error like StyleSheetValue is not known identifier. any hel
    Author: ssrsnew ssrsnew     Date: 4/5/2012     Section: Forum
  • Finding columns used on all SSRS reports?
    I ended up making it a little cleaner/generic. It trims off the front and end. ;WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition', 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS
    Author: jadams jadams     Date: 7/12/2012     Section: Forum
  • Finding columns used on all SSRS reports?
    I found the issue. I used a CTE to first grab the report name and a string representation of the report XML contents. When doing this I found some strange chars at the start of the string and at the end. It was a quick hack, but I didn't have time to real
    Author: jadams jadams     Date: 7/11/2012     Section: Forum
  • Standard Deviations with CTE
    Standard Deviations with CTE’s in SQL I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE). The first CTE gets the
    Author: MikeDavis MikeDavis     Date: 3/23/2011     Section: Blog