Database Development and Source Control Enrique Lima, January 1, 0001 I have been working with Database Development and the aspects that come with it, the pain and the joy of moving from Dev to QA and then on to Production. Source Control has a place in Dev, and that is ... Database Development and Source Control 0 0 0
Using Recursive SQL and XML trick to PIVOT(OK, concat) a "Documen... Kevin Shyr, January 1, 0001 I'm in the process of building out a Data Warehouse and encountered this issue along the way.In the environment, there is a table that stores all the folders with the individual level. For example, if ... Using Recursive SQL and XML trick to PIVOT(OK, concat) a "Documen... 0 0 0
EntityFramework.SqlServerCompact VS 2010 error fix for "The opera... mrad, January 1, 0001 Installed package EntityFramework.SqlServerCo... after running my project was getting this error "The operation could not be completed. Unspecified error" Two ways to fix this:1. Install "Visual Studio ... EntityFramework.SqlServerCompact VS 2010 error fix for "The opera... 0 0 0
Customizing the Test Status on the TFS 2010 SSRS Stories Overview... Bob Hardister, January 1, 0001 This post shows how to customize the SQL query used by the Team Foundation Server 2010 SQL Server Reporting Services (SSRS) Stories Overview Report. The objective is to show test status for the current ... Customizing the Test Status on the TFS 2010 SSRS Stories Overview... 0 0 0
Awarded BizTalk MVP, 2012 Elton Stoneman, January 1, 0001 I'm very pleased to have been awarded a Microsoft MVP for the third year in a row.With new versions of SQL, VS and Windows shipping in 2012, and a bunch of very interesting things happening in Azure, it's ... Awarded BizTalk MVP, 2012 0 0 3
Working with packed dates in SSIS Jim Giercyk, January 1, 0001 One of the challenges recently thrown my way was to read an EBCDIC flat file, decode packed dates, and insert the dates into a SQL table. For those unfamiliar with packed data, it is a way to store data ... Working with packed dates in SSIS 0 0 5
Looking under the hood of SSRS Jim Giercyk, January 1, 0001 SSRS is a powerful tool, but there is very little available to measure it’s performance or view the SSRS execution log or catalog in detail. Here are a few simple queries that will give you insight to ... Looking under the hood of SSRS 0 0 2
West Palm Beach Developer Group March 2012 Meeting Recap Sam Abraham, January 1, 0001 Our West Palm Beach Developer Group March 2012 meeting featured Herve Roggero, Azure MVP and co-founder of Pyn Logic. Herve covered multiple case studies on migrating existing application to SQL Azure. ... West Palm Beach Developer Group March 2012 Meeting Recap 0 0 0
Automated SSRS deployment with the RS utility Stacy Vicknair, January 1, 0001 If you’re familiar with SSRS and development you are probably aware of the SSRS web services. The RS utility is a tool that comes with SSRS that allows for scripts to be executed against against the SSRS ... Automated SSRS deployment with the RS utility 0 0 0
MapRedux - PowerShell and Big Data Dittenhafer Solutions, January 1, 0001 MapRedux – #PowerShell and #Big Data Have you been hearing about “big data”, “map reduce” and other large scale computing terms over the past couple of years and been curious to dig into more detail? Have ... MapRedux - PowerShell and Big Data 0 0 0
SQL Saturday #141–June 16 1012 near Fort Lauderdale Herve Roggero, January 1, 0001 SQLSaturday #141 South Florida 2012 will be here in less than 3 months! This is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held June 16, ... SQL Saturday #141–June 16 1012 near Fort Lauderdale 0 0 0
SSRS optional parameters settings Natasa Gavrilovic, January 1, 0001 Recently I had to create couple SQL Server Reports (SSRS) with optional parameters built in. It took me a while to refresh memory how this can be done. It was very simple to create reports and processes ... SSRS optional parameters settings 0 0 6
Scaling-out Your Services by Message Bus based WCF Transport Exte... Shaun, January 1, 0001 We are almost done everything about the WCF transport extension over the message bus, which makes our services can be scaled out by introducing more instances over machines and servers. We had finished ... Scaling-out Your Services by Message Bus based WCF Transport Exte... 0 0 1
Moving Servers Today Jeff Julian, January 1, 0001 Well I like to look at pretty pictures on deployment days to keep my mind on the good side of software. Well I guess it is not that bad, but today we moved Geekswithblogs.net to a new server pool to update ... Moving Servers Today 0 0 0
Pre-selecting Iteration and Area Path for TFS 2010 SSRS Reports Bob Hardister, January 1, 0001 There are pieces of information spread out on this in various postings for SQL Server Reporting Services used in Team Foundation Server. Here are two: Customizing Report Parameters for Team Foundation ... Pre-selecting Iteration and Area Path for TFS 2010 SSRS Reports 0 0 0
Low-Latency High-Performant Financial App Infrastructures JoshReuben, January 1, 0001 Financial Apps feel the need for speed – this can come via parallelization, and via infrastructure - fast messaging and non-blocking distributed memory management. This blogpost gives an overview + examples ... Low-Latency High-Performant Financial App Infrastructures 0 0 3
Visual Studio & TFS 2012 – List of extensions and tools... terje, January 1, 0001 This post is continued HERE. Go to Part 1 – List of Product Updates for information on Visual Studio and TFS 2012 updates Looking for the VS 2010 extensions ? Go to Visual Studio 2010 - List of Product ... Visual Studio & TFS 2012 – List of extensions and tools... 0 0 8
BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) Darren Gosbell, January 1, 0001 The beta for BIDS Helper 1.6 was just released. We have not updated the version notification just yet as we would like to get some feedback on people's experiences with the SQL 2012 version. So if you ... BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) 0 0 3
The World of SQL Database Deployment GGBlogger, January 1, 0001 In my early development days, I used Microsoft Access for building databases. It made things easy since I only needed to package the database with the installation package so my clients would have access ... The World of SQL Database Deployment 0 0 1
SharePoint 2010 MSDN Labs Kelly Jones, January 1, 0001 Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mss... ... SharePoint 2010 MSDN Labs 0 0 1
How to nest transactions nicely - "begin transaction" v... Brian Biales, January 1, 0001 Do you write stored procedures that might be used by others? And those others may or may not have already started a transaction? And your SP does several things, but if any of them fail, you have to undo ... How to nest transactions nicely - "begin transaction" v... 0 0 4
Solving SharePoint 2010 Setup Errors Manually Agha Usman Ahmed, January 1, 0001 If you are installing SharePoint 2010 on a new box you might see the Setup Errors notification from the installer. In my case, I am using Windows Server 2008 R2, but I have seen the similar Error on Windows ... Solving SharePoint 2010 Setup Errors Manually 0 0 2
Installing SQL Server 2008 on Windows Server 2008 R2 Agha Usman Ahmed, January 1, 0001 In my attempt of installing and configuring SharePoint 2010 Farm, I have given a new Windows Server 2008 R2 box that should have SQL Server 2008. So when I attempt to install SQL Server 2008 on it, I came ... Installing SQL Server 2008 on Windows Server 2008 R2 0 0 1
Closing the Diary andrewbrust, January 1, 0001 It is with some sadness that I write this post as my last for the Redmond Diary blog on the Redmond Developer News and Visual Studio Magazine Web sites. Eleven days ago, I started a new blog for ZDNet ... Closing the Diary 0 0 1
SQL Server 2012 Training Kit TATWORTH, January 1, 0001 The Training Kit videos for SQL Server 2012 are available at http://social.technet.micro... ... SQL Server 2012 Training Kit 0 0 0
Import Bacpac into SQL Azure using Code executed from the cloud SeanBarlow, January 1, 0001 0 0 1 437 2494 Simple Toad 20 5 2926 14.0 Normal 0 false false false EN-US JA X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; ... Import Bacpac into SQL Azure using Code executed from the cloud 0 0 1
SSIS 2012: How to Share Cache Among Multiple Packages Compudicted, January 1, 0001 Prior to SSIS 2012 it was not possible to re-use or share the same cache across packages. What that meant is if you created a cache you will be able to consume it only in the very package where the cache ... SSIS 2012: How to Share Cache Among Multiple Packages 0 0 2
Extract substrings starting with known text from long lines Michael Freidgeim, January 1, 0001 I’ve received a .csv report from TripWire logs, where each entry is a long text strings.I needed to extract some substring from each row, e.g “ErrorCode: ABC1234” where preceding text is constant, but ... Extract substrings starting with known text from long lines 0 0 0
Database Hardware CPU Licensing vs Performance and Fast Track Dat... Kevin Shyr, January 1, 0001 This is just one of those cool post which are not written as often as it should be. Hats off to Glenn Berry for stating it so clearly for all BI / database developers.http://sqlserver... ... Database Hardware CPU Licensing vs Performance and Fast Track Dat... 0 0 0
Using Redgate ANTS Performance Profiler to guide optimization Kyle Burns, January 1, 0001 With as often as I write code that does not perform as well as I would like for it to, I can’t believe how hard it is to write slow code on purpose! My last post gave a mile-high overview of the new version ... Using Redgate ANTS Performance Profiler to guide optimization 0 0 1
Microsoft Press Ebook Deal of the Day - 7/March/2012 TATWORTH, January 1, 0001 Today's Microsoft Press Ebook Deal of the Day at http://shop.oreilly.com/cat... is 50% off a series of E-books ... Microsoft Press Ebook Deal of the Day - 7/March/2012 0 0 0
Ways to search for column name, table name, or stored procedure t... Kevin Shyr, January 1, 0001 This is nothing new, just a way for me to organize the information better. Personally, I like the first 2 ways better just because I can order the result set any way I want.USE {Database Name}GO-- SQL ... Ways to search for column name, table name, or stored procedure t... 0 0 0
Top 10+ SSIS 2012 Improvements Compudicted, January 1, 0001 If you have not heard the latest technical news yet, the SQL Server 2012 Virtual Launch event is today March 8, 2012! Register to not to miss this opportunity to interact with technology experts and win ... Top 10+ SSIS 2012 Improvements 0 0 16
Move a SQL Azure Server From One Subscription to Another ScottKlein, January 1, 0001 It is now possible to move your SQL Azure server from one subscription to another. Last week, the Windows Azure team added this new feature to the Windows Azure Management Portal. Permissions for moving ... Move a SQL Azure Server From One Subscription to Another 0 0 0
The Most Epic MVP Attendee Party EVAR in Three Acts! D'Arcy Lussier, January 1, 0001 Last week was the Microsoft MVP Global Summit, where Microsoft brings together their independent experts and community leaders for a week of sessions, product group interactions, and some fun along the ... The Most Epic MVP Attendee Party EVAR in Three Acts! 0 0 1
Creating a Custom SSIS Data Flow Component - an Example With a Pu... Compudicted, January 1, 0001 Last week I was asked to mask or obfuscate a large volume of data residing in a production database for our software quality assurance team to use in testing some functionality. The data resided in various ... Creating a Custom SSIS Data Flow Component - an Example With a Pu... 0 0 3
Entity Framework 4.1 Code First- Use MSSQLSERVER instead of EXPRE... MagnusKarlsson, January 1, 0001 This is my first blog post and will be short and concise. I will get back to formatting later.Edit: Here is the same explanation but from MSDN :)http://blogs.msdn.com/b/a... ... Entity Framework 4.1 Code First- Use MSSQLSERVER instead of EXPRE... 0 0 0
SQL Server... help! Alex Bransky, January 1, 0001 I have two Great Plains databases, let's call them DB1A and DB1B, that are schematically identical and the data is 99% identical but DB1B has a tiny bit more data. I'm trying to optimize a very complex ... SQL Server... help! 0 0 4
How to get a Product() (multiplication result) rather than a SUM(... ChrisD, January 1, 0001 Get a summary aggregation of rows in T-Sql is easy thanks to the Sum operator: Select Sum(Qty) From Table Why is there no Product() aggregation operation for T-Sql? Sometimes I want the values multiplied, ... How to get a Product() (multiplication result) rather than a SUM(... 0 0 1
Startup Weekend in Boston - Peoples Choice Award SeanBarlow, January 1, 0001 This weekend I was in Boston participating in Startup Weekend. There were over 150 people participating this weekend. This was my first startup weekend and their were over 70 ideas pitched on friday night. ... Startup Weekend in Boston - Peoples Choice Award 0 0 1
Choosing A Windows Based Web Hosting Service Tim Murphy, January 1, 0001 Recently I have gone through the process of selecting a web hosting company for one of my clients. There are a lot of options out there and a number things you need to be cautious about. I will go over ... Choosing A Windows Based Web Hosting Service 0 0 0
BizTalk 2010 EDI batching–using an external release trigger Bill Osuch, January 1, 0001 In an earlier post I showed you how to implement basic EDI batching, releasing the batch every time 3 messages were waiting. In the real world, you’re probably going to have some other criteria for releasing ... BizTalk 2010 EDI batching–using an external release trigger 0 0 0
Building a Northwind Single Page Application using ASP.NET MVC 4 ... Harish Ranganathan, January 1, 0001 This post is in continuation with my earlier post, so you may want to read that first before continuing. Once I removed all the TasksController files and the TodoItem, I chose the Models folder, right ... Building a Northwind Single Page Application using ASP.NET MVC 4 ... 0 0 43
Building a Northwind Single Page Application using ASP.NET MVC 4 ... Harish Ranganathan, January 1, 0001 Single Page Application Frameworks are gaining popularity in the ever evolving web community with lot of libraries such as JavaScriptMVC, Backbonejs and many other libraries. ASP.NET MVC 4 introduces experimental ... Building a Northwind Single Page Application using ASP.NET MVC 4 ... 0 0 35
Query Performance Logging with MiniProfiler mknapp, January 1, 0001 I have started to experiment with MiniProfiler to log our query performance. We currently use a mix of pure SQL and Entity Framework, since we need Fulltext search some pure SQL is unavoidable. Depending ... Query Performance Logging with MiniProfiler 0 0 0
Nivo Slider In SharePoint 2010!?! juanlarios, January 1, 0001 A little while ago I was part of architecting and leading a project and one of my very talented ex-coworker was in charge of doing most of the branding. He incorporated the Nivo Slider as part of the rotating ... Nivo Slider In SharePoint 2010!?! 0 0 7
Developing BizTalk Server 2010 solution for integrating with Peop... Vishal, January 1, 0001 In this post we will see few of the initial steps for developing BizTalk Solutions for integrating with PeopleSoft Enterprise Systems using PeopleSoft Adapter. In order to proceed further, you must have ... Developing BizTalk Server 2010 solution for integrating with Peop... 0 0 2
Full Version of AdventureWorks database for SQL Azure and and SQL... ScottKlein, January 1, 0001 Some Background The AdventureWorks database has been around for over a decade; a staple amongst sample databases. The first version of the AdventureWorks database appeared in time for SQL Server 2000. ... Full Version of AdventureWorks database for SQL Azure and and SQL... 0 0 1
REDUCED SQL Azure Pricing! ScottKlein, January 1, 0001 You asked for it, you got it! To help meet the needs of existing and future SQL Azure customers, Microsoft has announced that they are lowering the price of SQL Azure, and as well introducing a 100MB database ... REDUCED SQL Azure Pricing! 0 0 0
2012 Exciting Year in Microsoft Space D'Arcy Lussier, January 1, 0001 We’re only in February, but the rest of the 10 months left in 2012 look to be very interesting in the Microsoft space with products that Developers and IT Pros will find intriguing. Redmond Channel Partner ... 2012 Exciting Year in Microsoft Space 0 0 0