Tag | SQL Posts

Today's $10 Deal of the day from Apress is Expert SQL Server 2008 Development "Focuses on sound development and architectural practices that will help you become a better developer, capable of designing high-performance, robust, maintainable database applications." www.apress.com/media/catalo... ...

At http://searchsecurity.techtarget.co.uk/tip/How-to-stop-SQL-injection-and-prevent-data-compromises there is a free download on measures to combat SQL Injection Attack. (free registration is required).

One very important thing to note is that SQL Injection Attack is not confined to IIS / SQL Server but has occurred on many non-Microsoft systems.

At http://peterkellner.net/200... there is a very useful article by my fellow MVP Peter Kellner. This shows that ADO.NET is very much faster than LINQ to SQL unless the latter is compiled. Whilst there may be some cases where Linq to SQL offers genuine benefits, however we should proceed with caution in using Linq unless it a some single use form of query. I suggest after reading Peter's post you leave a note of appreciation for ...
In my current job as a Senior ALM Consultant, part of what I do is help organizations get TFS set up and configured. While a single server installation is pretty easy (and using the basic configuration to install TFS on Windows 7 is even easier), there are a few pitfalls and points of frustration when setting TFS up in a two-server configuration. For the purposes of this discussion, I am assuming the following setup: - A database server (Data Tier) with SQL 2008 R2 to house the TFS Databases, Reporting ...
In this All-Submittal (but not all current submittals) Issue: Rod Falanga, Colin Eberhardt, and Kunal Chowdhury(-2-, -3-). Above the Fold: Silverlight/VS2010: "Creating Silverlight Application on network share : The Official Microsoft Silverlight Site" Rod Falanga WP7: "Windows Phone 7 (Mango) Tutorial - 22 - Local Database Support, Create DataContext" Kunal Chowdhury Just plain interesting:: "From Silverlight To HTML5" Colin Eberhardt Shoutouts: The SilverlightShow folks announced some training ...
Developers might write good code, but no matter how good they are the result will always have bugs in it. It's up to the testers in the team to make sure the final product is as bug-free as it can be. Deciding what to test Within a project there's normally no official documentation produced, no official record of what the project should accomplish. The closest thing we get to documentation is the greenlight presentation slides (I'll be covering the greenlight process in a later post). This means ...
Phoenix Silverlight User Group Meeting July 6 featuring Dave Campbell Come out to Interface Technical Training tomorrow (July 7, 2011) in Phoenix to see me struggle through explaining how to use Jeremy Likness' Sterling No SQL database in your Silverlight applications. As always, pizza and greet-up starts at 6PM, followed at 6:30 or whenever everybody rounds up by the meeting which runs until 8PM. If you're anywhere in the area, come on down... I use Sterling all day in an enterprise app, so hopefully ...
Today's $10 deal of the day at http://www.apress.com/info/... is Ultra-Fast ASP.NET: Building Ultra-Fast and Ultra-Scalable Websites Using ASP.NET and SQL Server by Richard Kessig - ISBN 978-1-4302-2383-2 I won a copy of this book at 101 Books. Richard Kessig is an all-star member of forums.asp.net - see http://forums.asp.net/membe... - this book has been on before as deal of the day. If you did not get a copy then, I suggest getting it today. " Ultra-Fast ASP.NET provides a practical ...
What’s the problem? Given a DB table with an Identity key in SQL Server, that field could not be repeated. Well, if you delete a row, the value would be lost. We are trying to reuse these values. Solution LINQ is something that I love, by that I will use it to solve the problem. To sumup the post, we are going to use a list of integer that will replace our entityset, with the following keys: 1,2,3,5,6,7,9,10,11,15. Well, how to get a jump in the list: 1: var query = from n in listado 2: where (n ...
One thing that’s really got me pumped about the Mango OS update is the inclusion of SQL Compact baked right in. We don’t need to include extra assemblies to get database functionality for our apps, as SQL Compact is a native component in Mango! Before we get all excited thinking we’ll have a full on visual designer experience when developing our apps, realize that this is still an isolate storage based data file that you’ll be using LINQ to SQL to access. There’s no visual designer (yet), which means ...
One of the things that I have really enjoyed in the process of working with SQL Azure is the SQL Azure Management options. Mind you, it does not have a built-in backup tool, yes there are other options. redgate SQL Azure Backup Currently, Red Gate has a SQL Azure Backup tool (since it is Beta, it is free for the time being). Obviously, in order to use the tool the network/ip address from which you will be connecting has to be enrolled into the Azure Firewall for your account. The first step … connect. ...
At http://content.usatoday.com... is a very disturbing article on SQL Injection Attacks and how they have been automated. This is very disturbing as it many that any public facing web site may be attacked. Anonymity is no protection (and never was). The bottom line no person or company may say that they are too insignificant to be attacked. So have you run FXCOP on your Dot net code? CA2100 catches ...
Last night, (Tuesday, June 28), at the KC .NET User group meeting, George Westwater gave a terrific presentation on NoSQL. The best way to define it (the best way is to see George explain it, and he says he will record his presentation and make it available through his blog – link above) is databases that does not use relational technology. And his point, and this is true – I have been around awhile – is that non-relational databases have been used for over 50 years in the business. He points out ...
In this Issue: WindowsPhoneGeek, John Papa, Mike Taulty, Erno de Weerd, Stephen Price, Chris Rouw, Peter Kuhn, Damian Schenkelman, Michael Washington, and Manas Patnaik. Above the Fold: Silverlight: "Binding to View Model properties in Data Templates. The RootBinding Markup Extension" Damian Schenkelman WP7: "Storing Files in SQL Server using WCF RIA Services and Silverlight – Part 3" Chris Rouw LightSwitch: "Saving Files To File System With LightSwitch (Uploading Files)" Michael Washington Shoutouts: ...
I have had some time this week to try out some tools that I have been meaning to try out. This week I am trying out the SP 2010 Diagnostic Studio. I installed it successfully and tried it on my development evironment. I was able to build a report and a snapshot of the environment. I decided to turn my attention to my Employer's intranet environment. This would allow me to analyze it and measure it against benchmarks. I didn't want to install the Diagnostic studio on the Production Envorinment, lucky ...
Blue Syntax is happy to announce the release of their SQL Azure database backup product! Enzo Backup for SQL Azure offers unparalleled backup and restored functionlity and flexibility of a SQL Azure database. You can download the beta release here: http://www.bluesyntax.net/b... With Enzo Backup for SQL Azure, you can: Create a backup blob, or a backup file from a SQL Azure database Restore a SQL Azure database from a backup blob, or a backup file Perform limited backup and restore of SQL ...
After reading DLinq (Linq to SQL) Performance and in particular Part 4 I had a few questions. If CompiledQuery.Compile gives so much benefits, why not to do it for all Linq To Sql queries? Is any essential disadvantages of compiling all select queries? What are conditions, when compiling makes whose performance, for how much percentage? World be good to have default on application config level or on DBML level to specify are all select queries to be compiled? And the same questions about Entity Framework ...
The Membership API came in .NET 2.0 and was a huge enhancement in building web applications with users, managing roles, permissions etc., The Membership API by default uses SQL Express and until Visual Studio 2008, it was available only through the ASP.NET Configuration manager screen (Website – ASP.NET Configuration) or (Project – ASP.NET Configuration) and for every application, one has to manually visit this place to start using the Security and other settings. Upon doing that the default SQL ...

Check out what Paul Randall discovered with DBCC CHECKDB with SQL 2005

In Recovery... | (Not a) CHECKDB error "Unable to deallocate a kept page"

When restoring a database backup, by default, SQL Server places the database files in the master database file directory. In this example, that location is in L:\MSSQL10.CHTL\MSSQL\DATA as shown by the issuance of sp_helpfile Hence, the restored files for the database CHTL_L2_DB are in the same directory Per SQL Server best practices, the log file should be on its own disk drive so that the database and log file can operate in a sequential manner and perform optimally. The steps to move the log file ...
One of the things that is keeping us busy is the Web Camps we are delivering across 5 cities. If you are a reader of this blog, and also attended one of these web camps, there is a good chance that you have seen me since I was there in all the places, so far. The topics that we cover include Visual Studio 2010 SP1, SQL CE, ASP.NET MVC & HTML5. Whenever I talk about SQL CE, the immediate response is that, people are wow that Microsoft has shipped a FREE compact edition database, which is an embedded ...
It should be of concern to all developers that SQL Injection attacks are still occurring. Here are some resources on the subject: http://www.darkreading.com/... (needs free registration) http://en.wikipedia.org/wik... http://www.unixwiz.net/tech... http://msdn.microsoft.com/e... http://www.sitepoint.com/sq... And for a funny view on it see http://xkcd.com/327/ So what are you doing to ...
The other day at work I came across a handy little block of SQL code from Jeremiah Clark's blog. It's pretty simple logic but through the mind of a C# developer making some quick DB updates, seems to me that it's more likely to end up writing out the code in Solution 1 instead of Solution 2 below to solve the problem. Basically, I needed to check and see if a specific record existed in Table1. If it does exist, then update that record, otherwise insert a new record into Table1. Solution 1: IF EXISTS ...
In this Issue: René Schulte, Rajat Jaiswal(-2-), Peter Kuhn, Colin Eberhardt, Kunal Chowdhury(-2-), Beth Massi, Michael Crump, Daniel Vaughan, Chris Rouw, WindowsPhoneGeek, and Jesse Liberty. Above the Fold: Silverlight: "Cubelicious - Silverlight 5 + Balder + Physics + SLARToolkit Augmented Reality = Triple Win!" René Schulte WP7: "Binding the WP7 ProgressIndicator in XAML" Daniel Vaughan LightSwitch: "Adding Static Images and Text on a LightSwitch Screen" Beth Massi Shoutouts: Laurent Bugnion is ...
The vast majority of Red Gate is on the first and second floors (the second and third floors in US parlance) of an office building in Cambridge Business Park (here we are!). As you can see, the building is split into three sections; the two wings, and the section between them. As well as being organisationally separate, the four divisions are also split up in the office; each division has it's own floor and wing, so everyone in the division is working together in the same area (.NET and DBA on the ...
After Dmitri posted DataObjects.Net beta2 last night, I couldn’t wait but test the security framework included. If you have been watching you may know that I worked on the provider for MySQL for DataObjects.NET. I was curious to see how the security framework will feel on MySQL. Well to my ‘extreme’ happiness, after I translated the SalesPoint database into MySQL and testing the sample it worked very beautifully. I only had to change the URL in the App.Config file. I have attached the SQL script ...
I hit this error when I deployed an app built with Entity Framework onto Windows Azure. Obviously, I wasn’t explicitly using DataReader so it kind of puzzled me. As it happens every time It worked well with local database, application running local and database on SQL Azure. But once I used the Dev Fabric to test the application locally, it failed and gave the above error. Entity Framework relies on using Multiple Active Results Sets (MARS), and it would be a part of connection string multipleactiveresultsets=True. ...
LocalStorage() is one of the new features of HTML5 that found widespread use among PC and phone developers. It can save up to 5MB of data locally, on a user device in a key-value database inside a web browser. Data can be retrieved only from a device where was permanently saved until it gets deleted by user or programmatically. To be able to take advantage of this and other HTML5 features, user needs to have a compatible browser. Currently, at the time I am writing this post, there is no browser ...
Our database has a few lookup tables that uses similar approach to implemented by .Net Framework for localized resources: At run time, ASP.NET uses the resource file that is the best match for the setting of the CurrentUICulture property. If there is no match for the current UI culture, ASP.NET uses resource fallback. It starts by searching for resources for a specific culture. If those are not available, it searches for the resources for a neutral culture. If these are not found, ASP.NET loads the ...
At http://www.codeproject.com/... there is a hilarious list of ways to shoot yourself in the foot in various programming languages. C You shoot yourself in the foot. C++ You accidently create a dozen instances of yourself and shoot them all in the foot. Providing emergency medical assistance is impossible since you can't tell which are bitwise copies and which are just pointing at others and saying "That's me, over there." FORTRAN You shoot yourself in each toe, iteratively, ...
Technorati Tags: TFS 2010 Database,TFS 2010,TFS 2010 Administration Considering you have an advanced TFS installation such that the app tier and the data and reporting tier are spread across multiple servers and the data tier goes down because of a network failure. The below error message may seem familiar, Team Foundation Services are not available from server xxx. Technical information (for administrator): Unable to connect to the remote server. Now your first reaction would be to verify whether ...
I figure it should be in bloody good fun to start off my first real post with a rant on the future of Microsoft Windows, or the lack thereof. You see, my issue is that I have seen the preview of Windows 8 video. It is just further evidence of the fact that Microsoft still does not “get” our issues with the OS. I don’t need a new skin on my OS, I need new and more secure plumbing that actually works. Don’t put the OS into tiles and call it fun. Redesign the bloody thing to make it more secure, easier ...
In this Issue: Rudi Grobler, Roy Dallal, Chris Rouw, Sean Nolan, Peter Kuhn, WindowsPhoneGeek(-2-), Jesse Liberty(-2-), Mike Taulty, Paul Sheriff, Xpert360, and Vikram Pendse. Above the Fold: Silverlight: "Storing Files in SQL Server using WCF RIA Services and Silverlight – Part 1" Chris Rouw WP7: "XNA for Silverlight developers: Part 12 - Mango (1)" Peter Kuhn From SilverlightCream.com: Slide-out keyboard support on Windows Phone Rudi Grobler has a quick post up discussing the slide-out keyboard ...
SQL Tidbits Have you ever had a need to see storage information for all your databases in a SQL Server? As they say there are many ways to skin a cat all based on your need. Back in the day I was taught to use SYS.SYSFILES, its handy and it does give you what you need but suppose you wanted a picture of your entire SQL Server? Then this solution is not viable that’s when we divert to SYS.MASTER_FILES according to MSDN http://msdn.microsoft.com/e... this system view contain ...
I wanted to get familiar with SharePoint 2010 because I have noticed how the market is starting to demand it. Also, most of the SharePoint 2010 guides on the net are outdated. They show everything from registry hacks/editing xml files to installing hot fixes/service packs. My guide uses the latest bits as of 6/7/11 to create a SharePoint 2010 server inside of an Virtual Machine. This will be more than enough to begin creating Silverlight Web Parts inside of SharePoint 2010. NOTE: I did not want to ...
Recently I was building a VM for a BizTalk 2006 R2 project. My VM configuration was : Windows 2003 R2 SQL 2005 with SP4 Visual Studio 2005 with SP1 BizTalk Server 2006R2 I installed the BizTalk Server 2006 R2 SP1 update from the Windows Update. Life was good so far. Next I got requirement to use WCF SQL adapter and there I went and started installing the pre-requisite for it. 1. WCF LOB Adapter SDK SP2 2. Microsoft BizTalk Adapter for SQL Server. After that I went and tried to Add the Adapter metadata ...
Today the BIDS Helper team released a new version the details below are taken from the download page for the new release. Those of you with BIDS Helper already installed should get a new version notification when you next launch BIDS. The major feature in this release is the Biml Package Generator, John has been doing some great work documenting the capabilities of this new feature here (make sure you also check out the samples and tutorials of this powerful feature). Enjoy! ====== New Features Duplicate ...
While working with SQL, you come across a scenario when you need to dump the resultset of a SELECT statement into either a temporary table or a placeholder table. I can imagine how tiresome it is to create a schema for the table beforehand and keep that updated with any additions/deletions to the SELECT statement. To cut the long story short, SQL makes ones life easy with the help of a syntax "SELECT... INTO..." E.g. SELECT column1, column2, column3 INTO NewDynamicTable FROM TableName This would ...
In the next generation of SQL Server, codename “Denali”, there is a new feature named Data-tier Application Framework v2.0 Feature Pack CTP to enhance the data import and export with SQL Server, and currently it had been available in SQL Azure Labs. Run Data-tier Application Locally From the portal we know that the Data-tier Application CTP2 can be executed from the development machine through an EXE utility. So what we need to do is to download the components listed below. Only one thing, the SQLSysClrTypes.msi ...
Check out the Top Five most popular news at SilverlightShow for SilverlightShow Top 5 News for May 30 - June 05, 2011. Here are the top 5 news on SilverlightShow for last week: Windows 8 apps going html/js HTML5? Ok, so let’s also deploy Microsoft Silverlight onto Android then Windows Phone 7 SQL CE – DataContext Tables Telerik Announces Support for Windows Phone 7 Mango, Ships the Fastest WP7 Chart Yet Another Podcast #37 Silverlight HTML5 & Developers Part 2 Visit and bookmark SilverlightShow. ...
If you’re writing a custom SharePoint Claims Provider (SPClaimProvider) in order to augment claims, it’s important to also understand what process is executing your specific code path. In the situation where you are making calls to a DB or service endpoint you will need to understand which process actually makes that call. In situations when running in a Trusted Subsystem model, you’ll also need to RunWithElevated in order to have that code path execute in the context of the Windows Principal for ...
This morning I was reading through some of my usual blogs and came across some very interesting and updated information relating to BizTalk performance and hyper-threading. The two source pages are: http://appfabriccat.com/201... http://msdn.microsoft.com/e... If you take a look at these pages, you can see that the recommendations on hyper-threading and the BizTalk platform ...
In this Issue: Rudi Grobler, Oren Gal, Michael Washington, Vikram Pendse, Kunal Chowdhury, Jesse Liberty, Xpert360, Jaana Metsamaa, Charles Petzold, and Peter Kuhn. Above the Fold: Silverlight: "Getting Driving Directions in a Silverlight Application - Part 2 - Advanced Features" Oren Gal WP7: "Windows Phone Screen Shots" Charles Petzold LightSwitch: "How to Create A LightSwitch Popup" Michael Washington Shoutouts: Congratulations go out to my buddy András Velvárt for SurfCube Wins Microsoft Innovation ...
http://stackoverflow.com/qu... I’ve used SQL script similar to paul_nielsen’s to Create Indexes for Foreign Keys and added “if not exists” condition DECLARE @SQL VARCHAR(max); SET @SQL = '' SELECT @SQL = @SQL + 'if not exists (select * from sys.indexes where id=object_id(''' + TableName +''') and name=''Ix' + ForeignKeyName+''') CREATE INDEX Ix' + ForeignKeyName + ' ON ' + TableName + '(' + ColumnName + '); ' FROM ….... --SELECT @SQL ...
Great content available to get started with Windows Azure and SQL Azure. Windows Azure SQL Azure Introductory Videos Introductory Videos Deep Dive Deep Dive Tutorials Case Studies Case Studies Events Events ...

A great guide that will give you information on how to test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions.

Get it here ... http://msdn.microsoft.com/en-us/library/hh226085.aspx

Within each division in Red Gate, development effort is structured around one or more project teams; currently, each division contains 2-3 separate teams. These are self contained units responsible for a particular development project. Project team structure The typical size of a development team varies, but is normally around 4-7 people - one project manager, two developers, one or two testers, a technical author (who is responsible for the text within the application, website content, and help ...
I spent some time today summarising the new features in the Windows Azure AppFabric May CTP for SolidSoft consultants. Microsoft released the CTP a couple of weeks ago and has a second CTP coming out later this month. I might as well publish this here, although it has been widely blogged on already. There is nothing that you can’t glean from reading the release documents, but hopefully it will serve as a shorter summary. The May CTP is all about the AppFabric Service Bus. The bus has been extended ...
With thanks to Wriju for doing the work to pull these together. How to: Build a Windows Azure Application How to Configure Virtual Machine Sizes How to Configure Connection Strings How to Configure Operating System Versions How to Configure Local Storage Resources How to Create a Certificate for a Role How to Create a Remote Desktop Protocol File How to Define Environment Variables Before a Role Starts How to Define Input Endpoints for a Role How to Define Internal Endpoints for a Role How to Define ...
Overview of the “AdventureWorksDesignPatterns” Project (I’ll be posting on this series here. It will be based on the presentations I’m creating for the PhillyNJ.NET user group a subgroup of PhillyDotNet) This is the start of a long series on “applied design patterns”. The intent to demonstrate design patterns in real code. I am not endorsing or “pushing” any specific methodologies. But I will be stressing various points of views many of which are part of various methodologies you may have heard of. ...