Tag | SQL Server Posts

If you've used Visual Studio, and ever switched to SQL Server (Query Analyzer, for example), you've probably wished for Intellisense. I know I have. Now, Red Gate, makers of the best SQL products (besides the server itself) out there, is offering SQL Prompt for free until September 2006. I've downloaded it, and will be installing it soon, considering I work with SQL stored procedures on a daily basis right now. It adds intellisense to a whole slew of products, including Query Analyzer and Visual ...
Ok, felt this bug was worth noting. I'm maintaining some code that was originally written to utilize a sql connection code generator called bonebox. I was notified of an error that occured where a few reports that were running were timing out. Upon reviewing my log messages I discovered that the sql server appeared to be blocking during connection attempts. (as a side note: I was informed later that another application I'm not responsible for was stuck and was eating up most of the processing power ...
If you've been using the SQL Server Management Studio that comes with SQL Server 2005 for a while, you might noticed this nice message box that shows all exception messages. Not only it shows the exception message, but also includes hierarchy of all inner exceptions. What's more you can see the technical details of the exception including its call stack. On top of that you can easily copy all this to the Clipboard. As soon as I've seen this I thought: "I wish I had something like this in my project". ...
Just ran into a bit of nastiness with the SqlParameter class in .Net 2.0. The scenario: I have a DateTime with a value of '05/30/2006 23:59:59.999' (that's 999 milliseconds). When I save it to a (Microsoft SQL Server 2005) DB using a stored procedure invoked by SqlHelper.ExecuteNonQuery(), the value surprisingly changes to '05/31/2006 00:00:00.000'. A bit of step-by-step debugging led me to the culprit. When the DateTime is stored in a SqlParameter to be passed to SqlHelper.ExecuteNonQuery(), the ...
The Never Ending Story (Pt1): With the Latest release of SQL Server Microsoft have really gone to town on BI. To understand this a little better I am going to run a series of interlinked blogs looking at this topic. Today we will start with “What is BI and what goes to make it” BI or Business Intelligence is a relatively new term but with old roots. The original concept is the same as it has always been: To make better use of the information collected by a company/business to help the ...
Today for me was a day of learning. It started morning, when I attended a free seminar from Microsoft on SQL Server 2005 Intelligence. We went through Analysis Service, Integration Services, Data Mining and Reporting Services. It was first opportunity for me to actually work with SQL Server 2005 and, although I’m not much a database guy, but I really liked it. I’ve already installed the trial version and I’m going try out some of the things I’ve learned. So if you have a chance ...
I finished orientation for my new job yesterday. I'll be starting Hanover County Public Schools on their first big .NET project. It'll be my first exposure with IBM DB2, but hopefully that will eventually go away to be replaced with SQL Server or Oracle. In other news, I've seen almost 180 hits on my articles that I published last week! That's certainly better than I expected. No feedback yet, so I'm not sure if that's good or bad. I've started work on my next article, sending email in .NET 2.0. ...
You can do magic: In a Connected Systems World the addition of Service Broker to SQL 2005 can be seen as ‘yet another messaging option” and its arrival applauded. Perversely it can also been seen in a negative light as a threat to BizTalk 2004 and so interesting discussions have come ourt of this thinking. For my part I welcome the addition, I am also a little sceptical about when I’ll opt to use it! Service Broker OK so what really is Service Broker: In the SQL world its a tentative ...
I've just wrapped up the second part of my articles on Inserting into SQL Server without the VS Designer. This is only my second article, so comments are welcome! Inserting into SQL Server, without the Designer - Part 2 - Creating a Connection And if you haven't read part 1, you can find it here: Inserting into SQL Server, without the Designer - Part 1 – Creating a Stored Procedure Chris ...
Microsoft has published another team blog, this time for the data team, those are the gurus bhind SQL server and so, not the data access (who already have their own blog). Check the data team blog. (introduction) Als, Channel9 has started a new series of videos about upcoming data access technologies at Microsoft. The frst episode is on the general vision behind the new technologies. It's a combination of various talks regarding O/R problems and solutions, and a demo for DLINQ. You can check it, ...
Below is a question that was posted to AZGroups earlier this afternoon. I removed the database and table names because I'm downright anal about security :) Having table problems, and I am just stumped.... Our dev website started coming back with the following error when a user logs in: Microsoft OLE DB Provider for SQL Server error '80004005'Warning: Fatal error 605 occurred .... Microsoft's MSDN gives: ERROR_BAD_COMPRESSION_BUFFER 605The specified buffer contains ill-formed data.(http://msdn.microsoft... ...
Tonight's Toronto SharePoint Users Group meeting will feature the Business Scorecard Manager: Business Scorecards provide graphical snapshots of your business data, revealing underlying trends and critical inflection points. Come learn out how this latest Business Intelligence tool works with SQL Server Analysis Services (for SQL 2000 or 2005) to make real-time business dashboards that management will love. [See a demo] You can register at the link above. See you there ...
Well, technically its just day 2, but counting the UG Summit, Wednesday is Day 3. I blogged a bit earlier about the night before, so this is more of a recap for today in general. I was really looking forward to Derek Hatchard's talk on Open Source vs Team System for testing and building, but I heard he had a bout of the flu so it was cancelled (I saw him around later on in the day, so I hope you're feeling better man). Instead, I checked out Beth Massi's talk on datasources and databinding. Great ...
OK, so this is my first ever blog post and I've decided to write about recent changes made to the Microsoft Virtual Labs. If you have no prior experience with these Virtual Labs, they allow you to experience Microsoft software and technologies in a virtual, hands-on lab environment. Say you want to try out some of the new features of SQL Server 2005 but you don't want to download and install the server software, you can take a Virtual Lab instead. Best of all, it's free. In the current issue of Windows ...
If you're developing WinForm applications, generally at some point in the project you develop an Exception Dialog box that provides a user friendly interface for error messages. Usually, it's a generic box that displays parts of the exception stack and perhaps a way to log or allow users to initiate some other action such as proceeding, ignoring, or even reporting the error. Usually the solution hooks in as the Application or AppDomain unhandled exception handler at startup. Thing is, I don't see ...
As normal service has resumed and I’m blogging again (admittedly I’m not going to blog about absolutely everything) here is a wonderful little utility I found on my travels for adding Intellisense to editor in SQL Server. It’s called promptSQL from Red Gate. I really love how Intellisense makes me more productive (i.e. lazy) in Visual Studio and I was wondering about its rather obvious admission from SQL Server 2005 Management Studio, missing a trick strings to mind. Anyway for ...
I ran across this weird problem while debugging a stored procedure in Sql Server 2000. Here's a sample stored procedure: drop procedure p1gocreate procedure p1as create table #t1( col1 int identity(1,1), col2 datetime, col3 int) select *from #t1 return update #t1set col3 = col2return Ok, notice that I have a return statement after the first select. That is my exit point for now because I am debugging so I am not interested in the section after that. Also notice that the update statement will throw ...
Kudos and cheers to: INETA for the speaker's bureau RV.NUG membership for the keen interest in .NETSahil Malik for a fantastic presentation Hard to believe that last fall I was considering giving up on being a UG leader. I sure am glad I didn't (our founder checks in often to make sure I don't quite). Since the VS 2005 / SQL Server 2005 Launch we keep growing and growing and ........The May meeting of RV.NUG was no exception. Sahil Malik (brought to us by INETA) presented on Transactions. He discussed ...
When I was helping out a coworker with an issue for data mining for a logging and auditing ISAPI tool that we created (don't worry I'll get to the basic concepts of what we did), we realized we needed an easy way to pull information from AD easily during our data loads. SQL Server makes this easy of course with the OLE DB Provider for Directory Services. Information about this can be found here: http://msdn2.microsoft.com/... for SQL Server 2005. The reference from ADO 2.8 ...
In .NET 1.x if you wanted to modify the stack size of a thread you created you would have to go through some pretty nasty code .. Here is a hint :) [DllImport("kernel32.dll", SetLastError=true)]static extern int CreateThread (ref SECURITY_ATTRIBUTES lpThreadAttributes, int dwStackSize, ref int lpStartAddress, ref object lpParameter, int dwCreationFlags, ref int lpThreadId) In 2.0 a new overload has been added to the Thread class to support alterring your stack size directly through managed code http://msdn2.microsoft.com/... ...
I'm trying to add a solution to sourcesafe in Microsoft SQL Server Management Studio (or Visual Studio, it behaves the same), but it seems every time I do this I always manage to create a silly structure like this: [AllMyProjects] [ExistingProject] [MyNewSolution] [MyNewSolution] [MyProject] *Project Files* So I get this duplication of the solution name repeated in sourcesafe! Pretty annoying! It turns out that the way to avoid this is make sure you understand the completely user-unfriendly UI that ...
Recently, one of my peers asked a question regarding the ability of SQL CLR classes to read configuration data from an Application Configuration file. After doing some quick Google searches on the topic, I came up with a couple of links that indicated the potential, but no concrete HOWTO on getting it all wired up. Now, I don’t want to debate whether this makes good architectural sense to store static settings in the file system when you’re already working inside a database management ...
The last month was pretty rich in terms of the free downloads I found available online, so, thought I needed to list some of those, and clearly got busy/late for that! however, I thought I'll also drop the list in case someone missed any. Form Scott Guthrie (AKA: ASP.NET Hero)'s Blog: Source Code for the Built-in ASP.NET 2.0 Providers! This really a BIG hit. The source code for the whole set of ASP.NET 2.0 providers downloadable for free, and also, Scoots points to 130+ pages of awasome pages walking ...

According to this page on the Microsoft site, the new 70-431 exam now counts towards an MCSD certification, and you get a TS: SQL Server 2005 to boot!

D

It is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a stored procedure that returned a particular "page" of data from a table. After examining Scott's approach, I saw some potential improvements in his method. In this article we'll look at two ways to improve Scott's method. The first approach uses a table variable (just like ...
There was a question on the newsgroup a few months ago asking how to extract data from an Analysis Services cube and store it in a SQL table using SSIS. I responded saying that in theory you should be able to setup a connection using the OLE DB provider for MSOLAP 9.0 and then put an MDX query in place of the SQL text. And I even when as far as setting up a package and previewing the data to make sure this was a viable approach. To this point everything looked fine and I assumed that the next step ...
I'm stumped. I've got an instance of SQL 2000 (staging\staging2000) running on a box side-by-side just fine with an instance of SQL 2005. When I'm working in Visual Studio on the staging box, it works just fine. I connect and get into the 2000 instance of the database with no problems. As soon as I move over to my laptop (same configuration), I get ... An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that ...
SQL Server 2005 offers a number of new features over its predecessor, including many features aimed at making working with databases more like writing .NET application code. For example, in SQL Server 2005, stored procedures, triggers, UDFs, and so on can be written using any .NET Framework programming language (such as Visual Basic or C#). Another feature, and the focus of this article, is SQL Server 2005's support for TRY...CATCH blocks. Read An Easier Approach to Rolling Back Transactions in the ...
When you open Reports from within MS CRM 3.0 after installation, it is possible to receive an error stating something like "An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'xxx'. (rsErrorOpeningConnection)". The solution to this error is not easy because there are many possible reasons. Since I encountered this error several times now, I developed a solution strategy that works for me. Since there are also other peoples encountering ...
Yesterday, I knew that Microsoft has finally shiiped the SQL Server 2005 Service Pack 1 as a final release, not just CTP. I found some interesting information about it in the related knowledge base article (KB913090), and this Info World article. That's quite encouraging in fact. If you're sort of involved in this, you must have heard of the new amazing features of Microsoft SQL Server 2005. Not only SQL CLR and new ranking functions, the new XML and MAX data types (like NVARCHAR(MAX)), integration ...

Looks like service pack 1 of SQL Server 2005 (already?) will include the Management Studio with SQL Server Express.

Yippy!

Download Service Pack 1

Here there and everywhere: Paul Flessner of Microsoft has announced a new product -- SQL Server Everywhere Edition. It aims to provide “a lightweight, compact, but rich subset of the capabilities found in other SQL Server editions.” The new package will be able to synchronize with other SQL Server editions. It will also use the same programming model that other editions have. The first community technology preview or CTP of SQL Server Everywhere Edition is planned for this summer, with ...
Microsoft has already released their Service Pack 1 for SQL Server 2005. The Service Pack will address over 40 issues. I believe that this SP1 will allow us to use Database Mirroring functionality, which I am very happy about. Article at ComputerWorld http://www.computerworld.co... The Service Pack can be downloaded at http://www.microsoft.com/do... -paul ...
For a while I have been adding books to the library feed of this site one at a time. Here is a list of books that I currently keep on my “must have” bookshelf. I will update this periodically as new volumes are added and dropped. The Library link list will also stay syncronized. .NET 2.0 Visual Basic 2005: A Developer's Notebook ASP.NET 2.0: A Developer's Notebook Pro .NET 2.0 Windows Forms and Custom Controls Programming Microsoft ASP.NET 2.0 Core Reference Expert VB 2005 Business Objects, ...
SQL Server Reporting Services 2005 and Sharepoint WSS lists wierdness Here's a strange problem and how I got around it. I've been using SQL Server Reporting Services 2005 (SSRS) to do some reports based on data in a Sharepoint list. In the past I've had no problems getting all of the data that I needed, but for some reason this time SSRS just refused to get all of the columns from the WSS lists web service. There were 3 or 4 columns that were in the list, but would not return to the dataset that ...
or how Flash broke SQL A few weeks ago, my SQL Server 2005 installation lost the flat file data source option and could not import or export no matter the format. An error was thrown up. ===========================... connection manager could not be created from one or more data sources. (Microsoft Visual Studio)====================... The connection type "OLEDB" specified for connection manager "{F3C4B394-E196-4AFD-A2F6-3... is not recognized as a valid connection manager ...
You can reach my last featured article about Data Mining using Microsoft SQL Server 2005. Data Mining concerns analyzing data and finding hidden patterns using automatic or semiautomatic means, which are not possible to discover by simple seeing. Large volumes of data which comes from information systems have been accumulated and stored in databases. Organizations have become data-rich and knowledge-poor. The information found in the patterns can be used for reporting, and, most importantly, for ...
And I'll be there! It's at the Watermark Country Club at 6:00 PM. It should be a very good meeting, with Sahil Malik speaking about ADO.NET and John Cripe (of NuSoft) talking about SQL Server 2005.If you're there, say hi. I'll be wearing a black NationalCityHomeLoans.com shirt.Technorati Tags: grdotnet | Sahil+Malik | ADO.NET ...
There was a question recently on the Analysis Services newsgroup asking how to process an Analysis Services 2005 cube using XMLA from the command line. Below is a script based on Chris Harrington's excellent Thin Olap blog. This is the absolute minimum script required to get an Analysis Services database to process (ie. No error handling <g>). On my machine I processed my “Sandpit“ database (the sandpit is where I play) with the following command cscript xmlaProcess.vbs Sandpit ...
The Monster Mash: Try out a Microsoft Virtual Lab ExpressVirtual Lab Express is the fastest and easiest way to test drive Microsoft products and the Virtual Lab environment. These are 20-minute hands-on overviews of some of your favorite Microsoft products and developer tools. Try them out online now - no need to download full trial versions or dedicate test machines. Express Labs What's new in ASP.NET 2.0 What's new in Visual Studio Team System What's new in Visual Studio What's new in BizTalk Server ...
I have seen lots of .NET architect speak highly about NHibernate which I agree that is a great framework but I think that as it was ported from java they did not take the .NET advantages in consideration. I have tried for a while to use gentle.net framework which I found to be more of what I expected from a .NET framework as it uses attributes as it's mapping mechanism and by that you get in my opinion a better experience as a programmer. “Gentle.NET is a CLS-compliant, database independent ...
Here are some useful User-Defined String Functions for SQL Server 2005. Description AT()Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. OCCURS()Returns the number of times a character expression occurs within another character expression. CHRTRAN()Replaces each character in a character expression that matches a character in a second character expression with the corresponding character ...
Für alle .NET und SQL Server 2005 Interessierten aus dem Grossraum München: Am 06.04.2006 findet eine gemeinsame Veranstaltung der Pass Regional Gruppe Bayern und .NET User Group München. Thema : CLR Integration in SQL Server 2005Sprecher: Sebastian Weber, Microsoft DeutschlandAnmeldung und Anfahrtsbeschreibung: http://www.munichdot.net/Ev... [1] http://www.munichdot.net[2] Pass Deutschland[2] Weblog von Sebastian Weber ...
I did a presentation at the Melbourne SQL Server User Group this week on the proactive caching feature in Analysis Services 2005. One of the topics that I covered was the different notification methods that Analysis Services 2005 can make use of in order to discover that something has changed in the underlying relational source. The first notification method on the list is SQL Server notifications, but you will notice that as soon as you select this option a warning message appears at the bottom ...
When it is a SQL Server table variable! This topic came up a little while ago on the SQLDownUnder mailing list and surprised me because it went against most things I had heard about table variables. In fact a few days later I got a newsletter from SQLServerCentral.com with the following tip in it: If you need a temporary table in your Transact-SQL code, consider using a table variable instead of creating a conventional temporary table instead. Table variables are created and manipulated in memory ...
Download SQL Server Express 2005 it at : http://www.microsoft.com/do... It's free ... No management tool ? There is a separete download with a CTP of Management Studio which can connect to the Sql Express at http://www.microsoft.com/do... ...
With a stable version of Community Server finally out in the form of 2.0, John and I are investigating the transition. We have a few things to look at and we as a community need to realize that this site is more than a personal site. It is a real production system. Just like the ones you and I go to work with and maintain everyday. Have you ever heard you company say, lets upgrade to this new out-of-the-box system without any worries of how it will effect your company? I think not. Here are the things ...
I have recently had the opportunity to attend some SSIS training / workshops led by our DBA. Learning more about SQL Server has been on my list of TODO's for a long long time, but something better always came up (with more coding). But I have to say, I have been impressed with the functionality I have seen provided by Sql Server Integration Services. It is logical, there is coding, and you develop (yes, I said develop) using the Visual Studio IDE. It is one of the Business Intelligence project templates ...
I was having some trouble defining a "loopback linked server" in MS SQL Server 2005. By "loopback" I mean a Linked Server on a specific SQL2005 instance that actually links to the very same instance (albeit to a different DB) No matter which tricks I tried using in the "New Linked Server" dialog box in the new Microsoft SQL Server Management Studio, I just couldn't get my SQL Server 2005 instance to link to itself. Finally, I have the solution - Instead of using the Management Studio's UI, I ran ...
Here's the new blog from the BizTalk Product Team. Seems that BizTalk 2006 RTM is right around the corner here. Cannot wait for that as I am in the middle of the design phase at a large client and we are designing around 2006 and I was getting nervous that come May (start of construction phase) it still wasn't released. But I can finally sleep at night. We are also looking at using SQL Server 2005 Service Broker with BizTalk 2006 to replace an older MSMQ solution between two systems, and I'll be ...