SQL Server Questions

Adhoc report for End users

Hilldrup — Fri, 07 Aug 2009 13:15:18 GMT

Hello everyone, I was wondering if any body is using an adhoc reprot tool for sql. We are trying to get our end user here to try to create some of thier adhoc reports. This tool would need to be at the end users level and not too technical. If anyone know of a program out there please reply. Have a good day

Kalen Delaney Training on the East Coast!

andy — Thu, 21 May 2009 02:01:23 GMT

http://sqlblog.com/blogs/kalen_delaney/archive/2009/05/19/public-course-in-boston.aspx

Kalen Delaney will be conducting training in Boston 12 - 16 Oct 2009. Kalen is awesome!

:{> Andy

February 2009 Presentation - Supporting DB Based Applications

rptodd — Fri, 13 Feb 2009 15:30:52 GMT

I enjoyed presenting last night, as always. Thanks everyone for the positive feedback. I've posted the PowerPoint slides in both 2003 and 2007 format. Let me know if you have any trouble with them.

Please let me know if you have follow-up questions, and I'll do what I can to help.

I would really appreciate constructive criticism, as my ultimate goal is to someday get a free conference at PASS as a speaker!

Cheers, Rick Todd

A few notes from last Thursday's presentation on SQL Server Mirroring

fibrock — Mon, 19 Jan 2009 13:12:52 GMT

In all of my excitement during the presentation I forgot to mention that the presentation pertained to SQL Server 2005 Developer and Enterprise Edition. Setting up a mirror environment that does not ultize one of these two version of SQL Server does not allow you to select High Performance mode. Also as one of our members pointed out to Ron, and later to me, you cannot take a snapshot of a database using Standard Edition. ( http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx) Well I hope everyone enjoyed the presentation, and if you have any questions about the presentation let me know. Thank you,Steve Fibich

SQL Server Merge

dldeskins — Wed, 19 Nov 2008 20:24:10 GMT

Hello, I am looking for a consultant.

I am a developer/admin with a MSSQL Server 2000 (SP4) on an inhouse machine with MS 2003 Business. We have doing merge replication to ecommerce sites, with the same version of MSSQL. This was all originally set up by me. All was well until i tried to delete a column with a store proceedure. When it failed, I went into EM and deleted the column (Publisher > Properties >Filter Rows). After I deleted the column, I expected the snapshot to rerun and merge to pick up again. It not only failed, but deleted all the tables on the ecomerce site and tried to replicate them from the snapshot. I went through several attempts to try to correct this problem, even at the last deleting the publisher and subscriber and starting all over.

I really need some help with this.

Don Deskins - Kingsport, TN

SQL Server v7 Stored Procedure Question

bee_kea — Fri, 19 Sep 2008 16:44:06 GMT

Was xp_MoveFile a standard SQL Server v7 extended stored procedure?

I am doing the initial research at moving legacy SQL Server v7
databases to SQL 2000 (hold all flames, since the entire server is
migrating, I lobbied for SQL 2005 at minimum).

There were two common errors. The first was a missing linked server
referenced by 4 SP's ... no big deal. The second error was a much more
abundant as far as counts:

"Cannot add rows to sysdepends for the current stored procedure
because it depends on the missing object 'master..xp_movefile'. The
stored procedure will still be created."

I can see the SP on the v7 Master DB. It points to a DLL that does
reside on the old v7 server. When I search Mircosoft's MSDN web site,
I don't get any results for either the SP or the DLL it referances. From what I
can tell, the SP takes as parameters a file path to an existing file
and a string:

IF (@result = -1)
BEGIN
SET @ErrorText = 'Unable to determine file size of ''' +
@FilePath + '''.'
EXEC AddError 0, @ErrorText
EXEC master..xp_movefile @FilePath, 'Bad'
END
ELSE
BEGIN
:
:

Any idea's?

SQL Server Product Roadmap Discussion - Microsoft Richmond Office - Start Date: 10/15/2008

znasif — Thu, 18 Sep 2008 21:07:10 GMT

SQL Server Product Roadmap Discussion

Location Microsoft Richmond Offices
9020 Stony Point Pkwy.
Richmond, VA 23235

October 15, 2008
9:00 am – 12:00 pmClick here to register. Are you planning new database projects in the next 12 months? Do you need to increase the scale of your databases, improve your developers’ productivity, or provide your users with new reporting and analytical capabilities? Microsoft® SQL Server™ 2008 is now available and provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission critical applications. Please join us for an interactive presentation and live product demonstration as we highlight the new features now available in Microsoft® SQL Server™ 2008 and preview plans for future releases. TOP NEW FEATURES· Use Resource Governor to manage concurrent workloads· Enforce policy compliance consistently across the enterprise with Policy-Based Management· Reduce storage requirements and increase query performance with data compression and sparse columns· Protect sensitive data with Transparent Data Encryption and advanced auditing· Troubleshoot, tune, and monitor SQL Server 2008 instances across the enterprise with Performance System Analysis· Build high performance analysis solutions with scalability, performance, data mining, and user interface enhancements in SQL Server Analysis Services· Take advantage of improved performance, usability, visualization, and integration with the 2007 Microsoft Office suites in SQL Server Reporting Services· Integrate location-enabled applications through support for spatial data Who Should Attend:This discussion is for Database Administrators and Developers who are familiar with MS SQL Server 2000 and 2005 and who are interested in learning more about the features available in SQL Server 2008.Prerequisites:General knowledge of SQL Server 2000 and 2005.RSVP: This special, no charge event will fill quickly and space is limited, so be sure to register as soon as possible to reserve your seat.

Location Microsoft Richmond Offices
9020 Stony Point Pkwy.
Richmond, VA 23235

October 15, 2008
9:00 am – 12:00 pmClick here to register. Agenda:· SQL Server 2000 support lifecycle changes· SQL Server 2008 overview and demonstration· Upgrading SQL 2000/2005 to SQL 2008· Upcoming SQL training resources and events Looking for ways to manage change of your database schema? If so, you may be interested in the afternoon session from 1-4pm which will focus on a discussion of VSTS Database Professional Edition.Click here to register for the afternoon session. Lunch will be provided from 12-1pm.

What is the best option?

Ravi Kallamadi — Tue, 10 Jun 2008 21:25:52 GMT

We have a SQL Server 2000 database on a production database server that has 3GB memory. The database size is 26 GB and there are 256 tables. Users have read access to the database server. They connect to the server using Access and run long running adhoc queries for reporting purposes. We have application performance issues and the following have been recommended to improve the performance:
1) Upgrade memory from 3gb to 8gb
2) Create another database on the same server for reporting purposes and copy production data every night. Users can run their queries on this new database. Set the database recovery model as Simple Recovery and mark the database as read-only.

The question is what is the best approach to automate the copy process every night?
1) Log shipping
2) Snapshot
3) DTS package

Thank you!

7/17/2008's Presentation - Lessons learned from the Colonial Williamsburg Data Warehouse Project

rptodd — Fri, 18 Jul 2008 17:21:31 GMT

Hey guys, I really enjoyed presenting last night, and look forward to doing it again at some point in the future!

I wanted to get everyone the presentations, but I couldn't figure out a way to upload a file here, so I put them here instead: ssis configurations and The Conformed Customer Dimension.

If you have any questions or comments about the presentation please post them here, and I'll do my best to answer you.

Cheers,

Rick

P.S. If you come to Colonial Williamsburg, drop me a line, and I'll try to spare a little time to show you around!

Check this cool site on LINQ...

Ravi Kallamadi — Fri, 13 Jun 2008 00:37:43 GMT

http://www.linqpad.net/

Technical Product Management

grayp — Wed, 09 Apr 2008 20:38:13 GMT

Anyone have any experience doing technical product management? We are starting the concept at work and I am being ask to play the product manager role for all of our BI products in terms of aligning technology with the business.

I think its a good opportunity but have been the primary architect for our BI products and am concerned about my tech skills atrophying.

I'm curious at other places how involved the product managers are with technical details.

HELP!

thirlstane — Sun, 04 May 2008 02:32:30 GMT

I'm trying to find wrk in the Richmond area, which has been hard, since it seems that major sites use SQL Server. I don't have any experience with SQL Server. I have experience with Oracle and SQL, and know something about SQL Server, but that is of absolutely no help at all. I don't see that I have many good options:

1. Get training. Long and expensive. Absolutely worthless unless tou can put it into use immediately. Online training is shorter but also expensive and equally worthless if you can't apply it immediately..

2. Take college courses. Cheaper, but takes four months.

The only other alternatives I can see are finding some source of free or cheap training, getting legitimate access to a SQL Server platform, or downloading something which emulates SQL Server. The second of these options seems very unlikely. There are probably more options which I have missed. My basic goal is to be able to get fast, cheap, self-paced, location-independent SQL Server training. ANy suggestions?

Thanks,

Mike

thirlstane@aol.com

Comparing SQL Mirroring to Clustering

wkhazzard — Fri, 21 Mar 2008 13:33:51 GMT

I'd like to hear the thoughts of other DBAs and Architects who've used both SQL Mirroring and SQL Clustering. My company, SnagAJob.com, is currently using SQL Mirroring for our production OLTP databases. We have issues almost every day: mysterious failovers, ADO.NET clients that repeatedly attempt to connect to the mirrored server instead of the primary (because they believe it's failed over). We're fairly certain that it's not networking issues because we see these same issues in our lab environment when everything is connected on a single gigabit switch. This would be a great topic for a future meeting, in my opinion, especially as more of a round-table type of discussion.