tag:blogger.com,1999:blog-62539190443626179332024-03-08T03:37:03.758-05:00The Wayward ProgrammerInformation on .Net, SSRS, SQL, SharePoint, SSAS, SSIS, etc.Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-6253919044362617933.post-46887245900527723182012-05-24T15:53:00.001-04:002012-05-24T15:53:44.682-04:00TSQL Max and Over Clause
You can use the MIN, MAX, AVG and COUNT functions with the OVER clause to provide aggregated values on multiple rows.
For instance:
SELECT Name
, MIN(Rate) OVER (PARTITION BY edh.DepartmentID) AS MinSalary
, MAX(Rate) OVER (PARTITION BY edh.DepartmentID) AS MaxSalary
, AVG(Rate) OVER (PARTITION BY edh.DepartmentID) AS AvgSalary
,COUNT(edh.BusinessEntityID) OVERWayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-82038353305189229482011-01-29T11:19:00.003-05:002011-01-29T11:38:51.807-05:00WCF Ria Services vs WCF ServicesWCF RIA Services
Pro’s:
Service can be consumed easily from Silverlight, AJAX, and WebForms. (Not winforms(??))
Non-discoverable.
Richer client side object model by including business rules and relationships between objects.
Quicker to set up. Good for Rapid development.
More control over what is exposed. Uses a set Interface.
Integrated change tracking by default.
Can monitor changes in client Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-51205417911576893232010-12-24T11:27:00.000-05:002010-12-24T11:27:03.749-05:00SSRS Issues attaching Reports to Email subscriptionsI was attempting to set up an email subscription on our production server the other day but kept getting errors when the subscription ran. The development server subscriptions ran fine, the configuration settings for both servers appeared identical.
The weird thing was that I could send a subscription through email as long as I didn't attach the report.
After much searching, and pulling outWayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-65916122349875456022010-12-24T11:15:00.000-05:002010-12-24T11:15:08.119-05:00Display all SQL Server's on a Networkcd C:\Program Files\Microsoft SQL Server\90\Tools\Binn
sqlcmd -LWayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-65928970678685755202010-12-24T11:11:00.001-05:002010-12-24T11:12:17.589-05:00Coalescing (??) Operator for .NetThe Null-Coalescing Operator acts similiar to TSQL IsNull.
The ?? operator defines the default value to be returned when a nullable type is assgned to a non-nullable type. This works for both reference types and value types
C#.Net Example:
string message = strOldMessage ?? "This is the default";
TSQL Example:
IsNull(printDate, GetDate())Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-49679743066050640542010-11-12T17:44:00.002-05:002011-01-29T11:45:54.379-05:00Bulk Import into AD LDS Using cvsde command line utiltiyDiscovered how to bulk import users into AD LDS by using cvsde command line utiltiy.
Example:
cd C:\Windows\System32
csvde -i -f c:\importFile.csv -s ServerName -t PortNumber
...
This uses SSPI. More info can be found at: http://technet.microsoft.com/en-us/library/cc787549%28WS.10%29.aspxWayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-54797475602999549742010-09-17T23:33:00.003-04:002010-09-17T23:35:37.815-04:00MMRWA Presentation - Social Media 101Tomorrow I'll be giving a presentation on Social Media 101 for the Mid-Michigan Romance Writers Association.
Blogging Jargon
Comparison of Blog Software Features and Tools
Helpful Links
I'll add more tomorrow after the meeting.
See you there!!Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-51006014117830703292010-09-06T19:11:00.001-04:002010-09-06T19:13:42.979-04:00MotivationThis is a brief departure from my usual cut and dried format, but I thought I'd post about something a bit different today.
This past week has been a killer. I started a new job which uses significantly different technologies from my previous jobs, and in attempting to 'catch up' I feel burnt out. I know I need to put in extras hours outside of work to study up on the new technologies, but my Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-24303604379703487862010-09-04T08:37:00.001-04:002010-10-07T11:48:36.225-04:00SQL Try CatchWhat is TRY… CATCH?
The TRY... Catch construct was designed to improve the functionality in processing errors. With it comes a cleaner and more readable syntax that is familiar to programmers. In addition, this construct can return the transaction state of your procedures, and allow the developer to either log the details of the error, or return this information to the calling procedure.
The Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-29742796855212927012010-08-21T12:00:00.001-04:002010-08-21T12:05:28.206-04:00Search Engine OptimizationUse precise Keywords.
i.e. Load - Bank Loan, Student Loan, Equity Loan, etc.
Order and placement of Keywords matters
The relative distance between keywords in documents (proximity)
Where in a document the terms occur (distribution)
The co-citation frequency between terms (co-occurance)
The main theme, topic, and sub-topics (on-topic issues) of the documents
Use Keyword in your domain or sub Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-71675303385431300642010-03-28T13:02:00.003-04:002010-03-28T13:05:12.730-04:00Beginners .Net Converting Between TypesWidening Conversion - VB and C# allow implicit converison if destingation type can accomodate all possible values from the source.
For example:
Dim i as Integer = 1
Dim d as Double = 1.0001
d = 1 ' Conversion allowed.
Narrowing Conversion - Range or precision of the source type exceeds the destingation type. Usally requires explicit conversion.
For Example:
.ToString, .TryParse, Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-41774957541767961012009-12-13T18:44:00.006-05:002009-12-13T19:02:00.057-05:00SSRS Row and Group Background FormattingFor Visual Stuido 2005:
Select the whole row, open the "Properties" pane. In the Background property click the drop down box and select "Expression". In the pop up box, copy/paste the =IIF(...) statement. Click OK.
Alternate the row color for Detail Lines:
=IIF(RowNumber(Nothing) Mod 2, "#eeeeee", "#ffffff")
Group Rows Alter row color: ("PO_NUM.Value" is the field that is being Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-37946445352688968142009-12-01T18:55:00.004-05:002009-12-01T19:39:55.309-05:00XML Web Services In "Data Source Library"1. Create a web service that returns data in xml format.
2. Open SharePoint Designer, Click on "Data View" on the top tool bar. In the side panel that opens click "Manage Data Sources".
3. Click "Connect to a web service..."
4. Data Source Properties -> Fill in values
**Parameters -> Check "The value of this parameter can be set via a web part connection" and insert a default value. (Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-32623446621179701562009-12-01T18:23:00.014-05:002009-12-01T19:49:56.810-05:00BDC Security OverviewSecurity options available when using BDC:
Authentication - verify a user is who he/she claims to be.
Authorization - Determine if user is permitted access to data.
Access Control - Manage access to business data exposed using BDC.
When BDC data is exposed on a Web page, the BDC runs within the IIS worker process (w3wp.exe) and uses the IIS application pool user account.
When BDC is crawled (Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-16705288755031966192009-12-01T18:16:00.024-05:002009-12-15T20:22:41.463-05:00Business Data Catalog OverviewThe Business Data Catalog (BDC) provides a method of exposing business data in SharePoint 2007 through a browser interface.
Line of Business Interoperability (LOBi)
Reduces or eliminates code
Achieves a deeper integration of data into places where users work.
Centralizes deployment of data source definitions.
Reduce latency to data.
Centralize data security auditing connections
Perform Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com0tag:blogger.com,1999:blog-6253919044362617933.post-86118759584885911622009-11-28T10:15:00.001-05:002009-11-30T18:12:24.876-05:00Cross Apply and Outer ApplyThe APPLY operator allows you to return values from an outer table much like JOIN, however I find it's easier to read, and allows joining two tables that I would've had to do some fancy foot work on to join. And since I'm always looking for the simpliest solution, this one fit the bill on my lastest project.
There are two forms of APPLY: CROSS APPLY and OUTER APPLY. CROSS APPLY Wayward Programmerhttp://www.blogger.com/profile/03472298706040855664noreply@blogger.com2