Posts

TSQL 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 ) OVER ( PARTITION BY edh . DepartmentID ) AS EmployeesPerDept FROM EmployeePayHistory AS eph       JOIN EmployeeDepartmentHistory AS edh             ON eph . BusinessEntityID = edh . BusinessEntityID       JOIN Department AS d             ON d . DepartmentID = edh . DepartmentID http://msdn.microsoft.com/en-us/library/ms187751.aspx
Post a Comment
Read more

WCF Ria Services vs WCF Services

WCF 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 and batch the changes to the server. Uses reflection at design time to see objects (doesn’t use service contracts) Creates client code in Silverlight. Design time experience with data sources, drag drop etc. (Contains these features) Shares validation logic in client. Can use a set interface. Also provides Context object in client. Can support Linq queries between client and server but these are based on Interface. Examples: GetGamesByIdQuery(1); Var qry = GetGamesQuery().Where(g =>; g.Price < 50) LoadOperation op = cnt.Load (qry); Con’s: Harder to Customize than ...
Post a Comment
Read more

SSRS Issues attaching Reports to Email subscriptions

I 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 out my hair, I finally found this KB article: A call to the "AuthzInitializeContextFromSid" API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services My hint was the error in the error log: ERROR: Throwing Microsoft.ReportingServices. Diagnostics. Utilities. ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.; KB article 842423 walks yo...
Post a Comment
Read more

Display all SQL Server's on a Network

cd C:\Program Files\Microsoft SQL Server\90\Tools\Binn sqlcmd -L
Post a Comment
Read more

Coalescing (??) Operator for .Net

The 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())
Post a Comment
Read more

Bulk Import into AD LDS Using cvsde command line utiltiy

Discovered 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.aspx
Post a Comment
Read more

MMRWA Presentation - Social Media 101

Tomorrow 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!!
Post a Comment
Read more