SQL Server 2012 Express LocalDB – How to get started krislankford, January 1, 0001 As many of you aware, SQL Server can be a bit of a pig when it comes to system resources on your development machine. As part of the 2012 products Microsoft has added SQL Server 2012 Express LocalDB which ... SQL Server 2012 Express LocalDB – How to get started 0 0 4
Application Integration Future – BizTalk Server & Windo... SURESH GIRIRAJAN, January 1, 0001 I am really excited to see lot of new news around BizTalk in TechEd 2012. I was recently watching the session presented by Sriram and Rajesh on “Application Integration Futures: The Road Map and What's ... Application Integration Future – BizTalk Server & Windo... 0 0 3
TechEd 2012: Fast SQL Server Tim Murphy, January 1, 0001 While I spend a certain amount of my time creating databases (coding around SQL Server and setup a server when I have to) it isn’t my bread and butter. Since I have run into a number of time that SQL Server ... TechEd 2012: Fast SQL Server 0 0 1
Windows Azure Evolution – TFS Integration (WAWS Part 2) Shaun, January 1, 0001 So this is the fourth blog post about the new features of Windows Azure and the second part of Windows Azure Web Sites. But this is not just focus on the WAWS since the function I’m going to introduce ... Windows Azure Evolution – TFS Integration (WAWS Part 2) 0 0 0
Using Table-Valued Parameters in SQL Server Jesse Taber, January 1, 0001 This blog post has moved:http://gruffcode.com/... ... Using Table-Valued Parameters in SQL Server 0 0 2
Windows Azure Evolution - Web Sites (aka Antares) Part 1 Shaun, January 1, 0001 This is the 3rd post of my Windows Azure Evolution series, focus on the new features and enhancement which was alone with the Windows Azure Platform Upgrade June 2012, announced at the MEET Windows Azure ... Windows Azure Evolution - Web Sites (aka Antares) Part 1 0 0 7
Building a Mafia…TechFest Style David Hoerster, January 1, 0001 It’s been a few months since I last blogged (not that I blog much to begin with), but things have been busy. We all have a lot going on in our lives, but I’ve had one item that has taken up a surprising ... Building a Mafia…TechFest Style 0 0 0
‘Publish…’ Resulting in Directory With No File... ToStringTheory, January 1, 0001 I was pulling my hair out with this one… Which isn’t good considering I have so little of it left! I had just upgraded to the Windows Azure 1.7 SDK the day before with no problems, and used the upgraded ... ‘Publish…’ Resulting in Directory With No File... 0 0 0
The True Cost of a Solution D'Arcy Lussier, January 1, 0001 I had a Twitter chat recently with someone suggesting Oracle and SQL Server were losing out to OSS (Open Source Software) in the enterprise due to their issues with scaling or being too generic (one size ... The True Cost of a Solution 0 0 8
Windows Azure Evolution – Welcome to VS2012 Shaun, January 1, 0001 When the Microsoft released the first preview version of Windows 8 and Visual Studio, many people in the community were asking if the windows azure tool is available to it. The answer was “NO”. Microsoft ... Windows Azure Evolution – Welcome to VS2012 0 0 0
Windows Azure Evolution – Preview Developer Portal Shaun, January 1, 0001 With the MEET Windows Azure event on 7th June, there are many new features and updates in windows azure platform. In the coming several posts I will try to cover some of them. And in the first post here ... Windows Azure Evolution – Preview Developer Portal 0 0 0
Microsoft Lowers Cloud Barrier To Entry Herve Roggero, January 1, 0001 Once in a while, the technology stack changes enough to create a disturbance in the IT industry. Microsoft did just that today and has officially closed the gap with its #1 competitor: Amazon. What is ... Microsoft Lowers Cloud Barrier To Entry 0 0 1
Windows Azure v1.7 Spring Release Today–New Management Dash... ToStringTheory, January 1, 0001 Today, Microsoft will be publicly releasing a new version of Azure for public consumption. The web conference, at http://www.meetwindowsazure... will be airing at 1 PM PST. They have already released ... Windows Azure v1.7 Spring Release Today–New Management Dash... 0 0 0
KCDC Attendee or What I learned over my summer vacation tom, January 1, 0001 This summer I went to a the Kansas City Developers Conference (April 27 and 28th, 2012). It was fun and I learned a lot. I have been 3 times before and this is my first time blogging on it so here goes. ... KCDC Attendee or What I learned over my summer vacation 0 0 0
Migrating Core Data to new UIManagedDocument in iOS 5 samerpaul, January 1, 0001 I have an app that has been on the store since iOS 3.1, so there is a large install base out there that still uses Core Data loaded up in my AppDelegate. In the most recent set of updates, I raised the ... Migrating Core Data to new UIManagedDocument in iOS 5 0 0 0
Why are so many DBCC commands undocumented? DBA, January 1, 0001 Paul Randal of SQLskills.com does a great job of answering the question of why there are so many undocumented DBCC commands in his post Why are so many DBCC commands undocumented? I would like to go on ... Why are so many DBCC commands undocumented? 0 0 0
My Tech Ed North America Preview - Certification Edition Chris Gardner, January 1, 0001 In my previous TechEd North America Preview, I addressed all the content I wanted to see at the show. This time, we shall turn our attention to the certifications I might try to pick up. If you have never ... My Tech Ed North America Preview - Certification Edition 0 0 0
Fixing some Visual Studio 2012 RC install issues terje, January 1, 0001 Updated: June 7th 2012: Cause for the issues found! Unsupported scenario having TFS 11 Beta side-by-side. Uninstall TFS 11 Beta before or even after install of VS 2012 RC. The Visual Studio RC has shown ... Fixing some Visual Studio 2012 RC install issues 0 0 4
Events and Presentations Enrique Lima, January 1, 0001 There is a number of things going on this coming weekend, so this maybe pushing it … yet good to put it out there. June 2nd (tomorrow), presenting at SharePoint Saturday St. Louis. The topic is SQL Server ... Events and Presentations 0 0 0
SQL Injection – Beyond the Basics - A good article TATWORTH, January 1, 0001 At http://www.sqlmag.com/conte... there is an excellent article on the measures needed to defeat SQL Injection ... SQL Injection – Beyond the Basics - A good article 0 0 0
My Tech Ed North America Preview - Content Edition Chris Gardner, January 1, 0001 As I promised in my last post, I feel the need to give you a rundown on all the technical content I am looking forward to checking out at Tech Ed this year. We shall start with the content I know I'll ... My Tech Ed North America Preview - Content Edition 0 0 0
SSMS Slow To Save Bunch, January 1, 0001 When using SSMS 2008 I found it to be really slow when trying to save a file, even a small one with just some simple SELECT statements on it. The symptoms were the flashing save disk icons in the lower ... SSMS Slow To Save 0 0 0
How to restore your production database without needing additiona... David Atkinson, January 1, 0001 Production databases can get very large. This in itself is to be expected, but when a copy of the database is needed the database must be restored, requiring additional and costly storage. For example, ... How to restore your production database without needing additiona... 0 0 0
APress Deal of the Day 28/May/2012 - Pro SQL Server 2008 Analysis... TATWORTH, January 1, 0001 Today's $10 deal of the day from APress at http://www.apress.com/97814... is Pro SQL Server 2008 Analysis Services"Pro SQL Server 2008 Analysis Services will show you how to pull data together and ... APress Deal of the Day 28/May/2012 - Pro SQL Server 2008 Analysis... 0 0 0
How to perform Cross Join with Linq berthin, January 1, 0001 Cross join consists to perform a Cartesian product of two sets or sequences. The following example shows a simple Cartesian product of the sets A and B: A (a1, a2) B (b1, b2) => C (a1 b1, a1 b2, a2 ... How to perform Cross Join with Linq 0 0 0
Sterling NoSQL Sample Console App Patrice Calve, January 1, 0001 Jeremy Likness built a lightweight, NoSQL , object-oriented database for .Net 4.0 called Sterling. First, wow. Second, links: - CodePlex: http://sterling.codeplex.com/ - WikiPedia: NoSql http://en.wikipedia.org/wik... ... Sterling NoSQL Sample Console App 0 0 2
WANTED: SQL Saturday and Tech Day Speakers on Windows Phone and W... PaulJohnson, January 1, 0001 If you are a Windows Phone enthusiast, or really into the Windows 8 platform that is coming soon, then I ask you to consider sunny Baton Rouge, Louisiana as your vacation spot this coming August 4 for ... WANTED: SQL Saturday and Tech Day Speakers on Windows Phone and W... 0 0 0
IdentityMine is hiring in Seattle! Laurent Bugnion, January 1, 0001 Are you willing to work for a dynamic firm, on the latest platforms, with super modern and enthusing technologies (XAML, C#, Kinect, VUI, NUI, and much more)? Read the rest of this entry » ... IdentityMine is hiring in Seattle! 0 0 0
The emergence of Atlassian’s Bamboo (and a free SQL Source ... David Atkinson, January 1, 0001 The rise in demand for database continuous integration has forced me to skill-up in various new tools and technologies, particularly build servers. We have been using JetBrain’s TeamCity here at Red Gate ... The emergence of Atlassian’s Bamboo (and a free SQL Source ... 0 0 0
WCF Error tracking Pavan Kumar Pabothu, January 1, 0001 Have you ever gotten errors when working with WCF services? Open up your web.config/app.config on the server side and add the following<system.diagnos... <!-- This logging is great when WCF ... WCF Error tracking 0 0 0
SQL Server 2008 R2 setup fails on a Windows Virtual PC (VPC) with... Daniel Hester, January 1, 0001 When installing SQL Server 2008 R2 (Developer, Standard, or Enterprise) within a Virtual PC you may suffer the following problem: “The following error has occurred: The installer has encountered an unexpected ... SQL Server 2008 R2 setup fails on a Windows Virtual PC (VPC) with... 0 0 0
Microsoft Test Manager–Test Cases Not in a Test Plan Bob Hardister, January 1, 0001 Visual Studio and Team Foundation Server (TFS) 2010 provided support for system testing. Test cases were added as a work item type. But test plans and suites are not work items and this greatly limits ... Microsoft Test Manager–Test Cases Not in a Test Plan 0 0 1
Old SQL, Top and a Variable Bunch, January 1, 0001 I came across this the other day. Using SQL 2000 I could not get a Top statement to work with a variable. I had forgotten that only with SQL 2005 and higher could you do this trick. I found a good way ... Old SQL, Top and a Variable 0 0 0
Team Foundation Server 2010 Real-Time Burndown Charts Bob Hardister, January 1, 0001 The reality is that project managers need work status in real-time. The TFS Excel reports and web parts are great, but because they are sourced from the TFS SSAS cube the information can be up to 2 hours ... Team Foundation Server 2010 Real-Time Burndown Charts 0 0 1
TFS 2010 Web Part for Data Warehouse Views Bob Hardister, January 1, 0001 Team Foundation Server 2010 includes support for Data Warehouse and Analysis Cube Views. The company, Amrein Engineering, sells a web part that uses SQL statements to source data. You can implement this ... TFS 2010 Web Part for Data Warehouse Views 0 0 0
TFS 2010 Agile Iteration Burndown Chart Error - Could not connect... Bob Hardister, January 1, 0001 It seems there are many issues that can cause this error. But in my situation it turned out to be a permissions issue. It appears that other TFS 2010 reports use the service account (i.e. TFSReports) to ... TFS 2010 Agile Iteration Burndown Chart Error - Could not connect... 0 0 0
SQL Server 2008 R2 Install Failure and Resolution Bob Hardister, January 1, 0001 I was attempting to install SQL Server 2008 R2 on a sever with Windows Server 2008 R2 SP1. The server had a C:, E: and F: drives for the OS/programs, user DB and TempDB/Logs respectively. With the help ... SQL Server 2008 R2 Install Failure and Resolution 0 0 0
TFS 2010 Backup Utility Support for Multi-Server Topology Bob Hardister, January 1, 0001 The TFS 2010 backup utility, which is part of the September '10 TFS Power Tools release, is advertised to support a multi-server topology. Specifically where SharePoint is installed separately and on a ... TFS 2010 Backup Utility Support for Multi-Server Topology 0 0 0
TFS 2010 - SPS 2010 MOSS Web Part Connection Refresh Failure Bob Hardister, January 1, 0001 ISSUE "Refresh Error" dialog displays on Team Project portal MOSS web parts. There are several variations of refresh errors. Here is one instance: "An error ocurred while accessing application id tfs from ... TFS 2010 - SPS 2010 MOSS Web Part Connection Refresh Failure 0 0 0
Integrating Team Foundation Server (TFS) 2010 and SharePoint (SP)... Bob Hardister, January 1, 0001 INTRODUCTION The purpose of this post is to provide clear and concise steps for a very specific scenario: Integrating TFS 2010 with SP Server (SPS i.e. formerly MOSS) 2010 TFS and SPS are on different ... Integrating Team Foundation Server (TFS) 2010 and SharePoint (SP)... 0 0 0
Visual Studio ALM (TFS) Benefits Bob Hardister, January 1, 0001 Here's a summary of TFS 2010 enabled improvement opportunities. This is based on my research and work with TFS 2010 to-date. Unlike a list of features, this information is organized around the typical ... Visual Studio ALM (TFS) Benefits 0 0 0
How to confirm that data has stopped flowing from the TFS 2010 op... Bob Hardister, January 1, 0001 This is a great procedure because you can tell instantly if changes are going to be picked-up or not. You don't have to wait for the cube to process. Here's the procedure for TFS 2010: Make one or more ... How to confirm that data has stopped flowing from the TFS 2010 op... 0 0 0
Passing in report parameters to TFS 2010 OLAP Web Parts on the Te... Bob Hardister, January 1, 0001 There is some helpful information from Ewald Hofman on passing in parameters to the TFS SQL Server Analysis Services OLAP reports. But, the 2010 schema has changed. You can use the SQL Server Mgmgt Studio ... Passing in report parameters to TFS 2010 OLAP Web Parts on the Te... 0 0 2
How I Customized Report Parameters for Team Foundation Server 201... Bob Hardister, January 1, 0001 My goal was to have the burndown chart on the team project portal main page display the current iteration. The default report displays the tasks for the entire team project starting 5 days before the current ... How I Customized Report Parameters for Team Foundation Server 201... 0 0 0
The Forefront Identity Manager Service cannot connect to the SQL ... Leonard Mwangi, January 1, 0001 After configuring user profile you get the correlation id and in event logs you get The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. ... The Forefront Identity Manager Service cannot connect to the SQL ... 0 0 0
How to do debugging with visual studio 2008/2010 ? Chandradev, January 1, 0001 HiIf you have good debugging skill then you can save lots of time. In visual studio lots of options are available for debugging. Here are some good URL for debugging. It will be really useful in our daily ... How to do debugging with visual studio 2008/2010 ? 0 0 0
Links about SQL PIVOT Michael Freidgeim, January 1, 0001 One of my colleagues asked how to create SQL query to show results as columns of a row, that actually stored in multiple rows in the table. Other co-worker suggested to use cursor to manually generate ... Links about SQL PIVOT 0 0 0
List of resources for database continuous integration David Atkinson, January 1, 0001 Because there is so little information on database continuous integration in the wild, I’ve taken it upon myself to aggregate as much as possible and post the links to this blog. Because it’s my area of ... List of resources for database continuous integration 0 0 0
SQL Server Blog: SQL, Code, Coffee, etc. MarlonRibunal, January 1, 0001 If you want to follow my blog, please visit MarlonRibunal.com. These are some of the posts you'll see on my blog:On the road less traveled: a DBA Roadmap reviewWho are the sysadmins in this sql server?Limiting ... SQL Server Blog: SQL, Code, Coffee, etc. 0 0 0
Searching SQL Server Objects Bunch, January 1, 0001 I came across this tool the other day and found it to be very useful. In the past if I needed to search within all the stored procedures or views in a database I would use some SQL to run a query using ... Searching SQL Server Objects 0 0 0