Tag | Database Posts

In a previous post I discussed how to build an SSIS package to automate the backing up (COPY) of a SQL Azure database. I assumed that once the SSIS package was built that people would know how to deploy the package and create a schedule for it to run automatically. I have had several people let me know that just building the SSIS package was not enough, that the additional information of deploying the package and creating a job for it is needed. The first step is to compile and build your SSIS project ...
So last night I started seeing the #oow10 hashtag show up on Twitter, along with comments about cloud computing, Oracle, and how horrible the HP portion of a presentation was. Turns out that OOW10 stands for Oracle Open World 2010, Oracle’s annual conference. They were live streaming the keynote and Larry Ellison was on the stage so I thought I’d check it out. First thought of the presentation was how unpolished it seemed. Keep in mind that all the tech-related keynotes I’ve seen have been at Microsoft ...
Any ramblings and blog posts associated with the UNISA ICT 2622 tag should be considered study notes for my lectures… Objectives of Chapter 16 Describe implementation and support activities Choose an appropriate approach to program development Describe various types of software tests and explain how and why each is used List various approaches to data conversion and system installation and describe the advantages and disadvantages of each Describe different types of documentation and the processes ...
In this Issue: Michael Washington, Paul Patterson, Gergely Orosz, Dimitris - Ilias Gkanatsios, Kirupa Chinnathambi, SilverLaw(-2-), Sergey Barskiy, Jeremy Likness, and Sigurd Snørteland. Above the Fold: Silverlight: "CodeBox - Syntax Highlighting In Silverlight For Any Programming Language " SilverLaw WP7: "Back to Windows Phone 7 Database " Sergey Barskiy Lightswitch: "LightSwitch Student Information System (Part 2): Business Rules and Screen Permissions " Michael Washington Shoutouts: Karl Shifflett ...
The past few months I’ve been playing architect and admin, rather than developer. I have worked with a couple 2010 environments for play and work and at least one upgrade. So here are just a few tidbits that you might not know that I’ve found… When working with the blank site definition you have to activate the taxonomy features through stsadm if you want to use managed metadata. Here is a good article: http://neoassyrian.blogspot... There is a bug ...
Any ramblings and blog posts associated with the UNISA ICT 2622 tag should be considered study notes for my lectures... Objectives of Chapter 15 Discuss examples of system interfaces found in information systems Define system inputs and outputs based on the requirements of the application program Design printed and on-screen reports appropriate for recipients Explain the importance of integrity controls Identify required integrity controls for inputs, outputs, data, and processing Discuss issues ...
This post goes over how to display images stored in a database using the SlideShowExtender control. The examples use VB.Net (what I have to use at the office) and assumes that you are storing your images in a database, have a way to retrieve the images from the database (e.g. stored procedure) and have AJAX (example is based on the AJAX controls in VS2008) setup in your ASP.Net project already. Also the example was based on retrieving images that are photos hence the names of some of the various ...
Any ramblings and blog posts associated with the UNISA ICT 2622 tag should be considered study notes for my lectures... Objectives of Chapter 13 Describe the differences and similarities between relational and object-oriented database management systems Design relational database schema based on an entity-relationship diagram Design an object database schema based on a class diagram Describe the different architectural models for distributed databases Key Words & Definitions database (DB) – an ...
Model Functionality · Support for Enums for property types from lookup tables · Allow default date = DateTime.Now - The only way to set a default date in the entity data model is to put a hard date in there, a string. If you have a known default date (e.g. 1900-01-01) this is fine. But often we want NOW to be the default and there's no way to indicate that in the model. · Support for System.IO.Stream instead of Byte[] for varbinary type of fields · Support GUID as Entity Key -http://leedumond.com/blog/... ...
Merge Wpf and Silverlight to single framework · Merge both frameworks to use the same assemblies and controls (with optional functionality in separate assemblies) make a .net silverlight profile that would be a subset of .net client profile and used by partially trusted xaps. · Conditional compilation within Xaml - stopgap solution: for Silverlight/WPF differences in shared markup. · Support the direct hosting of Silverlight – stopgap solution: support the direct hosting of Silverlight in a WPF application ...
HTML5 specifies scripting application programming interfaces (APIs). There are new APIs, such as: The canvas element for immediate mode 2D drawing. See Canvas 2D API Specification 1.0 specification[14] Timed media playback Offline storage database (offline web applications). See Web Storage[15] Document editing Drag-and-drop Cross-document messaging[16] Browser history management MIME type and protocol handler registration. Microdata To read more, go to: http://html5tutorial.net/ Websites Examples ...
On October 24th, Microsoft released Service Update 4 for SQL Azure. The major component of this release was the live release of Database Copy functionality, which allows you to make a real-time "backup", or shapshot of your database into a different database. Backup functionality has been at the top of feature requests for SQL Azure for a long time, so this feature is certainly welcome. However, this great feature has some limitations. For example, there is no built-in way to automate a backup. For ...
I've made a couple changes today to the SilverlightCream site and to my blog, after a discussion last night with a cohort. I'm displaying (hopefully obviously) an RSS image that now goes out to Feedburner. The big take-away for me for that is that the feed is now displayed as a 'feed' and not as XML. The take-away for you is that you can now subscribe via Feedburner. I also modified the Search Results page at SilverlightCream.com to tell you how many results were returned. And, did you know you can ...
C# supports what I call waitForEvent threads or formally known as synchronous event threads. This is a thread that is fired whenever an event in another thread occurs. I use this type of thread to perform an action when a bit transitions from true to false, a variable transitions above/below a limit. The reason for doing this is because we do not want to interrupt the timer thread which checks these values on a 1-sec basis with the chore of building & sending messages, updating database tables, ...
Thanks to everyone who attended the “Flip on LightSwitch!” at the Kansas City Office Geeks User Group last night! Lots of great questions and interaction from the group! As promised, here are the resources we talked about: First, you need a place to play with LightSwitch. As it is beta, a vpc is always a good idea. Currently there are three flavors of the Visual Studio 2010 Ultimate VPC: Microsoft® Visual Studio® 2010 and Team Foundation Server® 2010 RTM virtual machine for Microsoft® Virtual PC ...
Spent some time getting my butt kicked by SQLServer2008 R2. I had SQLServer2005 on there and never did really care for the install I had going on that, and I have to believe that’s what part of my problem was because I could not connect to anything useful with the new install. After a failed attempt at a repair, I finally said screwitall and unistalled both, and reinstalled SQLServer2008 R2. Then I could connect in the manner I thought I should So I got the AdventureWare database installed and the ...
I had to run an errand the morning of Day 1 and returned to find the FedEx paperwork from Minerva. My benefits ended August 31. I don’t believe I’ve ever worked anywhere that benefits ended the day of… but it also included the COBRA papers and that’s gonna run roughly $850/month starting *now* … a big bite into the reserves to try to extend the money. Conversation with the HR lady was strained… she was really glad to get off the phone, guess maybe they *do* read my blog – I hope so! Got an unexpected ...
My own very recent personal experience mirrors this blog post: Silicon Valley’s Dark Secret: It’s All About Age So what do I do to deal with that? Looking at Vivek’s advice, item number 1 is to move into management … yikes… I firmly believe that if someone thought I had the chops to be a manager it would have happened 20 years ago… nobody wants to make me a boss, trust me :) besides which, I like coding! Item 2 sucks… and goes totally against the American Dream of continually moving up… expect to ...
Today I decided to share a script I wrote that checks for a specific database log size and if it exceeds a certain predefined limit sends an alert email to a user of choice. Of course, there is a possibility to add more databases to check and/or more database files. Thought the script might come up handy for a DBA trying to avoid a situation with a rapidly expanding log file thus bringing down its database by scheduling it to run in short intervals, here is the code: 1: Dim Connection 2: Dim ConnString ...
I’m not pretty sure how many users are using the standard SQL Server Management Studio (SSMS) 2008 R2 to manage your SQL Azure database. I was one of them until I found the Houston project provided by Microsoft in its SQL Azure Labs. SQL Azure Labs is a place where we can try the latest CTP features of the SQL Azure. They might not be included in the production SQL Azure but I think most of them will be launched in the future. So it’s a good place for us to play with the newest stuff of SQL Azure. ...
SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2 and their respective Express versions. It contains a few upgrades to the SSMS IDE that I thought were missing. The current features include: •SQL Snippets •Window Connection Coloring •Query Execution History and Current Window History •Format SQL •Search Table, View or Database Data •Run one script on multiple databases •Copy execution plan bitmaps to clipboard or file •Search Results in Grid Mode •Generate ...
Just had a SQL Server 2005 database completely becoming unavailable after the drive on which its files were residing on completely ran out of space (thanks god in development). Freeing some space turned out to be a more or less strait-forward step. Now the recovery stage. Interestingly, out of a dozen databases (all in SQL 2000 compatibility mode) only one became affected. When I started to figure out what is wrong I checked the SQL Server log first and could see that another database’s log file ...
I've been trying to push the client where I work into a more test driven approach, but when you're dealing with state agencies, if you want to get people nervous, just say the word "Change". They want 'impovements', just not 'change'. In many respects, they're not unlike the person who wants to lose weight, but not change their eating habits. Now that I'm moving on to greener pastures, I can again resume my deep dive into NSpec, NBehave and the rest, however since I've also been digging into templating ...
*Moved to: Rangers shipped Visual Studio 2010 Database Guide Have you ever struggled with the Database Developer (was DataDude) components of Visual Studio? Well I have…and now the ALM Rangers have released a new guide to help us all get the benefits. There is Guidance as well as Hands-On-Labs and even how to do WIX integration for deployment. Read more...Follow my new blog on http://blog.hinshelwood.com ...
Any ramblings and blog posts associated with the UNISA ICT 2622 tag should be considered study notes for my lectures... Objectives of Chapter 11 Explain the purpose and objectives of object-oriented design Develop package diagrams and component diagrams Develop design class diagrams Use CRC cards to define class responsibilities and collaborations Explain the fundamental principles of object-oriented design Key Words & Definitions instantiation – creation of an object based on the template provided ...
Thanks to all of you who attended my session at STL Day of Dotnet. Hopefully you found it useful. You may find a copy of my presentation here: http://www.slideshare.net/k... I hope to create some follow up blog entries on this topic but in the meantime, you may download the sample project here I have also included the script I used to build the demo. New Project - Silverlight Business Application AdventureWorksHR @ C:\Code Projects\DayOfDotNet2010\ Build and Run. ...
The road to learning is such an awesome thing! Yesterday, while browsing the MSDN Forums, I came across some people having frustration with SQL Server Express, Visual Web Developer 2010 and the Web Installer. The Issue After installation, if you create a New Website with VWD 2010, follow the steps below: Access the Web Site Administration Tool (Solution Explorer Toolbar) Click on Provider Configuration (Once the Web Site Admin Tool opens) Click on Select a single provider for all site management ...
Well... I should have known better than to try to interview for a new job, but it was a Windows Phone gig... and could have been a career-extender. Not to even think about the crap that's going on at work right now, this would be a sweet deal. But... I don't interview well. I've proved that to myself and others multiple times. I work on .NET 2.0 web database software connected to Oracle, Oracle Stored Procs, and Microsoft Access 8 or 9 hours a day. The stuff's not tricky by any means, it's mostly ...
[Source: http://geekswithblogs.net/E... Web.config transformation is a simple and powerful inclusion in .NET 4.0 for generating configuration files for different environments. It's a templated match-and replace, and you can put together a homegrown alternative with T4 and some scripting, but the integrated experience is better. It's limited to web.config in Visual Studio, but with a simple MSBuild target you can leverage it for any config file. The transform is based on your VS.NET solution ...
For my first “real” attempt at creating a business application using Silverlight I decided to use WCF RIA Services, Silverlight 4.0, and Visual Studio.NET 2010. What easier way to get started than through a template provided by VS.NET 2010, right? Well, in its effort to make it easier it also create some headaches. Sometimes abstraction can add a learning curve as well. In this case it created some headache for me on this project. As an IT consultant for small to enterprise level business most of ...
I have recently started to look at EDI communications through BizTalk. Part of the EDI features in BizTalk is the use of BAM to track messaging. Amongst the applications we currently have built in BizTalk we do some SharePoint communication. This is also a possible component to our EDI solution. We also have plans to move to BizTalk 2010 in the near future, so today I started to build my new BizTalk Dev machine. I got a bit of a surprise when 2 parts of the required set had me setting a flag “Enable ...
Long Island Expressway...painless dentistry...dry wine...educational television. Inventing oxymorons like these is a wonderful party game; what others can we come up with today? How about: airline food...random order...House Ethics Committee...Service-oriented business intelligence.... That last phrase does seem like an oxymoron, at first glance. Service-Oriented Architecture (SOA) and Business Intelligence (BI) appear to be very different animals in enterprise architecture: Their purposes are very ...
Since I published the state of my project goals, I got a few questions about my repository implementation, so here goes… The ‘classic’ repository interface looks like this: public interface IRepository<T> { T GetById(int id); IEnumerable<T> GetAll(); T SaveOrUpdate(T entity); void Delete(T entity); //... } This interface has some issues to me. First of all, it’s data-centric. I know that’s the whole point of a repository, but bear with me. Second, it exposes far too many methods. One ...
When I was in school my instructor introduced me to relational databases. I mostly programmed in Oracle learning different types of JOINS and T-SQL statements. It was forbidden to talk about any other type database. Now, fast forward few years and everyone is talking about Document Databases. The NOSQL movement is all about non-relational databases. The word NOSQL might seems a little harsh if you are a DBA but the reality it just means that there are options other than relational databases. Think ...
Cloud services platforms are still in their infancy considering the size of the market, but big players like Microsoft, IBM, Amazon, and Google have made significant investments for the future in offering cloud services in some form or the other. In this section, I will outline the offerings of some cloud services providers: Amazon Web Services Amazon is the largest online retailer in the world, and to support its daily operations, Amazon has one of the most advanced data centers in the world. Processing ...
En el artículo anterior se definieron los conceptos de la Nube y Cloud Computing, y se repasó rápidamente la evolución de tecnologías que favorecieron el surgimiento de dicho paradigma. En el presente artículo se definirán los diferentes conceptos “*aaS” relacionados con el concepto de cloud computing (SaaS, PaaS, IaaS, etc.). SaaS digamos que ya es un término hasta cierto punto conocido, pero ¿y los demás? Eso es lo que se aclarará en este artículo. Los servicios de computación en la Nube, así como ...
Any ramblings and blog posts associated with the UNISA ICT 2621 tag should be considered study notes for my lectures... Objectives of Chapter 2 Explain the purpose and various phases of the traditional systems development life cycle (SDLC) Explain when to use an adaptive approach to the SDLC in place of the more predictive traditional SDLC Explain the differences between a model, a tool, a technique, and a methodology Describe the two overall approaches used to develop information systems: the traditional ...
Hey folks, Recently, Tellago Studios released its first product SO-Aware, A WCF RESTful Service Metadata Repository. Now talking about WCF Services and how can we forget them being used extensively by BizTalk Server. Let’s check it out with a simple scenario. Say you are using SO-Aware as a central repository for all your Web Services. Some of those services are also integrated with BizTalk. Now on one hand you have a central repository for your services and your life is going smooth but when it ...
One of my colleagues pointed me at Howard Baines as a recent example of a web consultancy already using Visual Studio 2010 and Entity Framework 4.0 to build web applications. I managed to grab a little time with co-founder Clive Howard (on twitter) to talk through some of the decisions, especially as I was intrigued to learn that they started out on Open Source Software including Ruby on Rails before switching to the .NET Framework. We discuss: Why switch to the .NET Framework? Entity Framework 4.0 ...
Microsoft Silverlight 4 Step by Step (click book logo to be taken to the Catalog Page) By: Laurence Moroney Publisher: Microsoft Press Pub. Date: June 30, 2010 Print ISBN-13: 978-0-7356-3887-7 Pages in Print Edition: 336 I decided to do my first review with the new Silverlight 4 Step by Step book from Microsoft Press. I have read the entire book and completed all of the exercises. I have found several errors in the book’s code, but they were not hard to figure out. Instead of writing a formal book ...
At VSLive today, I had the pleasure of introducing Microsoft Corporate VP Jason Zander. And he had the pleasure of introducing Visual Studio LightSwitch. Pleasure is a theme here, because the product, to me at least, looks great. LightSwitch is a .NET based environment, hosted in Visual Studio, that allows developers to build business apps. Quickly. It harkens back, with pride, to tools of old, like VB6 and FoxPro, that made data, and data maintenance UIs, first class citizens. These tools also treated ...
Today at VSLive! we announced Visual Studio LightSwitch (link not quite up yet). LightSwitch is intended to be the simplest way to build business applications for the desktop and cloud. It provides the tools to rapidly develop professional applications from pre-built templates in a simplified development experience. It is intended to be used by professional developers. Top level features: Applications are built in Silverlight Pre-built templates Support for SQL Server, Sharepoint and SQL Azure Applications ...
So I'm on this private email group and a discussion starts by someone pointing out this blog post which talks about the Microsoft.Data.dll and the Microsoft.Data namespace. From the blog post: It’s an awesome new assembly/namespace that contains everything you’ll ever need to access a database. In ASP.NET WebPages we wanted people to be able to access the database without having to write too many lines of code. ... The user doesn’t have to learn about connection strings or how to create a command ...
Recently I was tasked with the responsibility of purging database from one of our SQL 2000 databases. One of the test cases is to use a copy of a database that is a small production database and delete all of the data contained within. After the delete is executed then I can review the data tables and see what is left over or was skipped after the delete script runs. Looking at the properties of hundreds of tables in Enterprise Manager seemed pretty tedious. After a quick query to Bing I was able ...
I believe that every developer that works for someone has at least thought of becoming an Independent Developer at some point in his/her career. If I had to sum up the reason why, I’d pick these: 1. The freedom to pick the projects that you work on. 2. The ability to avoid worthless meetings. 3. Saying goodbye to incompetent co-workers. 4. Being able to do the project the ‘right’ way. (Which is typically your way - hopefully) 5. Getting the full reward for the skills you possess. I’m talking money ...
http://www.libraryjournal.c... In the library world, OCLC controls the flow of information. A non-profit organization, it is the center hub for libraries all over the world to share information and loan books to each other. Think of it as a tollway for books. When a Marc / metadata record is created (contains information like author, subject, copyright date, etc) libraries will upload that information to OCLC. This Marc record will ...
If you are following Scott Gu’s Blog or simply the ASP.NET Community, you would have definitely heard about WebMatrix and the Razor view engine. More specifically you must have heard of something known as “ASP.NET WebPages” The ASP.NET WebPages, Razor Engine as well as WebMatrix can definitely be confusing for many who have been into ASP.NET Development for sometime now. Clearly, this is not for you, if you are hard core ASP.NET Web Developer and are happy with either Webforms or MVC based development. ...
Any ramblings and blog posts associated with the UNISA ICT 2621 tag should be considered study notes for my lectures... Objectives of Chapter 1 Explain the key role of a system analyst in business. Describe the various types of system and technology an analyst might use. Explain the importance of technical skills, people skills and business skills for an analyst. Explain why ethical behaviour is crucial for a system analyst’s career. Describe various job titles in the field and places of employment ...
CTP1 of Microsoft® Project Code-Named “Houston” is now available. This is a lightweight and easy to use database management tool for SQL Azure databases. It enables you to swiftly develop, deploy, and manage data-driven applications in the cloud. Project “Houston” provides a web-based database management tool for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data. All implemented in Silverlight. Getting Started For ...
Introduction On many BizTalk projects you have to deal with managing mapping of reference data. A number of times in the past I've spoken about the features in BizTalk for mapping reference data however they do have some limitations which mean that it is very common for a project to implement their own tables in a custom database to hold mapping reference data. While this is entirely valid you often end up with the pain of how do you manage the reference data mappings. One of the simplest ways is ...