Tag | SQL Server Posts

January Event - Highlights From PASS Summit January 19th, 2011 5:30 - 8:00 17th Floor Conference Room, Richardson Building One Lombard Place, Winnipeg Pizza and Drinks Provided! Presenter: Michael DeFehr This past November I attended the PASS summit in Seattle and SQL Connections in Las Vegas. In this session, I’ll go over the highlights of what I learned in these two weeks. SQL Server “Denali” (the next version of SQL server) was a big theme of both conferences, but I attended sessions on grouping ...
If we have to get data from the SQL database, the standard way is to use a receive port with SQL adapter. SQL receive adapter is a solicit-response adapter. It periodically polls the SQL database with queries. That’s only way it can work. Sometimes it is undesirable. With new WCF-SQL adapter we can use the lightweight approach but still with the same principle, the WCF-SQL adapter periodically solicits the database with queries to check for the new records. Imagine the situation when the new records ...
This is known issue with SharePoint 2007 or SharePoint 2010 on Windows Server 2008 platform and not specific to any sharepoint application. Problem: Your windows credential doesn’t work if you try to log in to the web application (http://contosto.company.com) on the server itself although you can access the same site from outside, when you create a SharePoint web application with a host header (contosto.company.com) on SharePoint Server (Server Name: contosto) which is installed on Windows Server ...
Todays Apress $10 deal of the day at http://www.apress.com/info/... is "Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking ...
I promised I’d have a simpler mechanism for rebuilding the database. Below is a complete MSBuild targets file for rebuilding the database from scratch. I don’t know if I’ve explained the rational for this. The reason why you’d WANT to do this is so that each developer has a clean version of the database on their local machine. This also includes the continuous integration environment. Basically, you can do whatever you want to the database without fear, and in a minute or two, have a completely rebuilt ...
Few weeks ago I was working with a small internal project that involves importing CSV file to Sql Server database and thought I'd share the simple implementation that I did on the project. In this post I will demonstrate how to upload and import CSV file to SQL Server database. As some may have already know, importing CSV file to SQL Server is easy and simple but difficulties arise when the CSV file contains, many columns with different data types. Basically, the provider cannot differentiate data ...
Let me start this post by saying if you are searching for the capability to do this, there is a very good chance you have problems with your current database architecture. Having said that, I realize you may not have the option of normalizing your database, and have no choice but to work with what you've got. If this is the case, you may find the following post a useful workaround to whatever problem is causing you to search for a dynamic WHERE clause. A dynamic WHERE clause might be useful if you ...
Problem Like most organizations, we are planning to upgrade our database server from SQL Server 2005 to SQL Server 2008. I would like to know is there an easy way to know in advance what kind of issues one may encounter when upgrading to a newer version of SQL Server? One way of doing this is to use the Microsoft SQL Server 2008 Upgrade Advisor to plan for upgrades from SQL Server 2000 or SQL Server 2005. In this tip we will take a look at how one can use the SQL Server 2008 Upgrade Advisor to identify ...
Visiting the MSDN SQL Server Integration Services Forum oftentimes I could see that people would pop up asking this question: “why I am not able to load an element from an XML file that contains zeros so the leading/trailing zeros would remain intact?”. I started to suspect that such a trivial and often-required operation perhaps is being misunderstood by the developer community. I would also like to add that the whole state of affairs surrounding the XML today is probably also going to be increasingly ...
Todays $10 bargain PDF from Apress is: Beginning SQL Server Modeling: Model-Driven Application Development in SQL Server 2008 Get ready for model-driven application development with SQL Server Modeling! This book covers Microsoft's SQL Server Modeling (formerly known under the code name "Oslo") in detail and contains the information you need to be successful with designing and implementing workflow modeling. $49.99 | Published Jul 2010 | ...
With the new release of the Windows Azure platform there are a lot of new features available. In my previous post I introduced a little bit about one of them, the remote desktop access to azure virtual machine. Now I would like to talk about another cool stuff – Windows Azure Connect. What’s Windows Azure Connect I would like to quote the definition of the Windows Azure Connect in MSDN With Windows Azure Connect, you can use a simple user interface to configure IP-sec protected connections between ...
We just bought a new Web Server, after installing Windows 2008 R2(which is a 64bit OS and IIS7), SQL Server Standard 2008 R2 and IBM Client Access for V5R3 with its Dot Net Data Providers, I tried deploying our new project which is fully functional on an IIS6 Based Web Server, I encountered this Error The 'IBMDA400.DataSource.1' provider is not registered on the local machine. To remove the doubt that I still lack some Software Pre-Requesites or version conflicts since I encountered some erros while ...
Issue: After you have restored a sql server database from another server, lets say from production to a Q/A environment, you get the "Login Fails" message for your service account. Reason: User logon information is stored in the syslogins table in the master database. By changing servers, or by altering this information by rebuilding or restoring an old version of the master database, the information may be different from when the user database dump was created. If logons do not exist for the users, ...
At the DreamForce 2010 event in San Francisco Force.com unveiled their next big thing in the Fat SaaS portfolio "Database.com". I am still wondering how would they would've shelled out for that domain name. Now why would a already established SaaS player foray into a key building block like Database? Potentially allowing enterprises to build apps that do not utilize the Force.com stack! One key reason is being seen as the Fat SaaS player with evey trick in the SaaS space under his belt. You want ...
Problem The SAN data volume has a throughput capacity of 400MB/sec; however my query is still running slow and it is waiting on I/O (PAGEIOLATCH_SH). Windows Performance Monitor shows data volume speed of 4MB/sec. Where is the problem and how can I find the problem? Solution This is another summary of a great article published by R. Meyyappan at www.sqlworkshops.com. In my opinion, this is the first article that highlights and explains with working examples how PREFETCH determines the performance ...
Problem I am trying to understand how SQL Server communicates on the network, because I'm having to tell my networking team what ports to open up on the firewall for an edge web server to communicate back to the SQL Server on the inside. What do I need to know? Solution In order to understand what needs to be opened where, let's first talk briefly about the two main protocols that are in common use today: TCP - Transmission Control Protocol UDP - User Datagram Protocol Both are part of the TCP/IP ...
En este post trataré de explicar los pasos para la instalación de SQL y su posterior configuración. Primer paso: Instalación de las reglas de Soporte (Setup Support Rules) Está será la primer pantalla de instalación con la que nos toparemos cuando tratemos de instalar sql server. En ella, únicamente debemos dar clic en siguiente(next). Paso 2: Selección de las características de instalación de SQL Server (Feature Selection) Este es a mi parecer el paso mas importante del proceso de instalación de ...
Ok it doesn’t really but the Microsoft Partner Network folks have hit gold with this rather addictive chrimbo game. It is great fun to play yet has a little serious side as it “rewards” you with a Windows Azure related link after each level. Try it now! http://bit.ly/festivegame It is a Silverlight app which is: Related In the UK we are helping partners build applications for the Windows Azure Platform (and other technologies such as SQL Server 2008 R2) through Microsoft Platform Ready. Sign up for ...
SharePoint Installation in Windows 7 or Vista is not same as Windows Server 2008. You might have difficulties if you do not follow the proper steps. Here i have been tried to explain how to install SharePoint 2010 on Windows 7 or Vista and configure it. Assume, Installed OS Windows 7 x64 (as you may already know SP only support 64-bit OS) and Windows update Install SQL Server 2008 Install SharePoint 2010 You can install SharePoint using the following steps A. Install software prerequisites 1. Install ...
Part 1 - Listing Data from Database: Let us now learn ASP.NET MVC 2 from Scratch by actually developing a front end website for the Chinook database, which is an alternative to the traditional Northwind database. You can get the Chinook database from here. As always the best way to learn something is by working on it and doing something. The Chinook database has the following schema, a quick look will help us implementing the application in a efficient way. Let us first implement a grid view table ...
In a recent blog post I mentioned the availability of the Programming Windows Phone 7 ebook by Charles Petzold. Well I have good news, there are a number of additional FREE ebooks available from Microsoft to help you continue honing your tech skills. Moving to Microsoft Visual Studio 2010 Introducing Microsoft SQL Server 2008 R2 Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft Understanding Microsoft Virtualization Solutions (Second Edition) First Look Microsoft ...
This post is about VS 2010, go here for the VS/TFS 11 extensions. UPDATED Apr 9th 2012: VersionInfo, NuGet, Code Contracts UPDATED Oct 7th 2012: New Visual Studio GDR UPDATED Aug 31th 2012: New versions updated of ReSharper, NDepend, Web Essentials, Community Build Manager, Code Contracts (March 2012), NuGet, ILSpy, DotPeek, Just Decompile, tangible T4 editor, LinqPad. Added the VersionInfo tool, so you know you have the latest update of VS 2010 UPDATED April 20th 2012: New version of NuGet manager. ...
In honor of Phil Factor's recent post on SQL Smells, I thought I would post some blogs SQL smells and why some of them are bad as well as when they may be OK. Let's start with the top of the list that Phil has compiled. Use of deprecated syntax such as *= (Dave Howard) There are two problems here. First this is not in compliance with the SQL 92 standard. We should strive our code to be standards compliant whenever there is a standard available. Now this sounds like a cop out along the lines of "Because ...
In keeping up with the releases this fall, I have gone through the exercise of installing Denali CTP on my Windows 7 dev machine. Started by running the installation center Selected a New SQL Server Installation Went through the installation of support rules and files. Selected the edition. Accepted the License Agreement. Installed Support Files. Reviewed Support Rules. Selected SQL Server Feature Installation Selected the needed features. Reviewed results from Validation Rules Accepted defaults ...
Problem I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2? Solution Uninstalling a clustered instance of SQL Server 2008 R2 is actually an easy thing to do. It might be intimidating for your first attempt so I would highly recommend doing this first ...
All-In-One Data Platform Code Samples Introduction Download Data Platform code samples Request Data Platform code samples Introduction The All-In-One Data Platform code samples demonstrate the typical programming topics about ADO.NET, Entity Framework, WCF Data Services, ADO, and other Data Platform technologies. These topics are either frequently asked in MSDN forums and Microsoft Support, or are requested by many developers via our code sample request function. We want to alleviate the frustration ...
I’m on holiday the 2nd of December (Its our 21st anniversary which is mind bogglingly aweseome ) so I had been rather ignoring what was going on workwise on the 2nd. My mistake as we have two cool learning opportunities. First up we have the Silverlight Firestarter. This is a free one day global, live streamed and on demand event which is being keynoted by the amazing Scott Guthrie (Well – I find him amazing) which will cover everything from the future of Silverlight to tips and tricks. Register ...
We have gotten the chance to see Microsoft’s recommendations on how to go about providing a reliable virtualization platform to support SQL Server in a Hyper-V environment. While that defines an “ideal” scenario, not all deployments for a virtualized platform happen on Hyper-V, there is a large number of deployments taking place on the VMware platform. And a recent post from Jonathan Kehayias on sqlblogs.com is a great summary of the resources available for making a great implementation possible. ...
Most of the time, I get question from new friends who work in other technologies that "SharePoint is for Content Management/WebSite Creation?". Well, it's common because SharePoint is sucessor of Microsoft Content Management Server (CMS) which dedicatedly used for Web Content Management. SharePoint Portal 2001 predominantly focus on Content Management feature, whereas the later releases came with more features. It's very easy to create Colloboration portal with SharePoint in Minutes where it requires ...
Knowing fully we are now in SharePoint Foundation 2010 territory, I am going back in time. There are still questions around how to configure or create a Web Application and then a Site Collection using WSS 3.0. The questions have come up with companies moving to Team Foundation Server 2010 and not having had experience configuring WSS 3.0. And in many cases they have found in being the “go to” person for anything and everything that has to do with the TFS 2010 deployment you have done. Assumptions ...
SharePoint 2010 is released and available in 3 Editions. They are Microsoft SharePoint Foundation 2010 Microsoft SharePoint Server 2010 Standard Edition Microsoft SharePoint Server 2010 Enterprise Edition Before start implementing Sharepoint, its must to select the right edition for given requirement. When we recommend SharePoint to customers, they first ask what's the cost? Well, it's based on what for SharePoint is going to be used. 1. Microsoft SharePoint Foundation 2010 MSF 2010 is the least ...
You may have already heard some information about the fact that Vertipaq indexes that are coming in the next version of SQL Server code named "Denali" following the announcements last week at PASS. If you want some more detailed information there is a new technical article available for download: Columnstore Indexes for Fast Data Warehouse Query Processing in SQL Server 11.0 which goes into more depth about how this will all work ...
Readers of my blog and/or column know that I am a big fan of PowerPivot. And because of that, I was excited to see, both at June’s Microsoft BI Conference (part of Tech Ed) and this week’s PASS Summit, that the PowerPivot technology will become more entrenched. What Microsoft showed in June was that the full-fledged SQL Server Analysis Services (SSAS) product would support the in-memory BI (IMBI) engine, known within Microsoft as VertiPaq. This cool columnar, in-memory technology will not be limited ...
I needed to downgrade SQL Server 2008 from Enterprise to Standard on a Server 2008 machine, and and kept getting this error when trying to uninstall: SQL Server Setup has encountered the following error: Invoke or BeginInvoke cannot be called on a control until the window handle has been created It turns out the setup utility really doesn't like having ANY other windows open - I closed the Server Manager window and it worked ...
Wow. There were a stack of announcements made at the key note. So I thought I would try to jot then down while I'm just waiting for my first technical session a Deep Dive on PowerPivot to start. The Parallel Data Warehouse Edition of SQL Server 2008 R2 has been released to manufacturing, there was a demo with a query over an 800 Billion record table that was returning in 19 seconds on a 40 node parallel cluster. Yahoo came up and talked about an SSAS cube of theirs, it's 12TB in size and they load ...
Recently I have been given a short term assignment to develop a number of reports in Crystal Reports. Upon arriving to the client location I quickly found out that the only tool I will be using to create the reports is basically the Crystal Reports itself. My initial look at the database quickly revealed that the database structure is far from perfect and that it has some confusing table relationships, another hurdle was in the fact that several columns in various tables were user customizable for ...
I recently migrated my dev environment to a new pc. I moved over all the databases and reattached them. Unfortunately, I soon discovered my SSBS services weren’t working. I was sending messages to my service, but nothing was showing up in the queue. I added logging and monitoring to the stored procs that act as an entry point to the services, and the stored procs I use for activation. Still, nothing. When I ran the Broker Server Diagnostic tool (ssbdiagnose) (available in {Program files}\Microsoft ...
Turns out you can't just move a TFS warehouse/cube from SQL Server 2005 to 2008... Once performed we got the following error on the TFS app server tier - when we tried to update/process the cube (both manually and via the TFS scheduler service): Detailed Message: Failed to load adapter Microsoft.TeamFoundation.Wa... Exception Info: \n Microsoft.TeamFoundation.Se... Error encountered when creating connection to Analysis Services. Contact ...
Brent Ozar and Tim Ford announced today they have two SQL Cruises planned for 2011. If you don't know what a SQL Cruise is, you are missing out. Hop on over to their SQL Cruise site for information, but I'll briefly tell you that Brent and Tim have found themselves a niche. Brent and Tim simply reserved some space on a cruise ship, and for a low price for the cruise and a VERY low price for quality training, you are enjoying quality time with fellow SQL folks as well as relaxing as you travel to ...
One of the key performance concepts in Analysis Services is the design and use of good Aggregations to support user queries. However, Analysis Services (Both 2005 and 2008) by default is not configured very well to take advantage of multi-processor environments for parallel processing of these indexes, particularly for large MOLAP partitions. Keep in mind, using a large portion of available processors for aggregation building is only desirable in environments where a processing window is allocated ...
My team is pulling together a great afternoon on the 25th of this month to help UK ISVs get up to speed on the latest technologies from Microsoft and explore their impact on product roadmaps. The session is intended for technical decision makers including senior developers and architects. Technologies such as the Windows Azure Platform, SQL Server 2008, Windows Phone 7, SharePoint 2010 and Internet Explorer 9.0 will be represented. Check out the agenda and register before all the seats vanish ...
I didn’t go to the Microsoft’s PDC Professional Developer’s Conference (PDC) this year because it was, as far as I could tell, a made-for-streaming video event. As such, I watched the keynote about 24 hours after it took place and used my Media Center PC to watch it on my plasma television. And I have to say, the keynote was worthy of the medium. Not only did the Silverlight Smooth Streaming technology deliver a fine HD image, but the content of the keynote itself, merited a big screen, and necessitated ...
In this Issue: Michael Washington, Dennis Doomen, Mark Monster, Brian Genisio, Jeff Blankenburg, and Colin Melia. Above the Fold: Silverlight: "My Silverlight 4 Reference Architecture: ViewModels, Coroutines and Binding Conventions" Dennis Doomen WP7: "A Step-by-Step Guide to Building and Deploying your Windows Phone 7 Applications" Colin Melia Lightswitch: "Printing Sql Server Reports (.rdlc) With LightSwitch" Michael Washington Short list tonight after a long day... From SilverlightCream.com: Printing ...
The first-ever meeting of the St. Louis ALT.NET group will be held Wednesday night at 7PM at the offices of Professional Employment Group at 999 Executive Parkway (Suite 100) in Creve Coeur (South of Olive off of Mason Road - Here's a map). The topic will be "Introduction to NHibernate", presented by Nicholas Cloud: setting up NHibernate for data access configuring NHibernate building and mapping domain objects to a SQL Server datastore querying the domain model for data The ALT.NET community is ...
Entity Framework 4 Code First CTP4 was released in July and the API for developing without any edmx continues to mature and get better. Code First allows you to define your entity framework configuration with a Fluent API similar to Fluent NHibernate. Although the API for EF Code First is very user friendly, you should still have integration tests to verify that you’ve configured your entities correctly. This post will walk through configuring EF4 Code First optimistic concurrency. Suppose I have ...
The objects that help you find this info in SQL Server are in sys.tables and sys.columns SELECT tbl.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, col.name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID WHERE col.name LIKE '%YourColumnNameHere%' ORDER BY schema_name, table_name; This will bring back every table that has a reference to '%YourColumnNameHere%' ...
Our West Palm Beach .Net User Group will be honored to have Scott Klein, Microsoft MVP and Author of Pro. SQL Azure (APRESS) as our October speaker. Scott will be talking and answering all our questions about Azure. Time has never been better for our Fladotnet West Palm Beach .Net User Group. We are fortunate to have a free meeting location offered to us by CompTec and to enjoy the backing and sponsorship of many top notch companies. This support is enabling us to uphold our founders’ vision: Create ...
It has been over a year since the last time I updated my list of Florida technical communities and a lot has changed since then. Joe Healy, our Florida Microsoft Developer Evangelist, maintains a list for each of the main areas in Florida, but this only covers the .NET-focused groups. Taking what he has started, I have put together a similar list (based on the information Joe maintains) that covers the other technical communities that I know of. If you are part of a technical user group community ...
I was looking for a simple way to schedule a job to perform a nightly backup of the production system and restore it to a dev system. I know there are many ways of achieving my goal and I am sure my solution will be frowned upon by some (if not all J) but it works for me so I thought I would share my experience with others. For my scenario the requirement was quite straightforward. Backup a single 5GB database then restore to an existing dev system (over writing the existing dev system). This article ...
With most of our systems pre-configured with SQL server, it was only today that I ran into this issue with my fresh installation instance of SQL Server 2008 R2. I had just created a new SandBox DB to experiment with some aspects of Entity Framework 4.0, but as I was saving foreign key changes to tables I had already created I got the following error: Figure 1 - Unable to save table schema changes error With some research, I found my answer in SQL Books Online: Any Schema changes made to a table would ...