Passing the CAML thru the EY of the NEEDL PointsToShare, January 1, 0001 © 2011 By: Dov Trietsch. All rights reserved Passing the CAML thru the EY of the NEEDL Definitions: CAML (Collaborative Application Markup Language) is an XML based markup language used in Microsoft SharePoint ... Passing the CAML thru the EY of the NEEDL 0 0 0
Finding a person in the forest PointsToShare, January 1, 0001 © 2011 By: Dov Trietsch. All rights reserved finding a person in the forest or Limiting the AD result in SharePoint People Picker There are times when we need to limit the SharePoint audience of certain ... Finding a person in the forest 0 0 0
Time Warp Jesse Taber, January 1, 0001 This blog post has moved:http://gruffcode.com/2011/11/15/time-warp/ Time Warp 0 0 0
Guide to reduce TFS database growth using the Test Attachment Cle... terje, January 1, 0001 UPDATED March 24th 2016: Test Data Retention is now added to TFS 2015 Update 1, see this post for more information.UPDATED Apr 15th 2013: Corrected to VS2012 Update 2 UPDATED Mar 23rd 2012: Added information ... Guide to reduce TFS database growth using the Test Attachment Cle... 0 0 10
XPath & XML EDI B2B PearlFactory, January 1, 0001 GoodToGo :) Best XML Editor is Altova XMLSpy 2011 http://www.torrenthound.com... ... XPath & XML EDI B2B 0 0 0
Free eBook "Troubleshooting SQL Server: A Guide for the Accidenta... TATWORTH, January 1, 0001 "SQL Server-related performance problems come up regularly and diagnosing and solving them can be difficult and time consuming. Read SQL Server MVP Jonathan Kehayias’ Troubleshooting SQL Server: A Guide ... Free eBook "Troubleshooting SQL Server: A Guide for the Accidenta... 0 0 7
Load and Web Performance Testing using Visual Studio Ultimate 201... Tarun Arora, January 1, 0001 Welcome back, in part 1 of Load and Web Performance Testing using Visual Studio 2010 I talked about why Performance Testing the application is important, the test tools available in Visual Studio Ultimate ... Load and Web Performance Testing using Visual Studio Ultimate 201... 0 0 2
Windows Azure AppFabric: ServiceBus Queue WPF Sample xamlnotes, January 1, 0001 The latest version of the AppFabric ServiceBus now has support for queues and topics. Today I will show you a bit about using queues and also talk about some of the best practices in using them. If you ... Windows Azure AppFabric: ServiceBus Queue WPF Sample 0 0 1
How do I fix the error: CS1548: Cryptographic failure while signi... Paula DiTallo, January 1, 0001 The full error in Microsoft Visual Studio on a compile looks like this: error CS1548: Cryptographic failure while signing assembly 'C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Programmability\AM... ... How do I fix the error: CS1548: Cryptographic failure while signi... 0 0 0
Testing Entity Framework applications, pt. 3: NDbUnit Thomas Weller, January 1, 0001 This is the third of a three part series that deals with the issue of faking test data in the context of a legacy app that was built with Microsoft's Entity Framework (EF) on top of an MS SQL Server database ... Testing Entity Framework applications, pt. 3: NDbUnit 0 0 2
SQL Server-Determine which query is taking a long time to complet... Neil Smith, January 1, 0001 Cool little trick to determine which sql query which is taking a long time to execute, first while offending query is running from another machine do EXEC sp_who2 Locate the SPID responsible via Login, ... SQL Server-Determine which query is taking a long time to complet... 0 0 0
Silverlight Cream for November 08, 2011 -- #1165 Dave Campbell, January 1, 0001 In this Issue: Brian Noyes, Michael Crump, WindowsPhoneGeek, Erno de Weerd, Jesse Liberty, Derik Whittaker, Sumit Dutta, Asim Sajjad, Dhananjay Kumar, Kunal Chowdhury, and Beth Massi. Above the Fold: Silverlight: ... Silverlight Cream for November 08, 2011 -- #1165 0 0 0
Books to learn Any Technology veera, January 1, 0001 Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; ... Books to learn Any Technology 0 0 0
Testing Entity Framework applications, pt. 2: Typemock Thomas Weller, January 1, 0001 This is the second of a three part series that deals with the issue of faking test data in the context of a legacy app that was built with Microsoft's Entity Framework (EF) on top of an MS SQL Server database ... Testing Entity Framework applications, pt. 2: Typemock 0 0 9
SQL Server Denali CTP 3 - Dockable Windows! MikeParks, January 1, 0001 The future of SQL Server Management Studio looks pretty promising. I downloaded SQL Server Denali CTP 3 the other day and was really happy to see that they've finally implemented dockable windows. I always ... SQL Server Denali CTP 3 - Dockable Windows! 0 0 1
Testing Entity Framework applications, pt. 1 Thomas Weller, January 1, 0001 For good or bad, Microsoft’s Entity Framework (EF) has become one of the most widely used ORM tools out there. While some may state that it's not among the better ones (or that it's not even a real ORM), ... Testing Entity Framework applications, pt. 1 0 0 2
BDD and BizUnit 2 – Not as cool as combining BizUnit 4 & SpecFlow... Michael Stephenson, January 1, 0001 I've been back working with BizTalk 2006 R2 for a customer recently and I've become such a fan of the BDD style acceptance tests I've done in the past with BizTalk 2010 that its quite frustrating working ... BDD and BizUnit 2 – Not as cool as combining BizUnit 4 & SpecFlow... 0 0 1
Azure: Fault Tolerance for apps xamlnotes, January 1, 0001 Check out the Fault Tolerance Framework: http://windowsazurecat.com/... This is really sweet. You can download the source code, then open it in VS and build it. ... Azure: Fault Tolerance for apps 0 0 0
Using Table Valued Parameters Bunch, January 1, 0001 In SQL Server 2008 you can use table valued parameters which can be pretty useful. In the example I use a very simple one to overcome SQL Server’s lack of having a parameter as an array. The example goes ... Using Table Valued Parameters 0 0 2
How do I remove a named instance of sql server 2008 on the same m... Paula DiTallo, January 1, 0001 Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; ... How do I remove a named instance of sql server 2008 on the same m... 0 0 5
Join vs Sub Query DevJef, January 1, 0001 If you work with SQL Server you will eventually encounter a JOIN statement. This JOIN statement can be stated as an ordinary JOIN, or as a sub select. In most cases I try to use JOINS (even though it’s ... Join vs Sub Query 0 0 1
Custom assemblies for Reporting Services jkrebsbach, January 1, 0001 With SSRS we can quickly generate reports that can be exported to multiple formats. What happens when you want to extend your report with custom code? Friday November 11th 2011 (this Veteran's Day) I'll ... Custom assemblies for Reporting Services 0 0 1
How do I create and access another sql server db using linked ser... Paula DiTallo, January 1, 0001 For a full explanation and step-by-step guide to setup a linked server through Sql Management Studio (SMS), check out this reference: http://www.databasejournal.... ... How do I create and access another sql server db using linked ser... 0 0 0
SQL Injection Attack - some further information TATWORTH, January 1, 0001 At http://www.darkreading.com/... you will find details of the mass SQL Injection Attacks that have ... SQL Injection Attack - some further information 0 0 0
Sharing session state between Classic ASP and ASP.NET TATWORTH, January 1, 0001 On CodePlex there is a new project at http://nsession.codeplex.com for sharing session state between classic ASP and ASP.NET "The objective of this project is to allow ASP Classic to access ASP.NET out-of-process ... Sharing session state between Classic ASP and ASP.NET 0 0 0
Installing the AdventureWorks OLAP Sample Database Enrique Lima, January 1, 0001 Once the installer for the AdventureWorks Community Sample Database has finished, we then need to complete the process (not mandatory, but nice to do to play with the OLAP content). The first thing we ... Installing the AdventureWorks OLAP Sample Database 0 0 1
Installing the AdventureWorks Community Sample Database content Enrique Lima, January 1, 0001 For a while now, if we have been around SQL Server we got used to the different sample databases that were provided. From Pubs to Northwind to AdventureWorks. In order to get the AdventureWorks samples ... Installing the AdventureWorks Community Sample Database content 0 0 0
How to Detect If You Are Connected To A Federation Root Herve Roggero, January 1, 0001 If you develop applications in SQL Azure, you may end up in a situation where your code needs to know if it is operating in the root database or in a Federation Member, or if it is connected to a regular ... How to Detect If You Are Connected To A Federation Root 0 0 0
SSIS design consideration Kevin Shyr, January 1, 0001 The following is my experience with SSIS building: Make sure you understand the 3 modes of Lookup. General, I would only do full cache if the lookup table only return less than 200 rows Never use the table ... SSIS design consideration 0 0 0
CLR Sprocs Deployment xamlnotes, January 1, 0001 Today I was working on hooking up some CLR sprocs in SQL Server. My friend Greg Low (SolidQ Australia) pointed out that even vb clr sprocs are case sensitive. I loaded an assembly like so: CREATE ASSEMBLY ... CLR Sprocs Deployment 0 0 2
Create XMLA file for OLAP Cubes DevJef, January 1, 0001 In order to refresh your OLAP Cubes (SQL Server Analysis Services), you need to create XMLA files. These XMLA files can be used in a SQL Server Agent Job, so that the Cubes are refreshed and re-processed. ... Create XMLA file for OLAP Cubes 0 0 0
T-Sql - rename a table or column name via stored procedure Renso, January 1, 0001 Goal: Rename a database table or column name using a t-sql stored procedure. How to: Rename a table: EXEC sp_rename 'TableToBeRename', 'NewTableName' Rename a column: EXEC sp_rename @objname = 'TableNameColumnToBeRenamed, ... T-Sql - rename a table or column name via stored procedure 0 0 1
SQL Injection Attacks Continue - 1,000,000+ pages affected TATWORTH, January 1, 0001 At http://www.darkreading.com/... there is a disturbing report on the extent of SQL injection attacks. ... SQL Injection Attacks Continue - 1,000,000+ pages affected 0 0 0
DropkicK–Deploy Fluently Robz / Fervent Coder, January 1, 0001 DropkicK (DK) has been in development for over two years and has been used for production deployments for over a year. Dru Sellers originally posted about DK back in 2009. While DK isn’t yet as super easy ... DropkicK–Deploy Fluently 0 0 0
SSRS Multi-Data Source DPE (Data Processing Extension) jkrebsbach, January 1, 0001 SSRS is a wonderful tool for quickly retrieving data from many different data sources and presenting the data to the user at a run-time decided format. One area where SSRS often falls short is when the ... SSRS Multi-Data Source DPE (Data Processing Extension) 0 0 0
RoundhousE–Intelligent Database Migrations And Versioning Robz / Fervent Coder, January 1, 0001 “Because everyone wants to kick their database, but sometimes kicking your database is a good thing!” Many would not argue that you should version your code, and few would argue against versioning your ... RoundhousE–Intelligent Database Migrations And Versioning 0 0 2
Count records in all database tables DevJef, January 1, 0001 Every ones in a while you want to know the record count of all objects in your database. If you have 10 objects or less in your database, you can choose to type out the statements yourself, but once it’s ... Count records in all database tables 0 0 0
Using SQL Server to Get the Column Names and Corresponding Dataty... ChrisD, January 1, 0001 Here I will explain how to get the column names and corresponding datatypes in particular table using SQL Server. Description: I have one table with lot columns in database at that time I tried to know ... Using SQL Server to Get the Column Names and Corresponding Dataty... 0 0 0
PRINT Ints in TSQL Bunch, January 1, 0001 To print multiple int variables on one line you need to CAST them first. Otherwise the PRINT command will add them up (at least it does for me anyways using SQL 2008). In the example I needed to have two ... PRINT Ints in TSQL 0 0 0
SQL Server source control DevJef, January 1, 0001 For (almost) all developers, there’s no greater feeling, then knowing your source code is (relatively) safe. The same counts for T-SQL script. Especially if you know that you need the same code next year ... SQL Server source control 0 0 0
BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple ... Stuart Brierley, January 1, 0001 BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls A recent project that I was working on required that I take an incoming flat file, containing multiple transaction ... BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple ... 0 0 8
Deployed Azure ValidateUser failing LEV, January 1, 0001 I have been developing an MVC3 application with the intention of deploying to the Cloud. It was configured to use Forms Authentication with SQL Membership on SQL Azure. Everything seemed to be working ... Deployed Azure ValidateUser failing 0 0 0
Extended properties of database objects DevJef, January 1, 0001 When you work with SQL Server, you regularly want to know when an object is last executed, last modified, etc.. Well, at least I do! In most cases you need to use the sys.objects to obtain this information, ... Extended properties of database objects 0 0 0
How to Deploy Your ASP.NET MVC 3 with SQL CE 4.0 & Entity Framewo... ChrisD, January 1, 0001 If you are planning to deploy your application with SQL CE as your application backend then here are the steps you need to perform. If you’re planning to deploy your application with SQL Server, than please ... How to Deploy Your ASP.NET MVC 3 with SQL CE 4.0 & Entity Framewo... 0 0 0
Putting the “BI” in Big Data andrewbrust, January 1, 0001 Last week, at the PASS (Professional Association for SQL Server) Summit in Seattle, Microsoft held a coming out party, not only for SQL Server 2012 (formerly “Denali”), but also for the company’s “Big ... Putting the “BI” in Big Data 0 0 3
Query order of execution DevJef, January 1, 0001 If you write a SQL query, it’s important to know when certain pieces of you query are executed. For example, it’s possible that some statement in your query interferes with another part of your query, ... Query order of execution 0 0 1
How to Fix error 28 - Server doesn't support requested protocol ChrisD, January 1, 0001 Yesterday, I just posted about How to Fix error: 26 - Error Locating Server/Instance Specified Well, this is an error message that we can find too "An error has occurred while establishing a connection ... How to Fix error 28 - Server doesn't support requested protocol 0 0 0
Enzo Backup for SQL Azure Released! ScottKlein, January 1, 0001 Blue Syntax is pleased, and very excited, to announce the general availability of Enzo Backup for SQL Azure. It took a monumental effort to put this product together. The hardest part was designing the ... Enzo Backup for SQL Azure Released! 0 0 0
How to Fix error: 26 - Error Locating Server/Instance Specified ChrisD, January 1, 0001 This is an error message that we can find when we connect to SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or ... How to Fix error: 26 - Error Locating Server/Instance Specified 0 0 0
SSAS, MPP and PDW James Rogers, January 1, 0001 I cut my DBA teeth on IBM's DB2 UDB EEE (enough acronyms) back in the 90's. I have always appreciated the scalability that is available with a MPP architecture. So a couple of years ago I was excited to ... SSAS, MPP and PDW 0 0 2