Tag | SQL Server 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.

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 ...
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. ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...

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

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. ...
I work for Red Gate Software, a software company based in Cambridge, UK. In this series of posts, I'll be discussing how we develop software at Red Gate, and what we get up to, all from a dev's perspective. Before I start the series proper, in this post I'll give you a brief background to what I have done and continue to do as part of my job. The initial few posts will be giving an overview of how the development sections of the company work. There is much more to a software company than writing ...
This blog is the first one of a series of blogs addressing programming practices and lessons learned related to cloud computing. While most developers will be familiar at least conceptually with the techniques exposed, I will provide background information and code samples in an attempt to explain why they are so critical in cloud software development. While most of the information provided will be using Windows Azure and/or SQL Azure, these concepts apply to cloud computing in general. Exponential ...
“Design Patterns 100? is a prerequisite for .NET Developers. (Part 3 – Excerpts from July 2010 – PhillyNJ.NET Presentation) Continuing our discussion from Part-2 we ask. What are the “Gang of Four” (GoF) Creational Patterns and where can we find them in the .NET Framework? Let’s look at a list of the Creational Patterns as defined by the GoF. Abstract Factory Pattern – creates an instance of several families of classes Factory Method Pattern – creates an instance of several derived classes Builder ...
For those that attended TechEd NA 2011 last week in Atlanta it should be no surprise that more and more companies are betting on the Azure platform, whether it is Windows Azure or SQL Azure. There have been developments, changes and improvements for every aspect of the Windows Azure platform in general. And with that tools from 3rd parties to enhance or extend the experience. That is the case when we look at SQL Azure Backup from Redgate. A way to simplify and sync your SQL Azure data to local SQL ...
Just reminder of a post I wrote back in December. Don’t forget that there is a variety of free ebooks available for download on a number of different developer and IT topics. Developer subjects include Programming Windows Phone 7, Moving to Visual Studio 2010, and Introducing SQL Server 2008 R2. IT topics include Deploying Windows 7, Understanding Microsoft Virtualization Solutions and First Look at Office 2010 just to name a few. Have a day ...
Mondays had been good to me recently. Mondays at work are usually quiet, and occasionally I may even be able to sneak in a nap if you want to. Yeah, I have it good. But this Monday would prove to be a bit trickier than normal. It started out normal enough, I was rushing to work, and hoping for one more day full of naps. As I settled in and logged on to my system, I saw an email from one of the clients. It said he was not able to connect to his SQL Server 2008 instance. Also, he had tried using the ...
Microsoft has just released a new SSIS 2008 transform component called SQL Server Integration Services Balanced Data Distributor. As the download site states “this transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading”. Sounds like we got a component to evenly distribute some data across multiple destinations. Frankly, I though we could do this even before using either a Script Component or the Conditional Split, alas this component has ...
For Microsoft these days, great things are happening at the macro level, and yet there’s fits-and-starts progress down below. This year’s Tech Ed North America conference represented, in event-form, that very duality. On the one hand, this was the largest Tech Ed in my memory, with 10,000 attendees. But the customary Microsoft 2-day, all-morning keynote format was shortened to a Day 1, 90-minute talk on Cloud and Visual Studio. Microsoft’s cloud push reached an almost fever pitch; but various new ...
Ok, so you have locked your SQL down. No users allowed. But then there is this information worker for whom the IT department made a special SSIS package. And they loaded the package in to the SQL server and created a SQL Agent job for it. Well no problem so far. But now the user wants to be able to start the job when ever he needs to. Hmmm, huge problem. Because you need to have SA equivalent rights. What?? Yes, you read it right. SA equivalent !! Hell no! Ok a sql geek will now say, that's wrong, ...

here at Tech-ed learning sql server stuff.

I am thinking I would like to work with ucma because providing ability to manage and utilize communcation services is fun.

At http://www.ssmstoolspack.com/  there is SSMS Tools Pack which is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2, 2011 (Denali) CTP1 and their respective Express versions.

The setup has separate sections for SQL 2005, SQL2005 Express, SQl 2008 and even for SQL 2011.

The much esteemed Joe Celko has published an article at http://www.simple-talk.com/sql/t-sql-programming/time-gentlemen-please!-the-sql-server-temporal-datatypes/ discussing the new data and time data types that were introduced with SQL 2008. If you are involved with SQL Server database design and development, I urge you to read this article.

In this Issue: Morten Nielsen, Kunal Chowdhury, John Papa, Jesse Liberty, Mike Taulty(-2-), and Pete Brown. Above the Fold: Silverlight: "Custom Cursors in Silverlight" Morten Nielsen WP7: "Coming in Mango–Sql Server CE" Jesse Liberty Silverlight 5 Beta: "Silverlight 5: Using the SoundEffect Class for Low-Latency Sound (and play WAV files in Silverlight)" Pete Brown Shoutouts: Khawar Yunus sent me this link to his app... I'm not going to tell you to make a login, but I did.. and the app is a pretty ...
Below are a few links, that can help, if you need Restore SQL Server Database from suspect MyITforum.com : How to recover user databases from a “Suspect” status( http://www.myitforum.com/ar... ) http://forums.devx.com/arch... You could also try detaching the DB, then do a single file attach only using the db, dropping the log file. That solved the suspect issue for one of our DBs. Somewhere in the SQL message logs it indicated that the LOG file was corrupted ...
When I am working on some project, it is normal to need to analyze the queries that are executed on the database to detect a possible bug or something that is not matched with what I expected. For this, SQL Server Profiler gives me a good and quick overview of what is being requested for each connection to the database. The case of a registration in the profiler can be shown as: As can be seen in the Application Name column has the value ".Net Sql Client Data Provider", which makes it very difficult ...
Let’s focus on Exam 70-583 this time. This exam is PRO: Designing and Developing Windows Azure Applications. This guide itself will be a different approach to preparing for the exam itself. Instead of just taking the individual topics, let’s review the topic in as much information as we can. Here is a set of resources to get started. This is the topic I will be presenting at TechEd North America 2011, so expect more information after 5/18/2011. Here is the link to the session: http://northamerica.msteche... ...
The published SQL Azure documentation indicates that authentication may require the suffix "@servername" attached to your username (where servername is your SQL Azure server name), but there is little additional information provided to differentiate the required scenarios from the non-required. I recently attended a user group chat with David Robinson, Program Manager for SQL Azure. During his presentation, he also mentioned the occasional need for "@servername", but didn't get into detail. When ...
This has been an interesting topic to have discussions around planning storage and storage requirements organizations need to consider. FILESTREAM provides a means to consider storage of unstructured data on the File system (specifically NTFS). As we know SharePoint lends itself to allow storage of large binary data, considering FILESTREAM gives us an option of using commodity storage for binary form unstructured data. Again, another way in which SQL Server and SharePoint work together. The SharePoint ...
RedGate SQL Source Control is a Management Studio add-in that allows you to seamlessly (hopefully...) connect your existing source control system to SQL Server. It is advertised as doing all the typical stuff you'd expect: Source control schemas and data within SSMS Connect databases to TFS, SVN, Sourcegear Vault, Vault Pro, Mercurial, Perforce, Git, Bazaar, and any source control system with a capable command line Work with shared development databases, or individual copies Track changes to follow ...
I have found myself using more and more of the tools Red Gate software makes. They have proven (to me) to be effective and to the point. This time I am talking about SQL Source Control. Simple to use, simple to add a database to be under Change Control, which really is the goal. Don’t take me wrong, Visual Studio is a great tool, yet it is a developer’s tool. As a DBA or Database Developer (referring to an individual who codes T-SQL) we want to launch SQL Server Management Studio and be able to control ...
The Apress $10 Deal of the day at http://www.apress.com/ is Pro SQL Server 2008 Analytics "Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint," MORE ...
Over the last months, I have been putting a considerable level of effort recovering databases. That would be databases in dev, staging and prod. Somewhere, somehow someone got access to Prod and decided to mess with it. All in all this has created some heartburn and so on. Again, not only from the downtime it has caused and the lengthy recovery process. We figured we could use interim solutions that would become active only when we knew a transition period had arrived, while effective, the changes ...
After several months of research, review and revision, a white paper I wrote for the SQL Azure team, “NoSQL and the Windows Azure Platform”, has been published by Microsoft. If you go to http://www.microsoft.com/wi... and do a find within the page for “NoSQL” you’ll see a link for it. If you’d rather download the PDF directly, you can do so by clicking here. The 25-page (not including cover and TOC) paper provides an introduction to NoSQL database technology, and its major subcategories, ...
Am back to SQL Server performance turning after a year of a lot of things, as always I love sharing what I am doing to help someone in need and to create a point of reference to my work. Below is a SQL script that will allow SQL tables Index Rebuilding or Re-Organization, I added the Online flag to allow my tables to be accessible during the re-indexing process. You can reference BOL to see how the ONLINE flag works and the limitations that it brings along. Remember for ONLINE feature to work you ...
First, let me clarify the “killing kittens” statement. A couple of years back, I had a chance of attending a sessions presented by Todd Klindt and Shane Young on SharePoint Installation and to raise awareness of how little control, and not to say the limitations, of installing in Standalone mode, they would state “Everytime a SharePoint Standalone Installation happens, God kills a kitten”. Ok, now on to the rest of the purpose of the post. Assumption: SQL Server 2008 R2 is already installed on the ...
Business Connectivity Services is a new provided to what earlier existed as Business Data Catalogue in SharePoint. BCS adds a lot of new features and has been enhanced immensely now. BCS connects with the external systems including but not limited to: 1. Microsoft SQL Server Databases 2. Your very own custom applications 3. Other SharePoint WebSites 4. Web Services hosted All these sources are exposed as SharePoint Lists, hence all the operations which are applicable to lists can be performed on ...
Here’s a quick start introduction to the ADO.NET Entity Framework Code First Development Pattern. For a more complete (but still intro) walkthrough, check out ScottGu’s blog. At the time of this writing, you’ll need the EF 4.1 Release Candidate. After EF 4.1 is released you’ll no doubt be able to find it on the ADO.NET team blog. 1. Create a new empty ASP.NET MVC2 Web Application, add a reference to System.Data.Entity. If using the EF4.1 RC - add a reference to the EntityFramework dll that comes ...
I was recently installing a new BizTalk Server 2010 mult-server implementation, where the SQL server installation resides on a separate server to the BizTalk server installation(s) and I ran into a problem when attempting to configure the first server in the BizTalk Group. I was able to succesfully set up the configuration, but when applying the configuration the tool was unable to create the BizTalk Group. The SSO set up completed successfully, and looking at the SQL server a number of BizTalk Databases ...
If you are: Involved in developing software products (aka an Independent Software Vendor) or Considering a “move to the cloud” or both! Then you should consider joining one or both of these Microsoft UK created LinkedIn groups intended to foster discussion amongst your peers in the industry. Both groups are fairly new but growing and there is already some great discussion happening on them. UKISVDEV - Developers, Software Architects and CTOs in UK ISVs This group is for UK based developers, software ...
Last week, I was interviewed by Zandra Nilocas from Microsoft Philippines. It was my first time experience to talk about something in front of the camera so it's not surprising that I looked like an idiot in that interview (you know swiveling my chair back and forth without noticing it). Anyway in the interview we talked about ASP.NET WebForms, MVC and Web Matrix in general and just to elaborate a bit of what we talked about and to clarify things out, I have decided to write this post... WebForms ...