Left join with Entity Framework (Method Syntax) Etienne Giust, January 1, 0001 Here is a problem I encountered recently trying to perform a simple SQL operation using method syntax of Entity Framework. I had 2 IEnumerable<Object> datasets (dataset1 and dataset2). I wanted to ... Left join with Entity Framework (Method Syntax) 0 0 2
SCOM 2012 - The installed version of SQL Server is not supported mattjgilbert, January 1, 0001 When installing System Centre Operations Manager 2012 and you are pointing to a remote Data Warehouse (for example, one shared between distributed management groups in a central location) which is behind ... SCOM 2012 - The installed version of SQL Server is not supported 0 0 1
Analyze Salesforce data with PowerPivot dataintegration, January 1, 0001 The ODBC protocol is used by a wide variety of Business Intelligence (BI) and reporting tools to get access to data from different databases. The CData ODBC Drivers bring the same power and ease of use ... Analyze Salesforce data with PowerPivot 0 0 0
Can Vectorwise execute a query joining databases from multiple in... Rahul Anand, January 1, 0001 I was looking for a feature in Ingre Vectorwise similar to ‘Linked Server’ in MS SQL Server and ‘Database Link’ in Oracle. But unfortunately it seems Ingre Vectorwise 2.5 does not offer anything similar. ... Can Vectorwise execute a query joining databases from multiple in... 0 0 1
BizTalk Automated Multi Server Deploy RobBowman, January 1, 0001 Background I’ve been working with BizTalk since 2006r1 (the one without the handy WCF adapters). Since that time I’ve tried various community offerings to improve the deployment process. In 2008 I was ... BizTalk Automated Multi Server Deploy 0 0 8
Ingres Vectorwise Client Tools Rahul Anand, January 1, 0001 There are different tools available to connect to the Ingres Vectorwise database server. Actian (the parent company) offers following tools: 1. DBA Tools (current version is 10.1.0) 2. Director Client ... Ingres Vectorwise Client Tools 0 0 0
What happened to Intellisense in Microsoft SQL Management Server ... Brian Biales, January 1, 0001 I was very happy with Intellisense in SQL Management Studio 2008, it worked great. So I was very surprised to have so many issues with it when I installed the 2012 version. First of all, it seems to take ... What happened to Intellisense in Microsoft SQL Management Server ... 0 0 1
Ready for .NET Code Camp in South Florida? Herve Roggero, January 1, 0001 Here we go again! South Florida Code Camp is about to start tomorrow, Saturday Feb 9 2013, at NOVA University in Fort Lauderdale. I have seen this event grow every year; over 900 people were registered ... Ready for .NET Code Camp in South Florida? 0 0 0
My introduction to Pentaho Data Integration – Kettle (ETL T... Rahul Anand, January 1, 0001 Context: Recently I got a chance to get introduced to Kettle, due to a new project which requires ingesting huge and dynamic data files using PDI in a data warehouse. I have a good experience working with ... My introduction to Pentaho Data Integration – Kettle (ETL T... 0 0 2
Why you Should be Using SQL Prompt! Nick Harrison, January 1, 0001 You have probably seen this ad floating around the Internet. Probably see it on this very blog. If you are already familiar with this wonderful tool, the ad makes perfect sense to you. SQL Prompt is to ... Why you Should be Using SQL Prompt! 0 0 2
Why SQL TOP may slow down your query and how to fix it Martinez, January 1, 0001 ABSTRACT This article shows that adding a TOP clause to the SQL SELECT query may greatly increase its execution time. It also shows very effective solution to fix this problem. INTRODUCTION Lately I was ... Why SQL TOP may slow down your query and how to fix it 0 0 5
I'm back and here what I've been doing! Jenson, January 1, 0001 Hey guys, Sorry that I've not been updating my blog for quite some time now, as I've been rather busy a work in my ex company. I didn't even have time for my family, not to mention about blogging!Phew! ... I'm back and here what I've been doing! 0 0 0
Change the Maxsize and Filegrowth of a datafile and a logfile remko, January 1, 0001 If you need to alter a database file and logfile to change their maxsize and filegrowth settings, here is a small script that might help you ---------------------------... ... Change the Maxsize and Filegrowth of a datafile and a logfile 0 0 0
Managing Parallel Team Development–Using NuGet Dylan Smith, January 1, 0001 For probably over a year now I’ve been hearing lots of hype around package managers and NuGet in particular. I’ve never really “got it” – that is until last week. So what, NuGet will download the nHibernate ... Managing Parallel Team Development–Using NuGet 0 0 1
Setting HTML.CheckBoxFor Values in MVC 4 View from Json return us... Bob Hardister, January 1, 0001 I’m an MVC/jQuery noobie and this one really got my goat for while. The problem was handling the bit field in SQL Server which was treated as a checkbox field in MVC. Here’s how you can set a checkbox ... Setting HTML.CheckBoxFor Values in MVC 4 View from Json return us... 0 0 0
Biztalk Application Testing Life Cycle Part 2 AbhishekLohani, January 1, 0001 In Biztalk Application Testing Life Cycle Part 2 we cover Non Fuctional Testing In Non Fuctional Testing we required test below areas as a part of Non Fuctional Testing 1 Acess Right - Filesahre, SQL, ... Biztalk Application Testing Life Cycle Part 2 0 0 0
How to always return XML using an ASP.NET Web API project Cory Koski, January 1, 0001 I came across the need to test whether or not ASP.NET Web API would work with SQL Server Reporting Services (SSRS) 2008 recently. ASP.NET Web API can push XML, and if you write clever enough reports, you ... How to always return XML using an ASP.NET Web API project 0 0 0
Building a Repository Pattern against an EF 5 EDMX Model - Part 2 JuansAndZeros, January 1, 0001 I know it has been a couple months since I first wrote part 1 of building a repository pattern with an EF model, but here we are. I am finally getting around to writing part 2. If you remember, in part ... Building a Repository Pattern against an EF 5 EDMX Model - Part 2 0 0 0
Grouped Failover, a 2008R2 version of Availability groups remko, January 1, 0001 One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well ... Grouped Failover, a 2008R2 version of Availability groups 0 0 0
January 2013 Chicago IT Architect Group Summary Tim Murphy, January 1, 0001 This month we had a great turn out. I was glad to see so many people come out on a cold Chicago evening. Shankar kept the subject as light as possible with a number of humorous images and one liners. The ... January 2013 Chicago IT Architect Group Summary 0 0 0
Force shrink of transaction log after a full backup remko, January 1, 0001 After installing vCenter and connecting it to a SQL Server 2008R2 database server and making it high available with the help of database mirroring, somthing anoying started to take place. After a full ... Force shrink of transaction log after a full backup 0 0 0
Determine all foreign keys in a database Jake Rutherford, January 1, 0001 Quick script to determine all foreign keys in your SQL Server database:SELECT f.name AS ForeignKey, OBJECT_NAME(f.parent_object... AS TableName, COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName, ... Determine all foreign keys in a database 0 0 2
My Thoughts on the future of BizTalk - Post BizTalk Summit 2012 Michael Stephenson, January 1, 0001 I thought I’d brain dump a few thoughts after the recent BizTalk summit and how some of the information will help shape solutions with the customers whom I work with. BizTalk On-Premise Traditionally for ... My Thoughts on the future of BizTalk - Post BizTalk Summit 2012 0 0 494
First Chicago IT Architects Meeting Of 2013 Tim Murphy, January 1, 0001 It seems we all survived the end of the world. Welcome to 2013. The Chicago IT Architects Group is kicking off the year with our first meeting on January 15th. Shankar Ramanchandran will be discussing ... First Chicago IT Architects Meeting Of 2013 0 0 0
Step-by-Step: Build a FREE SharePoint 2013 Lab in the Cloud with ... KeithMayer, January 1, 0001 My good friend and colleague, Tommy Patterson, recently blogged about leveraging the Windows Azure Infrastructure as a Service (IaaS) preview offering to build a FREE lab environment in the Cloud. You ... Step-by-Step: Build a FREE SharePoint 2013 Lab in the Cloud with ... 0 0 7
Timestamp to String Anthony Trudeau, January 1, 0001 The SQL Server TIMESTAMP data type is represented as a byte array in the .NET Framework (byte[] in C#). You may have the need for any number of reasons to provide a representation of the timestamp that ... Timestamp to String 0 0 3
Chapter Review: The Utility Database (by Chris Shaw) and how it a... Herve Roggero, January 1, 0001 Sometimes you end up reading a great chapter and feel like writing a review about it… well here it is! Chris Shaw (@SQLShaw, http://chrisshaw.wordpress.com ) wrote a chapter in the PRO SQL Server 2012 ... Chapter Review: The Utility Database (by Chris Shaw) and how it a... 0 0 0
Excel ODBC on OSX, Connect to SQL Server Richard Jones, January 1, 0001 Oh goodness. What a shocker. How hard can it be, to simply make Microsoft Office Mac (Excel) connect to Microsoft SQL Server. I've spent the last 2 hours being told to go spend $xx to go buy ODBC drivers ... Excel ODBC on OSX, Connect to SQL Server 0 0 0
Google Code Prettify for geekswithblogs.net Soe Tun, January 1, 0001 This blog post is based on the information I found from this blog post http://geekswithblogs.net/w... I find it very difficult and tedious to ... Google Code Prettify for geekswithblogs.net 0 0 1
How to install PVS server Waclaw Chrabaszcz, January 1, 0001 Is it good to have a streaming server …. Hmm … it is a good to know how it works. Let's install one: "D:\Server\PVS_Server_x64.exe" /S /v" /qn""D:\Console\PVS_Console... /S /v" /qn" And configure ... How to install PVS server 0 0 9
Extending the behavior of MVC AuthorizeAttribute for activity-bas... Stacy Vicknair, January 1, 0001 If you’re familiar with NetSqlAzMan or CanCan, you know that checking permissions based on a user’s activities is easier to manage and more flexible that working with the roles a user is in. Whatever method ... Extending the behavior of MVC AuthorizeAttribute for activity-bas... 0 0 2
2012: Study Plan Year in Review JoshReuben, January 1, 0001 Over the past year I went into study overdrive: I learned A LOT about C++, Maths, Algorithms, Finance & JavaScript. It was a great year in terms of knowledge acquisition. pro amore scientiam ! C++ ... 2012: Study Plan Year in Review 0 0 2
PRO SQL Database for Windows Azure Herve Roggero, January 1, 0001 After months of work, rework, revisions and reviews, the second edition of the APress book PRO SQL Database for Windows Azure is out! You can get it on Amazon (Paperback or Kindle) or through Barnes & ... PRO SQL Database for Windows Azure 0 0 0
Scalable Distributed Workload with Azure Queues Herve Roggero, January 1, 0001 If you develop an application for the cloud, such as Microsoft Azure, you may need to create a distributed workload. Distributing workload in the cloud is one of the fundamental aspects of scalability, ... Scalable Distributed Workload with Azure Queues 0 0 0
Big Data–Where to Start JoshReuben, January 1, 0001 I recently read the Big Data Glossary - http://www.amazon.com/Big-D... Big Data is essentially a MapReduce stack for scatter-gather-aggregate scaleout of compute jobs. ... Big Data–Where to Start 0 0 1
BizTalk: Internals: Schema Uniqueness Rule Leonid Ganeline, January 1, 0001 A source code could be downloaded from here.Global artifacts are usually tentative things. Languages and tools have different methods to limit the artifact visibility. Think about public and private variables, ... BizTalk: Internals: Schema Uniqueness Rule 0 0 1
APress Deal of the Day 21/Dec/2012 - Ultra-Fast ASP.NET 4.5 TATWORTH, January 1, 0001 Today's $10 deal of the day from APress at http://www.apress.com/97814... is Ultra-Fast ASP.NET 4.5"Ultra-Fast ASP.NET 4.5 provides a practical guide to building extremely fast and scalable web sites ... APress Deal of the Day 21/Dec/2012 - Ultra-Fast ASP.NET 4.5 0 0 0
Integrate Apps with Gmail (.NET or Java). dataintegration, January 1, 0001 Use the CData Google ADO.NET Provider or JDBC Driver to read and search email messages on your Gmail accounts.The CData Google Data Provider for ADO.NET allows you to use the search capabilities in IMAP ... Integrate Apps with Gmail (.NET or Java). 0 0 0
C# to VB .NET Conversion Issues Jesse Taber, January 1, 0001 In my last post I discussed the approach we used at my job to convert an ASP .NET web forms application written in VB .NET to C#. In that post I alluded to some of the issues that we encountered during ... C# to VB .NET Conversion Issues 0 0 0
AppFabric Private Caching: What to Watch Out For jasont, January 1, 0001 The ability to have a private AppFabric cache deployed as a cluster of worker roles, or piggy-backing your existing roles, is great. But there are some things to watch out for, which can cost you a lot ... AppFabric Private Caching: What to Watch Out For 0 0 1
My New Productivity Enhancer – SQL Complete by Devart Compudicted, January 1, 0001 As the new year is quickly approaching I am feeling increasingly worried about what goals I should be setting for 2013 as a database professional. I tried to get a glimpse back into 2012 analyzing trends ... My New Productivity Enhancer – SQL Complete by Devart 0 0 0
SSAS with a slowly changing dimension jkrebsbach, January 1, 0001 At a client, they are interested in trying out some data cubes, so I spun up an instance of SSAS and gave them a demo of some of the awesome opportunities that cubes unlock – but found an interesting puzzle ... SSAS with a slowly changing dimension 0 0 0
How to install SCSM 2012 Management server Waclaw Chrabaszcz, January 1, 0001 Don't forget about prerequisites: SCSMrun and SCSMworkflow accounts with efficient rights – for testing purposes you can add them into local admins SQL Server – SCSMrun must be sysadmin Management server: ... How to install SCSM 2012 Management server 0 0 5
Super D to the B to the A – AKA Script for reducing the siz... Robz / Fervent Coder, January 1, 0001 The following is a script that I used to help me clean up a database and reduce the size of it from 95MB down to 3MB so we could use it for a development backup. I will note that we also removed some of ... Super D to the B to the A – AKA Script for reducing the siz... 0 0 1
How to install System Center 2012 Orchestrator Waclaw Chrabaszcz, January 1, 0001 Let's make a shortcut … as usual. {Orch_install_media}\setup\... /Silent /ServiceUserName:%computern... /ServicePassword:Password1 /Components:All /DbServer:%computername%\SQ... ... How to install System Center 2012 Orchestrator 0 0 0
Installing SharePoint 2013 on Windows Server 2012 VM running on W... Ismail Durgut, January 1, 0001 I will explain the process of installing SharePoint 2013 on a Windows 8 Hyper V in a disconnected scenario. This matters for the prerequisites which by default downloads the prerequisites if run from the ... Installing SharePoint 2013 on Windows Server 2012 VM running on W... 0 0 0
Refresh Database–Speed up Your Development Cycles Robz / Fervent Coder, January 1, 0001 Refresh database is an workflow that allows you to develop with a migrations framework, but deploy with SQL files. It’s more than that, it allows you to rapidly make changes to your environment and sync ... Refresh Database–Speed up Your Development Cycles 0 0 2
SQL 2008 Express silent installation Waclaw Chrabaszcz, January 1, 0001 Wow! Today we have 12.12.12. How many times you needed "quick SQL" for your tests … Let's make it quick. Command line: Setup.exe /ConfigurationFile=SQLExpre... /Q However we need an answer file. One ... SQL 2008 Express silent installation 0 0 10
Eager Loading more than 1 table in LinqtoSql Michael Freidgeim, January 1, 0001 When I've tried in Linq2Sql to load table with 2 child tables, I've noticed, that multiple SQLs are generated. I've found that it isa known issue, if you try to specify more than one to pre-load it just ... Eager Loading more than 1 table in LinqtoSql 0 0 0