Tag | SQL Posts

When I joined Red Gate back in 2007, there were around 80 people in the company. Now, around 3 years later, it's grown to more than 200. It's a constant battle against Dunbar's number; the maximum number of people you can keep track of in a social group, to try and maintain that 'small company' feel that attracted myself and so many others to apply in the first place. There are several strategies the company's developed over the years to try and mitigate the effects of Dunbar's number. One of the ...
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 ...
PREREQUISITES DEVELOPPMENT TOOL In this tutorial, component that follow is required and need to be install: Visual Studio 2010 Express ADO.NET Entity Framework 3.5/4.0 Microsoft Silverlight 4 Tools for visual Studio 2010 that include all components necessary for silverlight 4: Silverlight 4 developper runtime, silverlight 4 SDK, silverlight 4 tools for visual studion 2010. Please, to download it, please refer to this link. INTRODUCTION This topic explain in the simple way how to display data from ...
Using a CTE to help with an update can be pretty handy. In this simple example the CTE is to select SiteIDs for a specific sales rep. The update is to change the address code to ‘Street’ since the rep entered them all in as ‘Mailing’ by mistake. In the update code you use an inner join to match up the SiteIDs from the CTE with the ones in tblAddress so you only update the specific sales rep’s sites and not all of them in the table. WITH CTE(SiteID) AS ( SELECT srs.SiteID FROM tblSalesRepSites srs ...
Cihan Biyikoglu had just announced the SQL Azure Federation Products Evaluation Program had just been opened for nomination. If you are interest in data partitioning, or you had been run into the problem to shard your data, or the 50GB SQL Azure database was not enough to your application, then you can raise your nomination here and hopefully can play with the cool feature earlier than others. I had sent my nomination, god bless me. Hope this helps, Shaun All documents and related graphics, codes ...
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 ...
Scott Klein, co-founder of Blue Syntax Consulting and SQL MVP, was our speaker at the West Palm Beach .Net User Group May meeting. Scott spoke and demonstrated code on Azure’s AppFabric. We would like to thank Scott for making time to share with us despite his busy schedule. We would also like to thank our sponsors: CompTec for hosting our meeting and Sherlock Technology for the free pizza/soda. Below please find a few photos of the event ...
Looks like bloggers figured out I'd post the submittals first, because today I got hammered with posts. In this 2nd in a row Submittal-only Issue: Alex Golesh(-2-, -3-, -4-, -5-), René Schulte, Alex van Beek, Kunal Chowdhury(-2-), Rudi Grobler. Above the Fold: Silverlight: "Silverlight 5 Multiple Window Support" Kunal Chowdhury WP7: "Augmented Mango - SLARToolkit for Windows Phone" René Schulte WP7: "Windows Phone Mango–What’s New? (“New Sensors & Tooling Enhancements” - Part 3 of 8)" Alex Golesh ...
“Design Patterns 100? is a prerequisite for .NET Developers. (Part 4 – Excerpts from July 2010 – PhillyNJ.NET Presentation) Continuing our discussion from Part-3 we ask. What are the “Gang of Four” (GoF) Structural Patterns and where can we find them in the .NET Framework? Let’s look at a list of the Strutural Patterns as defined by the GoF. Adapter Pattern – is used to match interfaces of different classes Bridge Pattern – is used to separate an object’s interface from its implementation Composite ...
“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 ...
Here are the updated links for quick reference: Windows Phone SDK Beta Download Center: http://go.microsoft.com/?li... Go live license– http://go.microsoft.com/?li... WPDT 7.1 Documentation Windows Phone Developer Tools 7.1 Release Notes: http://go.microsoft.com/fwl... What’s New in Windows Phone Developer Tools: http://go.microsoft.com/fwl... Code Samples for Windows Phone: http://go.microsoft.com/fwl... App Hub Links Announcement: http://create.msdn.com/en-U... ...
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 ...
Today a new set of tools targeting the Windows Phone 7 “Mango” release is available. This toolset is being called Windows Phone Developer Tools 7.1 This by not means can be translated into the actual product name for the final release! The download is available at Create.MSDN.com [might take a few hours to appear on that site] Direct Download Link Documentation and What’s New is on MSDN: http://msdn.microsoft.com/e... Using these tools a developer can write WP7 application for 7.0 ...
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 ...
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* 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; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ...
Its been a while since I blogged. Its been hard balancing blogging time, work and many other activities. Most my days and even evenings have been cluttered with a number of tasks ranging from mundial to critical. There is some which have been most interesting include very nice lessons I took from from some of the people I respect in the industry. I will try and highlight some of the things I did in below. 1) The DataObjects.NET contribution programme. From February this year I quickly responded to ...
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 ...
Luego de varios días de intenso trabajo, hoy he tomado un pequeño espacio de tiempo para dedicar un post al trabajo con datos en forma de tablas en asp.net Todos los que hemos trabajado desde hace bastante con asp.net, hemos aprendido a querer al GridView, un excelente control que nos permite mostrar los datos directamente desde una base de datos y trabajar con ellos, llamase trabajar a las operaciones de: editar, buscar, agregar y eliminar. Por supuesto que existen muchas otras opciones que no son ...
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 ...
Let’s focus on Exam 70-516 this time. This exam is TS: Accessing Data with Microsoft .NET Framework 4. Additional Resources: http://msdn.microsoft.com/e... The exam objectives are: Modeling Data Map entities and relationships by using the Entity Data Model http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... Map entities and relationships by using LINQ to SQL http://msdn.microsoft.com/e... ...
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 ...
Windows Azure Boot Camp: Diagnostics (http://wabcdemos.cloudapp.... Remote desktop MonAgentHost.exe starts Auto, listener wired up in app/web.config Need to define a storage account User can set quota Source to Storage: Example: Trace log to Azure Table; IIS Logs to Blob; Windows Event to Azure Table, Crash dump to Blob, ... Load Diagnostic Agent <Imports><Import moduleName="Diagnostic" /></Imports> OnStart({DiagnosticMonitor.... TransferFilterLogLevel and ...
The easiest way in MS SQL 2005 and up is to use the SQL Management Studio, go to Views, highlight the name of the view you are interested in, right click, select Script View as/Create to/Clipboard. open up notepad or your prefered editor and paste the contents of your clipboard. The SQL used to create the view should show up in your editor. If this doesn't work, or if you are working with older versions of SQL Server, look at the system objects as follows: use [YouDatabseInstanceName] go select * ...
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 ...
If you are: a senior technologist (Application Architect, Senior Developer or similar) with strong experience in developing solutions using the Windows platform (Visual Studio, SQL Server, IIS etc) fancy working for Microsoft UK and are not put off by these pictures of my team (and it is before 1st May 2011) then I would highly recommend you check out the job posting for two positions as Architect Evangelists in my team. My personal ideal “new colleague” would also: Enjoy online FPS gaming and be ...
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 ...
It seems that Microsoft has made available a runtime update for the .Net Framework 4.0 that allows a developer to create State Machine Workflows (event-driven workflows). This is great news for everyone that had this feature available back in WF3. They are also providing support for usage of SQL Workflow Instance Store together with SQL Azure. LInks: Download link List of new features can be found here. Ron Jacobs has a great article about this update here. WF4 State Machine User Experience article ...
I have stepped it up a notch and am speaking at numerous user groups and technical conferences in the South East in the coming months. These include .NET & SharePoint user groups as well as SQL Saturday and SharePoint Saturday all day conferences. I will also be submitting to a couple of more regional events that I’m considering including Houston TechFest. If you are in the area, I’d love to have you come by to check out these events. Also, if you are interested in having me present at your event, ...
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 ...
Singapore .NET User Group - April UG Meeting UG Meeting will be held on 18th April 2011 on next Monday, at Level 21 Auditorium from 1900hrs – late. Light refreshments will be served before the session. From the trenches: Lessons learnt working on Azure Mahesh Krishnan, Principal Consultant, Readify 1900 hrs – 2000 hrs Mahesh Krishnan, from Melbourne, Australia speaks about the lessons learnt working on one of the largest Azure projects in Australia. The application which is set to go live soon uses ...
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 ...
I have compiled some basic videos about the asic of ASP .NET from NETTUTS. Nettuts is blog from Envato which provide awesome stuff on Websites, Blog and much more. I hope you wouuld like these videos. 1. Improving an Email From 2. Class Inheritance 3. SQL Server 4. Master Pages 5. MVC ...
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 ...