mssql

Joomla Upgrade + Data Entry
What I have now: I have an install of joomla that is version Version 1.5.10. You will upgrade to version Joomla 1.5.14 . The reason for the upgrade is so that the most current version is used and so that the JCAL Pro calendar will function properly. What's wrong with JCAL Pro now? It does not show the [...]

sql server reporting services

SSRS %26ndash; Excel Unformatted Export
Have you ever had a report that was sorted, grouped, and met every requirement?� Assuming you did, have you ever had someone call you up and ask for your perfect report exported to Excel and then sorted in a different fashion?� Maybe they just want the raw data and not all the groups and formatting?� OK, this can be accomplished with a little work, but wouldn't it be nice to have a user export option to accomplish this task?� The current SSRS %26ldquo;Excel Export%26rdquo; option exports the groups and heade

ssas

SQL Server 2008 data warehousing video tutorials
Recently I stumbled upon some interesting SQL Server 2008 data warehousing screencast by Eric Hanson. Eric Hanson is the principal program manager for SQL Server data warehousing. Below mentioned are the links to these screencasts. SQL Server 2008 Configuring tempdb for Data Warehouse SQL Server 2008 Configure DW Storage SQL Server 2008 Star Join Query Optimization SQL Server 2008 Star Join Query to Excel Pivot Table

ssis

ssis: Reading and Writing to Variables in Script Task
A lot of people still consistently ask me about how to read and write to variables in the ssis script task. In this post I will demonstrate for you the two ways in which you can go about this, one from native ssis functionality and the other from code. In SQL Server 2008 both will [...]

t-sql

SQL SERVER %26ndash; 2008 %26ndash; Copy Database With Data %26ndash; Generate t-sql For Inserting Data From One Table to Another Table
Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER %26ndash; Insert Data From One Table to Another Table %26ndash; INSERT INTO SELECT %26ndash; SELECT INTO TABLE . Today, we will go over a similar question regarding how to generate script for data from database as well as table. SQL Server 2008 has simplified everything. Let us take a look at an example where we will generate script database.

sql server integration services

Using IBM's OLE DB Provider for DB2 with SSIS
If you have never used IBM's OLE DB Provider for DB2 with sql server integration services before, here's a step-by-step way to set it up.� Note that this is NOT Microsoft's OLE DB Provider for DB2, but rather IBM's OLE DB Provider.� IBM's iSeries Information Center has some good information about their provider.� This provider has to be installed separately from SSIS, so if you are developing locally, make sure you have installed the provider before completing the steps in SSIS below. Crea

sql server

Auto repair point of sale in vb2008.net
Work At Home and Earn Extra Cash For One Project! Need someone to write a windows application in vb2008.net using mysql database for a auto repair point of sale with reports. I have an existing application written many years ago in vb- ....... [ Read More ] If you're looking for a great way to make extra money, you've found it! Thousands of companies are in need of programmers and website developers, and new projects are available every day. Search through the listings for details! All o

ssrs

ssrs %26ndash; Excel Unformatted Export
Have you ever had a report that was sorted, grouped, and met every requirement?� Assuming you did, have you ever had someone call you up and ask for your perfect report exported to Excel and then sorted in a different fashion?� Maybe they just want the raw data and not all the groups and formatting?� OK, this can be accomplished with a little work, but wouldn't it be nice to have a user export option to accomplish this task?� The current ssrs %26ldquo;Excel Export%26rdquo; option exports the groups and heade

sql

Java Developer
Skills/Requirements:� 3+ years of experience using JSP, Servlets, Beans, EJBs, J2EE, XML 5+ years of Oracle sql, PLsql, and Teradata database experience Must have experience in front-end development skills in HTML, DHTML, JavaScript, Ajax, CSS, XML, XSLT Must have experience developing with Spring AOP framework and Hybern

database administration

Main Core, PROMIS and the Shadow Government (Pt. 4b) by Ed Encho
by Ed EnchoIn the first three installments of this series I examined the existence of the massive surveillance state database MAIN CORE and how similar tools of oppression are destroying American civil liberties. I also took a look at the criminality of many members of the Bush administration (especially Dick Cheney) and their crusade against The Constitution as well as Cheney's involvement in Continuity of Government programs. I wrote of the targeting of journalists by the rogue cabal operating

ssrs

SQL Server Reporting Services Chart %26ndash; Custom Y Axis Label
Of all the tools in my developer toolbelt none frustrates me the way ssrs frustrates me. Don't get me wrong %26ndash; it can be extremely powerful and given that it is packaged with SQL licensing becomes a little easier. But I have NEVER come across a tool that took so many dirty hacks, neat tricks or insider gotchas to get the job done. And I fear for the day that these combinations of hacks, tricks and gotchas need to be maintained but nobody remembers why things were written the way they were written

sql server integration services

Using IBM's OLE DB Provider for DB2 with SSIS
If you have never used IBM's OLE DB Provider for DB2 with sql server integration services before, here's a step-by-step way to set it up.� Note that this is NOT Microsoft's OLE DB Provider for DB2, but rather IBM's OLE DB Provider.� IBM's iSeries Information Center has some good information about their provider.� This provider has to be installed separately from SSIS, so if you are developing locally, make sure you have installed the provider before completing the steps in SSIS below. Crea

t-sql

SQLAuthority News %26ndash; Search SQL Server Solutions
So far, I have written over 1030 articles on my blog, and I have� received� an astounding� 12,000+ comments. Undoubtedly, it has acquired the status of a� huge database now! I nearly receive 200+ emails� and lots of comments on this blog every day. I do maintain a log of all the comments and emails received. As per my observation, I have already answered 90% of the questions asked via email in this blog earlier. I do my best to respond to each email and comment of my readers. Quite often, the

mssql

Osc Modules
Hi all, i need a few things done on my OSCommerce website. 1. A more informative product info page such as image enlargement, recommended products and what other customers bought other than that product (up selling and cross selling feature) 2. A postage and handling script such as ebay which works with AusPost DRC. Preferably in AJAX 3. [...]

ssas

Send Me Your Ideas
I normally ask people at my event sessions about blog topics. So now I am soliciting input on possible new blog topics.

sql server reporting services

reporting services - report snapshots
Una funzionalit� che trovo molto utilie di reporting services sono gli Report Snapshots . Cos'� un report snapshot? Uno Report Snapshot non � altro che una copia del report, eseguito in un preciso istante. Questa copia conterr� tutte le informazioni necessarie per permettere di visualizzare il report in un secondo momento, e avere lo stato al momento della sua creazione. Quando viene chiesto di salavare uno snapshots, reporting services esegue il report in questione e immagazzina t

sql

TRICHY FRESHER SOFTWARE JOBS %26ndash; ADELA SOFTWARE
Jobs in Trichy %26ndash; Freshers Software Job openings in Adela Software Trichy Experience:0 %26ndash; 1 Years Job Location:Trichy Education: B.Tech/B.E. %26ndash; Computers , MCA Job Description : Design, Develop, Build and Test products / web applications. Desired : 0-1 year of experience in application software development Should have excellent communication skills. Must have excellent analytical skills. Should have ability to work with a [...]

How to add a primary key to a table with existing data

The columns in the PK must be unique and NOT NULL. You may need to ensure these columns have unique data in them prior to setting the primary key. If the data is unique, the following statement (example) will work:

ALTER TABLE [dbo].[FactLocateOrdersSKUAggYear]
add primary key clustered (
[dw_order_year_key] ASC,
[dw_brand_id] ASC,
[dw_product_id] ASC
)

Cannot define PRIMARY KEY constraint on nullable column in table

This error occurs if you attempt to create a Primary Key with a column that is defined as accepting NULL values.

For Example:

CREATE TABLE [dbo].[FactLocateOrdersSKUAggYear](
[dw_order_year_key] [int] NOT NULL,
[dw_brand_id] [smallint] NULL
)

This error will occur if a PK is created that includes dw_brand_id. To resolve, drop any indexes that reference this column and then execute:

ALTER TABLE [dbo].[FactLocateOrdersSKUAggYear] ALTER COLUMN dw_brand_id smallint NOT NULL

How to Add a Foriegn Key Relationship to a table

ALTER TABLE [dbo].[FactLocateOrdersSKUAggYear] WITH CHECK ADD CONSTRAINT [FK_FactLocateOrdersSKUAggYear_DimBrand] FOREIGN KEY([dw_brand_id])
REFERENCES [dbo].[DimBrand] ([brand_id])
GO

ALTER TABLE [dbo].[FactLocateOrdersSKUAggYear] CHECK CONSTRAINT [FK_FactLocateOrdersSKUAggYear_DimBrand]
GO

Note: Datatypes must be the same for columns in the relationship or a data type error will occur.

How to change the datatype of a column on a table already populated with data

ALTER TABLE [dbo].[tablename] ALTER COLUMN column_name smallint

ssis

ssis Performance , ssis Debugging , ssis Development , ssis Tools , SSAS Tools , SSRS Tools , MS BI Tools - BIDS Helper
BIDS Helper is such a great tool that needs no introduction for MS BI Professionals , or rather I would like to used the word "Product" for it to honour its value. I feel that sooner or later, Microsoft should incorporate the functionality that it provides within BIDS or should flag it as an official Microsoft Recommended Add-In and ship it with some service packs. I would like to present below, some of the very useful functionalities that it provides for the ssis environment, functionalities

database administration

Airport Ethics %26 Tarmac Turtles: Grounds Crews Got 'em
� IT'S A TRUE TARMAC TURTLE TALE , an ethics story at� JFK International Airport in New York.��This�story�doesn't involve the usual airport personnel who not infrequently seem to show an absence of ethical consideration for passengers. Maybe it's the difference between indoor airport people and the outdoor guys. The suits versus the overalls. �Maybe it's the florescent lights inside the terminal, or the fatigued and fussy passengers� --also under those florescent lights. Grounds crews wo

ssrs

PerformancePoint Text Filter %26ndash; Configuration as easy as 1, 2, 3!
Previously, I've written about two PerformancePoint improvements.� The first idea was %26ldquo; URL Parameterization %26rdquo;, and the second was %26ldquo; Text Filtering %26rdquo;.� Both of these ideas were demonstrated in blog posts from a user's perspective.� If you ever had to create a PerformancePoint dashboard, then you are familiar with the concept for setting up a filter.� This post covers the process of creating a filter that has both of the new characteristics (%26ldquo; URL Parameterization %26rdquo;, and %26ldquo; Text Filtering %26rdquo;) from

sql server

sql server TRY-CATCH error handling
Thanks to four very talented and inquisitive developers who were taking my Implementing a Microsoft sql server 2005 Database class last week, I was encouraged to delve a little deeper into sql server's TRY-CATCH error handling structure.� (You know who you are, and thank you%26hellip;.) First implemented in sql server 2005, the idea was to introduce structured exception and error handling into sql server.� The general idea goes something like this: BEGIN TRY ����� END TRY BEGIN CATCH ����� E

database administration

Airport Ethics %26 Tarmac Turtles: Grounds Crews Got 'em
� IT'S A TRUE TARMAC TURTLE TALE , an ethics story at� JFK International Airport in New York.��This�story�doesn't involve the usual airport personnel who not infrequently seem to show an absence of ethical consideration for passengers. Maybe it's the difference between indoor airport people and the outdoor guys. The suits versus the overalls. �Maybe it's the florescent lights inside the terminal, or the fatigued and fussy passengers� --also under those florescent lights. Grounds crews wo

t-sql

With the srie Core I, Intel wants to clarify the nomenclature of its�processors
Stratgie %26ndash; the founder has annonc quil was going to return a simpler classification of his processors per order of power and to give up the rfrence of the platforms, like Centrino or Core 2 Duet. Core 2 Duet, Core 2 Quad, Centrino, Pentium, Celeron, Atom, as many names of processors and platforms with which one finishes by to lose. Conscious of the lack of lisibilit of its product ranges, Intel announces to want to put D `order a little at it. Thus the founder has it annonc qu `it returne

sql server integration services

Send Me Your Ideas
I normally ask people at my event sessions about blog topics. So now I am soliciting input on possible new blog topics.

mssql

Creloaded Multi Vendor Store
I currently have CRELoaded installed and running. I would like to see if someone knows how to enhance my store so that other vendors can register and then maintain their own part of the store and earn a commission of the sales of their products. My CRELoaded installation is setup primarily for video [...]

ssis

Fix ssis 2008 Error - The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."
When importing a datasource from a flat file today (a csv), (which ran through a Derived Column Transformation and then a Data Conversion Transformation before hitting SQL), I hit the following error in SQL Server Integration Services 2008 (ssis 2008): "Data conversion failed while converting column .....The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data." The dataviewers and error output ssis debugging techniques didn't

sql server reporting services

Conferencia S�cale el Jugo a sql server reporting services
Estimados, Hoy se realiz� una nueva charla del ciclo "S�cale el Jugo a%26hellip;". Esta vez el tema fue sql server reporting services. Isabel de la Barra present� SSRS 2005 y a mi me toc� SSRS 2008. Mi parte de la la presentaci�n esta disponible en el link de Presentaciones en este blog. La parte de Isabel la voy a subir una vez que ella me de permiso. Jejeje. Saludos, Technorati Tags: sql server , sql server 2008 , reporting services Posted in sql server, sql server 2008 Tagged: reporting Ser

ssas

Changing date fields in SQL Server Analysis Services
New Question Created by SQL Server Ask the Experts

ssas

Changing date fields in SQL Server Analysis Services
New Question Created by SQL Server Ask the Experts

mssql

Creloaded Multi Vendor Store
I currently have CRELoaded installed and running. I would like to see if someone knows how to enhance my store so that other vendors can register and then maintain their own part of the store and earn a commission of the sales of their products. My CRELoaded installation is setup primarily for video [...]

ssrs

PerformancePoint Text Filter %26ndash; Configuration as easy as 1, 2, 3!
Previously, I've written about two PerformancePoint improvements.� The first idea was %26ldquo; URL Parameterization %26rdquo;, and the second was %26ldquo; Text Filtering %26rdquo;.� Both of these ideas were demonstrated in blog posts from a user's perspective.� If you ever had to create a PerformancePoint dashboard, then you are familiar with the concept for setting up a filter.� This post covers the process of creating a filter that has both of the new characteristics (%26ldquo; URL Parameterization %26rdquo;, and %26ldquo; Text Filtering %26rdquo;) from

ssis

Fix ssis 2008 Error - The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."
When importing a datasource from a flat file today (a csv), (which ran through a Derived Column Transformation and then a Data Conversion Transformation before hitting SQL), I hit the following error in SQL Server Integration Services 2008 (ssis 2008): "Data conversion failed while converting column .....The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data." The dataviewers and error output ssis debugging techniques didn't

sql server integration services

Send Me Your Ideas
I normally ask people at my event sessions about blog topics. So now I am soliciting input on possible new blog topics.

database administration

Airport Ethics %26 Tarmac Turtles: Grounds Crews Got 'em
� IT'S A TRUE TARMAC TURTLE TALE , an ethics story at� JFK International Airport in New York.��This�story�doesn't involve the usual airport personnel who not infrequently seem to show an absence of ethical consideration for passengers. Maybe it's the difference between indoor airport people and the outdoor guys. The suits versus the overalls. �Maybe it's the florescent lights inside the terminal, or the fatigued and fussy passengers� --also under those florescent lights. Grounds crews wo

sql server reporting services

Conferencia S�cale el Jugo a sql server reporting services
Estimados, Hoy se realiz� una nueva charla del ciclo "S�cale el Jugo a%26hellip;". Esta vez el tema fue sql server reporting services. Isabel de la Barra present� SSRS 2005 y a mi me toc� SSRS 2008. Mi parte de la la presentaci�n esta disponible en el link de Presentaciones en este blog. La parte de Isabel la voy a subir una vez que ella me de permiso. Jejeje. Saludos, Technorati Tags: sql server , sql server 2008 , reporting services Posted in sql server, sql server 2008 Tagged: reporting Ser

sql server

Cumulative update package 3 for sql server 2008 Service Pack 1
The Cumulative update package 3 for sql server 2008 Service Pack 1 ( Build 10.00.2723 ) is available: http://support.microsoft.com/kb/971491/en-us And here you can get the whole information of builds that were released after sql server 2008 Service Pack 1 was released: http://support.microsoft.com/kb/970365/en-us CU tosc Technorati: Cumulative update package 3 for sql server 2008 Service Pack 1 Qui tacet, consentire videtur

t-sql

With the srie Core I, Intel wants to clarify the nomenclature of its�processors
Stratgie %26ndash; the founder has annonc quil was going to return a simpler classification of his processors per order of power and to give up the rfrence of the platforms, like Centrino or Core 2 Duet. Core 2 Duet, Core 2 Quad, Centrino, Pentium, Celeron, Atom, as many names of processors and platforms with which one finishes by to lose. Conscious of the lack of lisibilit of its product ranges, Intel announces to want to put D `order a little at it. Thus the founder has it annonc qu `it returne

sql

Oracle moves back in the 4th quarter, but reassures�nanmoins
Malgr a fall with the quatrime quarter of 7% its bnfice and 5% of its figure D `businesses, Oracle has rassur the investors, making climb the title out of purse. # Oracle has prsent the rsultats for its 4th closed quarter on May 31. The tendency is the fall, Mrs. if the ditor hte D `to charge this retreat the crisis. The figures are nanmoins suprieurs with waitings of the financial analysts. # By report/ratio Mrs. priode of the Anne prcdente, the bnfices move back thus of 7% (1,9 billion

ssis

Fix ssis 2008 Error - The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."
When importing a datasource from a flat file today (a csv), (which ran through a Derived Column Transformation and then a Data Conversion Transformation before hitting SQL), I hit the following error in SQL Server Integration Services 2008 (ssis 2008): "Data conversion failed while converting column .....The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data." The dataviewers and error output ssis debugging techniques didn't

ssrs

PerformancePoint Text Filter %26ndash; Configuration as easy as 1, 2, 3!
Previously, I've written about two PerformancePoint improvements.� The first idea was %26ldquo; URL Parameterization %26rdquo;, and the second was %26ldquo; Text Filtering %26rdquo;.� Both of these ideas were demonstrated in blog posts from a user's perspective.� If you ever had to create a PerformancePoint dashboard, then you are familiar with the concept for setting up a filter.� This post covers the process of creating a filter that has both of the new characteristics (%26ldquo; URL Parameterization %26rdquo;, and %26ldquo; Text Filtering %26rdquo;) from

sql server reporting services

Conferencia S�cale el Jugo a sql server reporting services
Estimados, Hoy se realiz� una nueva charla del ciclo "S�cale el Jugo a%26hellip;". Esta vez el tema fue sql server reporting services. Isabel de la Barra present� SSRS 2005 y a mi me toc� SSRS 2008. Mi parte de la la presentaci�n esta disponible en el link de Presentaciones en este blog. La parte de Isabel la voy a subir una vez que ella me de permiso. Jejeje. Saludos, Technorati Tags: sql server , sql server 2008 , reporting services Posted in sql server, sql server 2008 Tagged: reporting Ser

sql server

Cumulative update package 3 for sql server 2008 Service Pack 1
The Cumulative update package 3 for sql server 2008 Service Pack 1 ( Build 10.00.2723 ) is available: http://support.microsoft.com/kb/971491/en-us And here you can get the whole information of builds that were released after sql server 2008 Service Pack 1 was released: http://support.microsoft.com/kb/970365/en-us CU tosc Technorati: Cumulative update package 3 for sql server 2008 Service Pack 1 Qui tacet, consentire videtur

database administration

Airport Ethics %26 Tarmac Turtles: Grounds Crews Got 'em
� IT'S A TRUE TARMAC TURTLE TALE , an ethics story at� JFK International Airport in New York.��This�story�doesn't involve the usual airport personnel who not infrequently seem to show an absence of ethical consideration for passengers. Maybe it's the difference between indoor airport people and the outdoor guys. The suits versus the overalls. �Maybe it's the florescent lights inside the terminal, or the fatigued and fussy passengers� --also under those florescent lights. Grounds crews wo

ssas

Changing date fields in SQL Server Analysis Services
New Question Created by SQL Server Ask the Experts

t-sql

With the srie Core I, Intel wants to clarify the nomenclature of its�processors
Stratgie %26ndash; the founder has annonc quil was going to return a simpler classification of his processors per order of power and to give up the rfrence of the platforms, like Centrino or Core 2 Duet. Core 2 Duet, Core 2 Quad, Centrino, Pentium, Celeron, Atom, as many names of processors and platforms with which one finishes by to lose. Conscious of the lack of lisibilit of its product ranges, Intel announces to want to put D `order a little at it. Thus the founder has it annonc qu `it returne

sql

Oracle moves back in the 4th quarter, but reassures�nanmoins
Malgr a fall with the quatrime quarter of 7% its bnfice and 5% of its figure D `businesses, Oracle has rassur the investors, making climb the title out of purse. # Oracle has prsent the rsultats for its 4th closed quarter on May 31. The tendency is the fall, Mrs. if the ditor hte D `to charge this retreat the crisis. The figures are nanmoins suprieurs with waitings of the financial analysts. # By report/ratio Mrs. priode of the Anne prcdente, the bnfices move back thus of 7% (1,9 billion

sql server integration services

Send Me Your Ideas
I normally ask people at my event sessions about blog topics. So now I am soliciting input on possible new blog topics.

mssql

Php Video Site Like Vladtv
July 22nd, 2009 Php Video Site Like Vladtv I need a PHP template that would allow me to make a video site similar to worldstarhiphop.com , vladtv.com , or forbezdvd.com . I would like to have the option of embedding video from other websites like youtube, but would like to host some of the video from my own server. Would like to be able to play high def video too.I need them to play inside of my own custom flash player, similar to how they do it on the sites that I listed. The template must

sql server

Cumulative update package 3 for sql server 2008 Service Pack 1
The Cumulative update package 3 for sql server 2008 Service Pack 1 ( Build 10.00.2723 ) is available: http://support.microsoft.com/kb/971491/en-us And here you can get the whole information of builds that were released after sql server 2008 Service Pack 1 was released: http://support.microsoft.com/kb/970365/en-us CU tosc Technorati: Cumulative update package 3 for sql server 2008 Service Pack 1 Qui tacet, consentire videtur

ssrs

PerformancePoint Text Filter %26ndash; Configuration as easy as 1, 2, 3!
Previously, I've written about two PerformancePoint improvements.� The first idea was %26ldquo; URL Parameterization %26rdquo;, and the second was %26ldquo; Text Filtering %26rdquo;.� Both of these ideas were demonstrated in blog posts from a user's perspective.� If you ever had to create a PerformancePoint dashboard, then you are familiar with the concept for setting up a filter.� This post covers the process of creating a filter that has both of the new characteristics (%26ldquo; URL Parameterization %26rdquo;, and %26ldquo; Text Filtering %26rdquo;) from

database administration

Airport Ethics %26 Tarmac Turtles: Grounds Crews Got 'em
� IT'S A TRUE TARMAC TURTLE TALE , an ethics story at� JFK International Airport in New York.��This�story�doesn't involve the usual airport personnel who not infrequently seem to show an absence of ethical consideration for passengers. Maybe it's the difference between indoor airport people and the outdoor guys. The suits versus the overalls. �Maybe it's the florescent lights inside the terminal, or the fatigued and fussy passengers� --also under those florescent lights. Grounds crews wo

ssis

IT Training Videos From LearnItFirst.com: ssis 2005 Training Video .
Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details This is one of Scott's favorites - how to run an ssis job from a remote machine using a stored procedure called sp_start_job. In this...

mssql

AJAX Jobs : asp.net + mssql simple website with cms by kawd - AJAX .
the following tasks should be done 1. Home page shoud have an iframe where 'x' images would be scrolling (there should be a CMS that would control.

t-sql

IT Training Videos From LearnItFirst.com: SQL Server Programming .
Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL - view details Scott Whigham masterfully surprises us once again with this brilliant part 1 video on the proper syntax for the 4 part video...

sql server reporting services

Hello (cruel) World: sql server reporting services Chart %26ndash; Custom .
sql server reporting services Chart %26ndash; Custom Y Axis Label. Monday, July 20, 2009. Of all the tools in my developer toolbelt none frustrates me the way SSRS frustrates me. Don't get me wrong %26ndash; it can be extremely powerful and given that ...

ssas

Siddharth Mehta's Blog: SSIS Performance , SSIS Debugging , SSIS .
Blog related to SQL Server 2005 , SQL Server 2008 , Microsoft Business Intelligence - SSIS , ssas , SSRS , Performancepoint , MDX and Proclarity.

sql server integration services

David Klein's Corner: Fix for SSIS Error - The conversion returned .
When importing a datasource from a flat file today (a csv), (which ran through a Derived Column Transformation and then a Data Conversion Transformation before hitting sql), I hit the following error in sql server integration services ...

sql

sql 1044 Error - cPanel Forums
Hello everyone. I am having the dreaded mysql 1044 error "user @ localhost has no permissions......." I was wondering what i need to check.

SQL Server Best Practices

I believe that patterns and best practices are an essential knowledge base that every computer professional should always focus on keeping fresh.  As a process-oriented professional focusing on efficiency and reducing variation and re-work, I strive to find a toolkit of best practices that can be published to our DBA or BI Team's corporate portal.  This particular link is a great start for building a solid foundation of SQL Server best practices.  

http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

Welcome!

Greetings! My name is Richard Button and this is a new blog feeding on almost 20 years of database experience and focusing primarily on database technology, best practices, products, applied techniques, challenges, problems, and training.  Basically...Everything SQL.  

Products include, but are not limited to SQL Server (MSSQL), MS Access, T-SQL Querying, SQL Integration Services (SSIS), DTS (Data Transformation Services), and SQL Reporting Services (SSRS), SQL Analysis Services (SSAS/OLAP).

Topics are intended to range from simple database topics to advanced techniques and best practices.  Topics are meant to be "real world' applications of database administration, database development, business intelligence development, enterprise architecture, data warehouse design and implementation, support, break-fix, and so on.

My background covers all these areas from large companies like Sony, Honeywell Bull, Chicos to small companies like Miva, Findwhat.com, small real estate offices and medical offices, and individuals just wanting to learn a little database speak or building web or client based applications that are wired to an information store (database, spreadsheet, xml, file, or other repository).  I also have experience writing over 5000 technical articles, leading enterprise technical writing teams, architecting, developing, and deploying enterprise web applications, designing and integrating disparate information systems, building search and chat applications, and leading Six Sigma business process improvement projects.  All of these area's are fair game as one way or another, they can be tied to an information store - like a database.

Please provide as much feedback as you'd like.  My goal is to help people through me experience and conversations with colleagues and fellow bloggers!  This is my motivation and I hope you enjoy your visit.  Thank you!

Rich