New Release of SQL Azure Shaun, January 1, 0001 On the 9th Sep, the SQL Azure team announced that the new version of SQL Azure had just been release. In this version not only the SQL Azure engine had been upgraded, the SQL Azure Management Portal had ... New Release of SQL Azure 0 0 0
Silverlight Cream for September 09, 2011 -- #1145 Dave Campbell, January 1, 0001 In this Issue: Kunal Chowdhury, David Anson, Cheryl Simmons, Ryan Alford, Peter Kuhn, Ollie Riches, Mike Hole, Allen Lee, WindowsPhoneGeek, Mike Taulty, Sumit Dutta, Asim Sajjad, Dhananjay Kumar, and Vikram ... Silverlight Cream for September 09, 2011 -- #1145 0 0 0
Silverlight Cream for September 08, 2011 -- #1144 Dave Campbell, January 1, 0001 In this Issue: Ollie Riches, Tony Champion, Kunal Chowdhury, WindowsPhoneGeek, Jeremy Likness, Mike Taulty, Jesse Liberty, Sumit Dutta, Asim Sajjad, Justin Angel, and Shawn Wildermuth(-2-). Above the Fold: ... Silverlight Cream for September 08, 2011 -- #1144 0 0 0
Calculate distance between two latitude/longitude points in SQL Bill Osuch, January 1, 0001 I'm working on a mobile location search app, and needed a way to find addresses within a certain radius of the device's current position. A little Googling found a simple function that will return the ... Calculate distance between two latitude/longitude points in SQL 0 0 3
Reading Registry value using T-SQL kazim sardar mehdi, January 1, 0001 DECLARE @RegLoc VARCHAR(100) select @RegLoc='SOFTWARE\Microsoft... NT\CurrentVersion' EXEC [master].[dbo].[xp_regread] @rootkey='HKEY_LOCAL_MACHINE', @key=@RegLoc, @value_name='ProductName' The above ... Reading Registry value using T-SQL 0 0 1
Sharding Library for SQL Azure Data Federation Herve Roggero, January 1, 0001 The ability to write scale out applications for SQL Azure will soon become much easier, thanks to the upcoming SQL Azure Data Federation capabilities. In an earlier post, I outlined specific steps developers ... Sharding Library for SQL Azure Data Federation 0 0 0
Least Priviledge Access to the Database TATWORTH, January 1, 0001 On SQL Server Central there is a very good article at http://www.sqlservercentral... on least priviledge access ... Least Priviledge Access to the Database 0 0 1
Spotlight (R) on Azure: Cool Tool Herve Roggero, January 1, 0001 While testing the performance characteristics of the SQL Azure backup tool I am building (called Enzo Backup for SQL Azure), I decided to try Spotlight (R) on Azure in order to obtain specific performance ... Spotlight (R) on Azure: Cool Tool 0 0 2
Temp table in strongly typed stored procedure not supported by WC... Edmund Zhao, January 1, 0001 If your orchestration is heavily rely on WCF SQL adapter based on SQL stored procedures, you may often encounter an issue related to strongly-typed schema and receive an error which is similar to the following. ... Temp table in strongly typed stored procedure not supported by WC... 0 0 4
More Cheat-Sheets (and some for SQL Injection Attack!) TATWORTH, January 1, 0001 At http://devcheatsheet.com/ there is a comprehensive list of cheat sheets. Of particular note are: http://devcheatsheet.com/ta... SQL Injection! http://devcheatsheet.com/ta... ReSharper ... More Cheat-Sheets (and some for SQL Injection Attack!) 0 0 0
Silverlight Cream for September 03, 2011 -- #1141 Dave Campbell, January 1, 0001 In this Issue: Tony Champion, Kevin Hoffman, Pete Brown(-2-), Mike Gold, Jeremy Likness, Xpert360, Den Delimarsky, Sumit Dutta, Asim Sajjad, Vikram Pendse, and Michael Crump. Above the Fold: Silverlight: ... Silverlight Cream for September 03, 2011 -- #1141 0 0 0
Another SQL Injection attack TATWORTH, January 1, 0001 At http://www.bbc.co.uk/news/t... there is a report on yet another SQL Injection attack. This time it is Nokiia's Developer network. How many other systems are vulnerable to such attack? ... Another SQL Injection attack 0 0 0
Embrace Problems – They Will Lead You to Knowledge jboyer, January 1, 0001 If you are a developer, you will encounter countless problems in your career. As a developer, problem solving is what you do. Still, some may try to shy away from problems in order to make their lives ... Embrace Problems – They Will Lead You to Knowledge 0 0 0
Extracting a SQL CE DB from Isolated Storage in WP7 Mango. mbcrump, January 1, 0001 Introduction By now, most of you have heard that Windows Phone 7 – Mango release will support Local Databases (SQL CE) using Linq to SQL. But what you probably haven’t heard much about is how to extract ... Extracting a SQL CE DB from Isolated Storage in WP7 Mango. 0 0 1
Red Gate | SQL Compare Review Jeff Julian, January 1, 0001 To start, I love Red Gate Software’s Tools. I have loved them since the first time I started using SQL Backup and SQL Compare when I first started Geekswithblogs.net. I think they create quality products ... Red Gate | SQL Compare Review 0 0 3
Entity Framework - My Code First Expirience Silverlight, January 1, 0001 Recently I used Entity Framework 4.1 with Code First approach and step on a hidden rake. My application should create an SQL Server CE database file using supplied model classes. I created some model classes, ... Entity Framework - My Code First Expirience 0 0 0
SQL Server: UPDATE Statement Basics Paula DiTallo, January 1, 0001 The last thing anyone wants to do is mess up an UPDATE statement! Here's a quick refresher for those of you using SQL Server: Simplest case (a single row, in a single table with a single known value in ... SQL Server: UPDATE Statement Basics 0 0 0
SQL Server: How Can I search for a specific text value in all the... Paula DiTallo, January 1, 0001 To quickly look through your stored procedure objects for a text value in a database instance, do the following: use [Metro] go SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION ... SQL Server: How Can I search for a specific text value in all the... 0 0 1
SmartAssembly 6.1 Review Michael B. McLaughlin, January 1, 0001 It’s been quite a while since I’ve done a GeeksWithBlogs.net Influencers review. This time, I had the opportunity to check out Red Gate’s SmartAssembly 6.1, which is a integrated collection of tools for ... SmartAssembly 6.1 Review 0 0 0
This blog is moving to ericnelson.wordpress.com Eric Nelson, January 1, 0001 Apologies in advance for any problems caused as I move over to http://ericnelson.wordpress... over the next few days. I will blog again on here when the move is fully complete. I have had a superb time ... This blog is moving to ericnelson.wordpress.com 0 0 0
SQL Server Backup, Integrity Check, Index and Statistics Maintena... DBA, January 1, 0001 Please vote for Ola Hallengren, in my opinion he has the best maintenance scripts, and best of all “THERE FREE!”. You can check out his scripts and well as the link to vote from this page SQL Server Backup, ... SQL Server Backup, Integrity Check, Index and Statistics Maintena... 0 0 0
Multi-tenant WCF Services Nilesh, January 1, 0001 Requirement was to create Multi-tenant WCF Service for custom development using WCF and Dynamics CRM 2011. There is just one SVC file but multiple URLs to access it e.g. in Dyanamics Organization Org1 ... Multi-tenant WCF Services 0 0 3
Using stored procedures with NHibernate Lukasz Kurylo, January 1, 0001 NHibernate has many ways to create and executes queries. With one of them* - the Named Queries we can execute our manually created stored procedures. This example is dedicated to SQL Server. This is important ... Using stored procedures with NHibernate 0 0 1
Aliasing the data returned as xml Lukasz Kurylo, January 1, 0001 I just wanted to return from sql server data as xml. This is very easy to do, because sql server has a build-in suppot for that. select Id, Name from Extensions FOR XML RAW('Extension'), ROOT('Extensions') ... Aliasing the data returned as xml 0 0 0
Giving feedback on SQL Server “Denali” CTP3 and SQL A... Eric Nelson, January 1, 0001 SQL Server “Denali” is at CTP3 – and would therefore very much welcome feedback. SQL Azure continues an aggressive cycle of release - and would therefore very much welcome feedback. Which is why we have ... Giving feedback on SQL Server “Denali” CTP3 and SQL A... 0 0 0
Product Review - ComponentOne Studio for MVC Wijmo Vincent Maverick Durano, January 1, 0001 Wijmo is an awesome tool from ComponentOne. The goal of this tool is to help us web developers rapidly develop MVC applications with interfaces richer than WebForms. Main Features: 1.Over 30 UI Widgets ... Product Review - ComponentOne Studio for MVC Wijmo 0 0 2
Dynamic Library Loading Chris Gardner, January 1, 0001 Microsoft keeps telling us that we should create interfaces for everything and program to them. This is all fine and dandy, but this can become a nightmare when dealing with dynamically loaded libraries. ... Dynamic Library Loading 0 0 0
XmlDocument.CreateAttribute has some strange quirks Chris Gardner, January 1, 0001 Recently, I dove, headfirst, into a heaping batch of XML. I decided that I needed to create a custom schema for XML data. At minimum, I should require my XML database to enforce the same things as my SQL ... XmlDocument.CreateAttribute has some strange quirks 0 0 0
MSDN vs. TechNet Mark Treadwell, January 1, 0001 For a period of time, I have access to both an MSDN and a TechNet subscription. Both offer Microsoft software for download. I wondered what the similarities and differences were between the two subscriptions. ... MSDN vs. TechNet 0 0 6
EF4.1 Code First and the ASP.Net Membership Service Jon Egerton, January 1, 0001 I'm setting up a new site, and trying out the EF4.1 Code First method. One thing that occurred to me was the using the Entity Initializers to regenerate the DB leads to the asp_net membership tables (and ... EF4.1 Code First and the ASP.Net Membership Service 0 0 0
Using NHibernate with xml column Lukasz Kurylo, January 1, 0001 I have a simple database table with only id and one xml column as shown below. In this column I have a list of available extensions saved as xml. public class FileExtensionsList { public FileExtensionsList() ... Using NHibernate with xml column 0 0 2
Annual SQL Server Connectivity Survey – live until 9th Sept... Eric Nelson, January 1, 0001 The Microsoft SQL Server team has been interacting on a regular basis with developers and users in the form of surveys. If you have 15mins spare and would like to do your bit to help shape the roadmap ... Annual SQL Server Connectivity Survey – live until 9th Sept... 0 0 0
FREE One Day Windows Azure Discovery Workshops for product author... Eric Nelson, January 1, 0001 In September we will start to deliver monthly workshops on the Windows Azure Platform to help Microsoft partners who are developing software products and services and would like to explore the relevance ... FREE One Day Windows Azure Discovery Workshops for product author... 0 0 0
SharePoint 2010 MY Links without My Sites David Jacobus, January 1, 0001 I have a client that desired to have the MOSS 2007 capability of My Links but in no way wanted My Sites in SharePoint 2010. I took some steps that gave them the capability of My Links by creating a personalized ... SharePoint 2010 MY Links without My Sites 0 0 1
SQL Injection Attack on a PHP system! TATWORTH, January 1, 0001 There is a misunderstanding about SQL Injection attack in that some people think that that is is restricted to Microsoft. Here is a case where it happened on a PHP system. see http://www.securityfocus.co... ... SQL Injection Attack on a PHP system! 0 0 0
The Database Party TATWORTH, January 1, 0001 The origin of the following is now lost in the mists of time but it bears repeating. A big party is being held to honor relational database systems & their impact on the modern society. Outside the ... The Database Party 0 0 0
Altering or extending the definition of implicitly named Check co... pankajsharma, January 1, 0001 Recently i caught in a peculiar situation where i need to modify the check constraint expression to include more criteria to be validated through T-SQL. Although there is no declarative command or mechnism ... Altering or extending the definition of implicitly named Check co... 0 0 0
Turn WCF REST Protocol Exception into MVC ModelError James Fleming, January 1, 0001 If you've found this blog posting, you've probably been banging your head against a wall trying to get those errors generated from your web service to appear in your MVC web site. You may have already ... Turn WCF REST Protocol Exception into MVC ModelError 0 0 0
"Argument CompositeOperation is invalid" error Edmund Zhao, January 1, 0001 Performing Composite Operations on Oracle Database is very similar to SQL Server Database. I just want to point out one mistake developers might easily make during the send port configuration. For any ... "Argument CompositeOperation is invalid" error 0 0 0
My Journey, so far JoshReuben, January 1, 0001 Everyone has a journey. You start off young & stupid, and 2 decades later, you're closer to understanding the nature of reality. That’s one of the main goals in life, to seek knowledge (justified, ... My Journey, so far 0 0 2
DDL 'IF not Exists" conditions to make SQL scripts re-runnable Michael Freidgeim, January 1, 0001 As a part of continuous integration we are using deployment of database scripts, which makes very important to make the scripts re-runnable. Some checks for DDL elements are not obvious, and I decided ... DDL 'IF not Exists" conditions to make SQL scripts re-runnable 0 0 0
Silverlight Cream for August 10, 2011 -- #1129 Dave Campbell, January 1, 0001 In this Issue: Morten Nielsen(-2-), Mike Gold, Jesse Liberty, Derik Whittaker, Den Delimarsky, Austin Andrews, and Oscar Agreda. Above the Fold: Silverlight: "Silverlight MVVM Code Smith Templates" Oscar ... Silverlight Cream for August 10, 2011 -- #1129 0 0 0
Entity Framework 4.1 Code-First Made Easy Sean Terry, January 1, 0001 No matter which ORM or data access technology you use, at some point you just need to do some CRUD, and you need to do it fast. In this post, I’m going to show you how to get your CRUD on with the latest ... Entity Framework 4.1 Code-First Made Easy 0 0 0
Silverlight Cream for August 09, 2011 -- #1128 Dave Campbell, January 1, 0001 In this Issue: Kunal Chowdhury, Beth Massi(-2-), Gill Cleeren, Rajat Jaiswal, Mike Taulty, Jesse Liberty, Derik Whittaker, Den Delimarsky, Austin Andrews, and Oscar Agreda. Above the Fold: Silverlight: ... Silverlight Cream for August 09, 2011 -- #1128 0 0 0
tsql: Counting unique elements in a sql server table xamlnotes, January 1, 0001 Today I wanted to count each unique element in a SQL Server table to make sure they were unique. Took a bit of playing but this finally works great: SELECT DISTINCT t.columntocheck, (Select COUNT(columntocheck) ... tsql: Counting unique elements in a sql server table 0 0 2
Silverlight Cream for August 08, 2011 -- #1127 Dave Campbell, January 1, 0001 In this Issue: Colin Eberhardt, Ollie Riches, Morten Nielsen(-2-), Mike Taulty, Den Delimarsky, Derik Whittaker, Oscar Agreda, Austin Andrews, Manas Patnaik, and Jesse Liberty(-2-). Above the Fold: Silverlight: ... Silverlight Cream for August 08, 2011 -- #1127 0 0 0
St. Louis Day of .NET Presentations Scott Kuhl, January 1, 0001 Had a great time again this year at St. Louis Day of .NET. Thanks to everyone who attended my sessions. Based on feedback it seems like I'll need to do a presentation on SQL Server Compact next year. Doesn't ... St. Louis Day of .NET Presentations 0 0 0
Deploying SYNC. Framework onto Azure Richard Jones, January 1, 0001 So in the process of going live on a mobile solution that uses Microsoft Sync. Framework, on Azure. I came across this really useful guide on how to package up the various elements of the Sync. Framework ... Deploying SYNC. Framework onto Azure 0 0 0
Silverlight Cream for August 07, 2011 - 2 -- #1126 Dave Campbell, January 1, 0001 In this Issue: Michael Washington, Pontus Wittenmark(-2-), Derik Whittaker, Peter Kuhn, Michael James, XamlNinja, Adam Kinney, Morten Nielsen(-2-), Alex Sorokoletov(-2-), and Den Delimarsky. Above the ... Silverlight Cream for August 07, 2011 - 2 -- #1126 0 0 0
Silverlight Cream for August 07, 2011 -- #1125 Dave Campbell, January 1, 0001 In this Issue: Kunal Chowdhury(-2-), Mike Talbot, Michael Washington, Davide Zordan, Pontus Wittenmark(-2-), WindowsPhoneGeek, Pete Brown, Dhananjay Kumar, Erno de Weerd, Jesse Liberty(-2-), Peter Torr, ... Silverlight Cream for August 07, 2011 -- #1125 0 0 0