Tag | SQL Server Posts

This one is going to be like the sequel to my first blog post. I am actually not that bad of a writer, so I hope my style continues to evolve and I get in the flow of doing these blog posts. I've never tried and it is definitely different writing about me instead of something fictional or some situation in a very vague way like I do with song lyrics. I don't like to fail, so I'll keep trying to get better at this. Hopefully, I'll gain some readers along the way. It deinitely feels good to have a ...
TechEd Developers is really giving us an opportunity to put everybody together – board members, volunteers, the speakers, users who would actually go to meetings, user group leaders – and to relate with Microsoft and vendors as well. Our booth is based next to the MVP and RD booths completing the "TechEd Community Lounge" and allowing us to network with a majority of MVP and RD representatives and program members. Our booth (aka INETA POD) is the place where attendees can come and meet the current ...
My second day of the conference was a mixture of different topics, from distributed application architecture, over database features to the new C# features. DAT202 - The Next Release of Microsoft SQL Server: Overview of SQL Server 2008, Francois Ajenstat There have been serveral new features presented in this session: new data types : filestream, datetime2 support für spatial applications (geometry/geography support) with a cool demo using virtual earth ado.net entity framework (object/relational ...
Microsoft announces the Sync Framework CTP at TechEd Barcelona... Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services, and devices. It features technologies and tools that enable roaming, sharing, and taking data offline. Using Microsoft Sync Framework, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network. Microsoft Sync Framework ...
Microsoft has a couple of articles on how to set up HTTP connectivity for SSAS, one for Win XP http://www.microsoft.com/te... and another for Win2003 server http://www.microsoft.com/te... But Vista Business/Ultimate includes the new version of IIS (IIS 7) which means some of the steps have changed a little. So let's walk through the process with the help of a few screen shots. Getting binariesCopy the contents of the %Installation ...
Date: Monday, November 5, 2007 @ 7:00 p.m. <-- Note time change from original post Topic: Introduction to SharePoint 2007 for Developers Speaker: Reza Alirezaei, Development Horizon Corp As a SharePoint developer you must know what types of functionality the SharePoint object model provides, and how to leverage it in order to build custom solutions. During this session attendees will learn the most commonly used objects in the SharePoint object model, including what they are, what they do, and ...
Following my earlier post, here is my first post on Dynamic Data Controls in ASP.NET "Futures" July 2007 CTP. Once you install ASP.NET "Futures" from http://www.asp.net/ajax/dow... (scroll down to the bottom and you would find the download link) you would get a set of new templates "ASP.NET Futures Website" and "Dynamic Data Website" when you select "File - New - Website" in Visual Studio 2005 or Visual Studio 2008 Beta 2. Once you select "Dynamic Data Website" template it creates a Dynamic Data ...
Looks like Oracle is implementing one of SQL Server 2005's features: the ability to write stored procedures in .NET code and have them stored within Oracle. They've also released an ODAC update that will allow you to develop and deploy the stored procs from within VS.NET 2005. You can read more about the Oracle Database Extensions for .NET here. D ...
A comrade at work recently turned me onto ASP Spider which is a free hosting service for ASP.Net. They support MS Access, .Net 2.0, SQLExpress, MySQL, and tons of other other features. Now bear in mind, this is an educational site, and not going to be your next ecommerce provider. It is provided free of charge to developers who need an environment to practice and develop ASP.Net solutions without having to pay money for them. There are currently approx. 5600 members on the site. I've been looking ...
I was searching the connect site for before posting an issue the other day and came across this SSMS : Allow support for AddIns as in Visual Studiohttps://connect.micro... Which I have thought would be a good idea since I first started work on BIDS Helper. So if you think it would be a good idea too, please follow the link and add your vote. I don't think there is any chance of this feature making it into the release of SQL Server 2008, ...
Last week I was on SQL Server Seminar presented by Kevin Kline. Performance, Baselining, Benchmarking and Monitioring Presentation Stored Procedure Best Practices Presentation Surviving the Data Avalanche Presentation Top 10 Mistakes on SQL Server Presentations There were a few interesting points. •Causes of performance problems-5%-hardware, 15%-bad database design, 80%-bad application code. •Do not Interleaved DDL and DML -No create/Drop table in the same SP as insert/Select. •Keep transactions ...
This post is mainly for those people that were at my presentation at this years SQL Down Under Code Camp. I said that I would post the slides and the sample project (there are links at the end of this post) and here they are. a Powerpoint 2007 version of the presentation [link 2] a Powerpoint 97-2003 version of the presentation [link 2] and the sample project I was using for all the demos [link 2] Note: Some of the demos are using the trash destination and the data generation data source from www.sqlis.com ...
To address user dynamic security for a specific dimension, we have used the technique we found from the article “Implementing User-Specific Security in SSAS” from Hitachi Consulting Microsoft BI found at http://hccmsbi.blogspot.com... This approach defines 2 new tables to the AdventureWorksDW database, DimUser and the fact-less fact table FactResellerUser. The DimUser table contains the UserName column which will be set to the domain user. The FactResellerUser ...
Kent Tegels, of Enjoy Another Sandwich, joined us yesterday to talk about SQL Server and adoption amongst developers and DBAs. During this podcast, Steve Loethen, Microsoft Partner Evangelist, takes on the role as co-host. In this show we talk a lot about CLR Stored Procedures and where they really fit. Kent is really excited about Spatial support in SQL Server 2008 and it definitely comes through when you talk to him. Listen to Kent discuss SQL Server! Technorati tags: SQL Server, HDC, Kent Tegels ...
We had a great show yesterday with Bill Vaughn, author and former VB project manager, talking about SQL Server and how developers should look at later versions of SQL Server. Read more about Bill here and BetaV Corporation. If you haven't made the move to SQL Server 2005, Bill discusses with us what is good and bad about the product as a developer and talks through some of the issues you might have during the migration Listen to Bill Vaughn discuss SQL Server! Technorati tags: HDC, Bill Vaughn, SQL ...
I have a development laptop and i have vista ultimate installed. So i decided to put all my neccesary day to day development tools like vs.net 2005, sql server etc.. But i get error message :- Unable to open the Web 'http://localhost/project name'. The Web server does not appear to have the FrontPage server extensions installed. when trying to create a new website project and i said to myself another microsft OS "VISTA". So next thing to do looked for a solution and i found :this . After i started ...
A Microsoft Office SharePoint Server 2007 (MOSS) production environment is designed according to projected load, usage pattern, services, content volume and growth projections. There is a lot of information that has been published by Microsoft and others on these topics, but i recently had a need to summarize this for a client, so here are hardware and server sizing guidelines for MOSS - brief, to the point and all in one place. Virtualized deployments will be covered in a follow-up post. Guidelines ...
The first CTP of Microsoft's New SQL Server 2005 Driver for PHP is now available. The PHP Driver will deliver an API designed-to-enable reliable, scalable integration with SQL Server for PHP applications deployed on the Windows platform. For more on the CTP and the new SQL Server 2005 Driver for PHP, check out the team's new blog at http://blogs.msdn.com/sqlphp or www.microsoft.com/sql/php ...
This is a summary of the grok talk I gave at the SqlBits day at Microsoft UK in Reading on 6th October 2007. Thanks for all the delegates who finished lunch early to make the grok talks and I hope it proved useful. The target audience for this grok talk was those developers using SQL Server (2000 or 2005) on their laptops who might want to secure those databases. This issue is becoming more important as horror stories of lost laptops containing sensitive customer information now seem to appear every ...
As Rob has just said, this weekend is going to be a big one for the Australian SQL Server community as we are having our second ever SQL Down Under code camp at Wagga Wagga (which is curiously pronounced "Wogga Wogga"). It looks like we will have all 7 Australian SQL Server MVP's at this event. Last year's event was great fun and it's shaping up to be a good one again this year. I'm heading up there tomorrow and looking forward to seeing some great presentations and catching up with friends that ...
This morning at ZendCon, Bill Staples announced the upcoming availability of the first CTP of Microsoft's SQL Server 2005 Driver for PHP. The PHP Driver will deliver an API designed-to-enable reliable, scalable integration with SQL Server for PHP applications deployed on the Windows platform. For more on the announcement, check out the http://blogs.msdn.com/data or www.microsoft.com/sql/php ...
*Moved to: Amusing job requirementsI recently received a job spec that had the most ridiculous "Required" skill set for an "Analyst Programmer". I though I should share it with you as I have just spent the last 10 minutes cleaning tea out of my keyboard with cotton bud's. Here is how it was presented in the email: * C# Java Script Java * ASP.NET 1.1 ASP.NET 2.0 J2EE * Visual Studio 2003 SOA Visual Basic * Winforms Development Visual Studio 2005 Linux * SQL Server 2000 (TSQL and Database Design) AJAX ...
I've included a few articles that recommend similar but slightly different SP naming standards: SSW SQL Stored Procedure Naming Standard [proc] [MainTableName] By [FieldName(optional)] [Action] e.g procClientRateSelect' Practical Methods: Naming Conventions Prefix all stored procedures with "p". Complete the name with the primary table affected, then the job performed. This will group all procedures for a given table in one location alphabetically. Samples: pCustomerList, pCustomerSearch, pCustomerCreate, ...
All the code Idols did a great job. In the end, mostly by popular vote, Steve Potter won the "Top Geek" title. I'm sure we will see more of Steve as he is very interested in presenting at future meetings! Thanks to the code idol contestants: Steve Potter - Cache Register Jonas Strawski - SQL Server as Document Repository Lou Yovin - Volume Shadow Copy Tim Corbett - System Tray App Louis Datz - dashCommerce Martin Anderson - XML Schemas and powershell Max Trinidad - Powershell script to create CSV ...
I had a complicate (and buggy) T-SQLstored procedure, that concatenate fields from details table and show them as one field in the resultset of the main table(Itinerary and summary of itinerary items. I've looked in pivot functionality, but didn't fint how to make it working in the way I needed. Furthermore, Pivot is available for SQL Server DB with compatibility level 90(aka SQL server 2005), but our db still has compatibility level 80(aka SQL server 2000). So I desided to write UDF to concatenate ...
This doesn't really seem to be out there a lot, but a colleague of mine found this for me recently. http://sqljunkies.com/WebLo... Now if we can figure out how to override the default output so we can tell SQL Server Reporting Services (SSRS) not to ignore whitespace. Reports look great in everything BUT HTML when you want more than one space on items ...
In the production servers BizTalk Orchestration some time takes long phase to finish the complete business process. Scenario: Like An employee might wait several days or weeks to approve for vacations. This means that the orchestration will also be in a waiting state for a very long time and its mean taking up resources on the server. BizTalk Server automatically stops the active orchestration instance and save the orchestration instance state into a SQL Server database in the serialized form and ...
Yes, we have Windows Server 2008 coming. Yes, also SQL Server 2008 and Visual Studio 2008, the .NET Framework 3.5, and more - but probably one of the more exciting new items to come at this same time is IIS 7. As Scott Guthrie states in his recent blog post on IIS, this is a major update to the technology. IIS 7 will allow for a plug-in architecture and allows you to take out all the pieces of the IIS stack that your applications don't need. It also allows you to build your own extensions and plug ...
I have been on holidays recently and have just finished catching up with things that happened while I was away. For anyone else who might be interested, here's a quick re-cap... Mosha was forced to cancel his PASS pre-conference session, but then release an alpha version of his MDX Studio tool and then an update to it Adrian and Nick both announced they they have been working on not 1 but 2 Rational Guides to PeformancePoint Server books. One on the Planning module and the other on the Analyze and ...
Yesterday I start writing Simple BizTalk Server 2006 application on Windows 2003 with SQL Server 2005. In have two databases in SQL Server source database name is CustomerSource and destination database name is CustomerDestination and both have same tables in term of their schemas, but their names are different like Customers and 2006Customers in my destination database. My BTS application does a very simple job its fetch all records from Customers table by using the simple query. "Select * from ...
We have seven potential Code Idol's lined up to compete in the first Ft Lauderdale Code Idol. The judges will be there to harrass and judge the contestants who will be competing for valuable prizes and bragging rights for "Top Geek". Shervin Shakibi, Dave Noderer and a mystery guest will be judging! REGISTER HERE! Each contestant will have ~ 10 min. to present their content. And the contestants are: #1 - Steve Potter Description: “Operation Controller”. I would describe it as an object that handles ...
Just a post to help those newbies to BAM, like me, out there in regards to an issue I encountered getting my OLAP cubes to display data. The BizTalk 2006 R2 documentation describing getting BAM to work is based on using a SQL Server 2000 database, and in particular DTS. In an environment using SQL Server 2005, DTS is not used, but Integration Services. So if you encounter a situation where you are successfully adding to BAM (re., the primary import database), but your aggregation views are not displaying ...
Recently I worked with another consultant on trying to import data from a flat file into a SQL Server 2005 database. There were issues loading the file using the SSIS Import and Export Wizard, however, because not all of the rows in the file had the same number of columns. This wouldn't have been an issue using the SQL Server 2000 DTS Import but this functionality has been modified in the new version of SQL Server. Below is the best answer I could find as to why: The simple answer to the question ...
Whilst the big focus is the release of BizTalk 2006 R2, Microsoft also released BizTalk Server Adapter Pack Beta 2 for testing today, to help customers integrate their line of business applications. The adapters work with BizTalk Server 2006 R2, SQL Server 2005 and Microsoft Office SharePoint Server 2007, and are scheduled to be available in the first half of 2008. Additional information on Microsoft BizTalk Server 2006 R2 and related technologies can be found at http://www.microsoft.com/bi... ...
I needed to get some work finished this weekend. The VPN connection to my clients network is generally very slow and flaky (and doesn't work with my Vista box), so I decided I would install the database on my PC and work without the tethers of Cisco constraint. The database in question was db2, so I went to IBM's website and downloaded a copy. After everything was in place, I attempted to create a database. create database mydb SQL1032N No start database manager command was issued. SQLSTATE=57019 ...
Our system started to get intermittent errors like the foolowing in the code that was NOT changed recently: System.InvalidOperationExce... This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTr... at System.Data.SqlClient.SqlTr... I was pointed to MS Kb http://support.microsoft.co... that I've installed, but it didn't change -errors still appeared. Unfortunately, the KB doesn't have a list of changed files and their ...
While there have many takes and talks about Business Intelligence 2.0, which is really BI working in a SOA environment, the technology behind Business Intelligence hasn't seems to mature to the state where we can really have real time performance without sacrificing some traditional BI systems characteristics. SQL Server 2005 did a great job in getting us closer to Real Time Business Intelligence through the introduction of Proactive Caching as well as SSIS's dimensional destination. However, things ...
I suppose by now most of you have seen all the other posts about the Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services whitepaper that was just released. I saw them all too and I was not planning to do another yet another "read this cool whitepaper" post. But, even thoufh I have only just started reading through it, I do have a couple of points I want to make. 1) The first is a shameless plug: BIDSHelper www.codeplex.com/bidshelper gets a mention on ...
Is this even possible? I've been trying to design a BI system on SQL Server 2005 with strict constraints to maintain a 'single version of truth'. One of the hardest things in this system is to provide Real Time data views with historical audit. To make things more exciting, many of the dimensions are slowly changing dimensions. Proactive Caching in SSAS seems to address the issue of Real Time BI in a good sense. We're actually able to get pretty good performance on a ROLAP engine thanks to this neat ...
So, I was looking at Google Reader and noticed a link in the upper right - Offline (new).. What's that? Turns out, Google has a project called "Gears" that provides Javascript hooks that will interface with a few locally running services: Cache, DB, and asynchronous thread pool. This is great, cross platform too. It's SmartClient (and no, MSFT didn't invent the term as far as I know) in essence that it also provides offline capability. You'll still need to deal with updates, etc. Google Gears: Enabling ...
1. http://www.velocityreviews.... 2. http://www.c-sharpcorner.co... 3. http://www.west-wind.com/pr... 4. DFS: http://weblogs.asp.net/owsc... 5. Session State 6. Configure SQL Server to Store ASP.NET Session State 7. Configure ASP.NET for Persistent SQL Server ...
Following on from the highly regarded DeveloperDeveloperDeveloper days, some top guys from the UK developer community have organised a similar event for those dabbling with SQL Server. More details, and registration are now available at http://www.sqlbits.com. Just like DDD it will be held on a Saturday at Microsoft's UK headquarters in Reading. This is a welcome addition to the community calendar, given that database sessions at DDD can often become neglected as they aren't seen as dealing with ...
The challenge I was facing was being able to accomplish the following within a single ASP.NET application: Use an NT authenticated connection to my SQL Server database; this would assume the identity set for the IIS application pool Disable anonymous access to my web site; only allow Windows Authentication Force all use of the TFS API to happen within the context of the Windows authenticated user First, in ASP.NET, in order to force the execution context to use the identity of the person browsing ...
One of my clients encountered this issue and kindly passed on the fix after resolving. Thanks Mike! Scenario: Migrating Datastore from Access to SQL I stole this text from a forum with the same symptoms: «I have read the relevant documentation on how to do this and these are the steps which I've followed so far : 1. Created a new SQL Server 2000 database for the datastore. 2. Created a SQL user account called citrix which the MF servers will use to connect to the SQL Datastore. 3. I have created ...
Here is a little script I find useful. It drops all tables, views and stored procedures in a database. exec sp_MSforeachtable 'DROP TABLE ? PRINT ''? dropped'' 'GO /* Drop all non-system stored procs */declare @name varchar(128)declare @SQL varchar(254) SELECT @name = (select top 1 name FROM sysobjects WHERE type = 'P' And category = 0 order by name)while @name is not nullbegin select @SQL = 'drop procedure [dbo].[' + rtrim(@name) +']'exec (@SQL) print 'Dropped :' + @name SELECT @name = (select top ...
In SQL Server there are generally two types of fragmentation that can plague a database: internal fragmentation and external fragmentation. Both of these types of fragmentation can cause the hard drive to spend more time searching for data on the disk, and since the hard drive is the slowest component in a system, this is something we’d like to speed up if possible. Internal fragmentation comes about as records are added, deleted, or moved within a database file. As records are deleted from a table, ...
With the advent of web , search is everywhere. To make every contentful application really useful for users, we need to have a good search capablity inour app to get the right content when users ask for it. My focus here , is to create a pretty simple search solution using the "Full-Text" capability of Sql Server 2005. Some key features that i belive to watch out. When searching with multiple words, it should not get useless inofrmation. For ex . when we search "asp.net ajax", it should not return ...
I thought this is worth noting. This is the way to generate 1 million records within 1 second in SQL Server 2005. I'll have the code pasted here so that I can have a reference the next time I need to use it. As Namwar Rizvi said, this code is proposed in SQL Server 2005 TSQL Querying by Microsoft press. --Declare a variable to hold the--count of rows to be generated Declare @p_NumberOfRows Bigint --We need 1 million rows Select @p_NumberOfRows=100000; With Base As(Select 1 as nUnion AllSelect n+1 ...
I read an article today that's right on. I've been in the Microsoft world for quite a while, and I'm generally happy with them. That doesn't mean I haven't used other platforms or technologies like Oracle, Eclipse, Java, BEA Tuxedo, Perl, Ruby on Rails, several different distributions of linux (I started an ISP on linux), AS/400, RPG, Visual RPG, VAX, DEC Alpha, WPF, etc. Wow, I look at that list and realize that I've seen quite a few different technologies! I've seen enough to not be a bigot. We're ...
I'm used to working with SQL Server databases that are somewhat small (10 GB or less, usually a lot less), so I'm curious how people deal with huge databases, like those that hold Amazon's transactions or whatever.  Do you have to have the latest and greatest hardware running with clustered servers?  Do you have to do a lot of database partitioning?  How do you handle upgrades?  Do you do then in the middle of the night so that you can take the db down briefly?