RichmondSQL

SQL Server 2012 RC0

fibrock — Thu, 29 Dec 2011 16:30:39 GMT

Get it while its hot, or at least still warm! SQL Server 2012

Quick Poll-What kind of presentations do we want to see this coming year?

fibrock — Sat, 24 Dec 2011 02:18:49 GMT

[Poll]

SQL DEVELOPER/DBA

James Goose — Thu, 29 Apr 2010 14:54:27 GMT

6 month Contract to Hire

Sr. SQL Developer

SQL 2005 and 2008.

Looking for someone to handle complex data sets

Plus: Consolidated database servers (taking 23 database servers to 4)

Converting SQL 2000 to 2005 or 2008

Needs a strong SQL developer with some administration skills

Experience with Microsoft stack is required (SSIS, SSRS, SSAS with focus on SSIS)

DTS packages (most have already been converted to SSIS)

Approx 160 -200 gigabite database

Aptitude and attitude are huge

They are looking for a Sr. SQL DBA with strong technical and management experience. This person will oversee 3-4 DBAs and report to the CIO and VP of Apps.

Leadership role is a bonus potential

phone screen and onsite interview (technical written test)

If interested in learning more please contact James Goose at jgoose@apexsystemsinc.com or by phone at 804-254-2600. I look forward to hearing from you!

BizTalk and SQL Server skills - 3 months contract to hire

andy — Thu, 15 Oct 2009 22:12:02 GMT

**There's more of a focus on the Biztalk piece than the ETL piece and the HL7/healthcare experience is not a "must have" either.

**3 month contract to hire in Richmond, VA

Special Requirements

Demonstrated skill and expert programming knowledge using Microsoft DTS/SSIS technologies to develop ETL applications; minimum of 5 years experience.
Demonstrated skill and ability in the development of database interface systems.
Demonstrated BizTalk experience with the Microsoft HIPAA accelerator or the HL7 accelerator desired. Minimum of 3 years work experience or Microsoft BizTalk certification w/ (1) year of experience.
Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems.
Experience in SQL Server 2005/2008 database design, development, and administration.
Any experience in the private or public healthcare industry relating to claims processing desired.
Demonstrated advanced experience in reviewing and trouble-shooting complex business workflow designs.
Ability to initiate and maintain cooperative relationships with co-workers, managers and supervisors, and customers/clients.

Anna-Helen Miller

Atlantic Resource Group

Recruitment Specialist

4880 Cox Road, Suite 100

Glen Allen, VA 23060

(p) 804-262-4400 ext. 26

(f) 804-262-4559

Sql Server DBA at SnagAJob.com

brockowen — Sat, 03 Oct 2009 14:42:40 GMT

http://www.snagajob.com/careers/#dba

ETL Programmer Analyst Team Lead

andy — Wed, 30 Sep 2009 21:39:21 GMT

ETL Programmer Analyst Team Lead

Candidates will contribute as an ETL team lead in the Data Management Group (DMG) responsible for design, development, and implementation of interfaces and conversions for the Medicaid Management Information System in Idaho.

ETL team duties include requirements validation, code development, source control, unit testing, and version deployment scripting. SQL and stored procedure expertise in a RDBMS environment required, Microsoft SQL Server 2005 T-SQL desired. ETL development expertise with Microsoft SQL Server Integration Services desired.

Team lead duties include working with a project manager to prioritize task assignments, progress tracking, and ensuring timely, yet accurate delivery, Mentorship acumen required. Full life cycle development experience required. Configuration and release management experience highly desired. Health information management experience highly desired. Excellent written and oral communication required. Some travel may be required (25% maximum).

SSIS Developer

andy — Wed, 30 Sep 2009 21:28:54 GMT

SSIS Developer

-SSIS and SQL development as well as Maintenance and Support
-Maintains information policies and procedures to support current and future data information needs.
-Ensures proper data definitions, ownership, use and integrity of data.
-Facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.
-Establishes and maintains excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues.
-Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.

Skills Required:
-STRONG SKILLS IN SSIS AND SQL are the most important!
-Knows ins and outs and techniques of SSIS and SQL
-Knows stored procedures, functions, and data modeling
-Someone who is an expert at process and will ask questions if design flaws exist
**Strong UNIT TESTING to unit test their work before it goes to Change management for system testing
-Extensive experience with SQL Server 2005 T-SQL and stored procedures required. (6 years)
-Experience with Microsoft SSIS required. (2 - 3 years)

-Requires BA/BS in related field and 6-8 years experience in data analysis, data modeling, and working with automated data warehouse systems, or any combination of education and experience, which would provide an equivalent background.
-Experience with programming languages and various statistical programs in addition to general knowledge of major components of managed care operations required.
-Excellent analytical, problem-solving and PC skills required.
-Excellent oral and written communication skills required.

Preferred Skills:
-Experience with large Data Warehouses and Data Marts preferred.

MySQL DBA/Architect

andy — Tue, 29 Sep 2009 21:01:28 GMT

I was reaching out in hopes that there was some outside chance you knew of any MySQL DBA/Architects that might be looking for a new gig. I know it is in a different technology space than your background but I was hoping for more of a Sr. Level Architect resource birds of a feather might flock together type connection!

In any event, the opportunity is in Indy and projected to go for about 12-18 months and could even convert should the opportunity fit everyones needs. I can certainly provide additional info should you think of anyone and would welcome any assistance. They are looking to move fairly quickly, we had a candidate that they were about to pull the trigger on but accepted another opportunity yesterday.

Thanks Andy and I look forward to hearing from you!

Tom W.

__________________________

Tom Whiteley

Synigent Technologies

4435 Waterfront Drive, Suite 202

Glen Allen, VA 23060

(W) 804.217.6861

(F) 804.217.6867

tomw@synigent.com

www.synigent.com

SQL Server DBA at Core Consulting, Inc.

andy — Mon, 28 Sep 2009 13:27:30 GMT

Core's on the lookout for a DBA. Could you distribute this to the SSUG membership?

SQL Server DBA:

The SQL Server DBA is responsible for supporting the SQL Server 2005 and 2008 databases and ensuring their performance, availability and security. Typical tasks include:
1)   Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
2)   Modify existing databases and database management systems or direct programmers and analysts to make changes.
3)   Test programs or databases, correct errors and make necessary modifications.
4)   Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
5)   Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
6)   Train users and answer questions.
7)   Establish and calculate optimum values for database parameters, using manuals and calculator.
8)   Specify users and user access levels for each segment of database.
9)   Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
10) Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
11) Review project requests describing database user needs to estimate time and cost required to accomplish project.
12) Review procedures in database management system manuals for making changes to database.
13) Work as part of a project team to coordinate database development and determine project scope and limitations.
14) Select and enter codes to monitor database performance and to create production database.
15) Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
16) Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
17) Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
18) Revise company definition of data as defined in data dictionary.

Candidates should contact me, Tim Tatum, or Bob Stolle at Core:

Tim Tatum
ttatum@coremgmt.com
Office: 804/371-0940

Bob Stolle
bstolle@coremgmt.com
Office: (804) 560-9486
Mobile: (804) 240-0273

Thanks,

Tim

Tim Tatum

Systems Consultant

Core Consulting, Inc.

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

Optimizing Performance in SQL Server Analysis Services - 23 Sep 2009!

andy — Thu, 17 Sep 2009 18:06:00 GMT

Topic: Optimizing Performance in SQL Server^®Analysis Services
Date: September 23rd, Noon Eastern
Abstract: In this session, you will learn about techniques to optimize processing and query performance in SQL Server Analysis Services. These techniques will include cube design techniques, processing considerations, relational tuning techniques, and MDX tuning options.
Speaker: Carl Rabeler is a member of the SQL Server Customer Advisory Team, with a focus on Microsoft BI. Carl has been working with Microsoft SQL Server and Business Intelligence for over 10 years as a consultant, mentor, writer, speaker and trainer before joining Microsoft in early 2006. Carl has written several SQL Server and Business Intelligence books and numerous technical white papers, has presented at many SQL Server and BI conferences, and has provided mentoring and consulting services for numerous companies around the world.
Location: Online, via Live Meeting https://www.livemeeting.com/cc/usergroups/join?id=September+Live+Meeting&role=attend
Special Note: We have changed Live Meeting accounts and will no longer be using a conference call bridge. Two way conferencing will be through Live Meeting. To use computer audio, you need speakers and microphone, or a headset. First Time Users Troubleshooting Unable to join the meeting? Follow these steps: To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting. 1. Copy this address and paste it into your web browser: https://www.livemeeting.com/cc/usergroups/join 2. Copy and paste the required information: Meeting ID: September Live Meeting Location: https://www.livemeeting.com/cc/usergroups If you still cannot enter the meeting, contact support

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

Back To the Basics

Tatum — Thu, 20 Nov 2008 14:37:35 GMT

In my opinion we get too many "slick new feature" type presentations.

What I would find most useful are more basic design/development/maintenance type topics.

Subject areas like designing for performance, designing for scalability, transaction processing system best practices would be great to hear.

Those subjects might not be terribly exciting. And I expect many members might think they're too remedial. But to me they'd be very useful.

Thanks,
Tim

More BI and Data Movement

rptodd — Thu, 20 Nov 2008 13:38:42 GMT

Hey, I'm partial because it's what I do all day, every day, but that's exactly why I want to see it. ETL and BI. SSIS and SSAS.

SQL Server Conversion

mhudson — Wed, 26 Nov 2008 11:50:53 GMT

Does anyone have experience they would like to share related to converting from SQL Server 2000 to SQL Server 2005 or 2008? We will likely all be involved in this process sooner or later. Advanced warning of tips and tricks would be worthwhile.

Mark

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!