sql server

Un-Making a List (or Shredding of Evidence)
In my previous blog entry , I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite%26hellip; We will take a comma-separated list and %26ldquo;shred%26rdquo; the individual items into rows. Let's start by creating and populating a test table: create table #CSVLists ( ID int ,Description varchar(30) ,CSVList varchar(200) ) insert #CSVLists select 1,'Stoog

Blog Content

t-sql

SQL SERVER %26ndash; Recently Executed t-sql Query
About a year ago, I wrote blog post about SQL SERVER %26ndash; 2005 %26ndash; Last Ran Query %26ndash; Recently Ran Query .� Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER. The Short Answer in is both of them will be deprecated. Please refer to following update query to recently executed t-sql query on database. SELECT deqs.last_execution_time AS [Time] , dest. TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APP

Blog Content

database administration

Aqua Data Studio 8.0 adds support for six more databases
by admin on October 15, 2009 AquaFold has launched a major upgrade to its database administration software, releasing Aqua Data Studio 8.0. The software is geared toward visualizing and working with multiple relational databases in a single view. Aqua Data Studio already supports Oracle, DB2 for iSeries, Microsoft SQL Server, MySQL, Sybase, Informix, apache Derby and PostgreSQL. Version 8.0 adds native support for new databases including Teradata, DB2 for z/OS, Sybase IQ 15 and nCluster.... Tag

Blog Content

sql server

Un-Making a List (or Shredding of Evidence)
In my previous blog entry , I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite%26hellip; We will take a comma-separated list and %26ldquo;shred%26rdquo; the individual items into rows. Let's start by creating and populating a test table: create table #CSVLists ( ID int ,Description varchar(30) ,CSVList varchar(200) ) insert #CSVLists select 1,'Stoog

Blog Content

ssas

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on ssas and SSRS by Sunil Kadimdiwan. He did a full int

Blog Content

sql server reporting services

%26ldquo;Client of JOB SOLUTIONS%26rdquo; recruits SR DBA sql
SR DBA sql Client of JOB SOLUTIONS Experience: 4 - 6 Years Location: Chandigarh, Mohali Compensation: Rupees 3,50,000 - 5,50,000 Education: UG - Any Graduate - Any Specialization,Graduation Not Required,B.Tech/B.E. - Any Specialization PG - Any PG Course - Any Specialization,Post Graduation Not Required Industry Type: IT-Software/ Software services Functional Area: Application Programming, Maintenance Job Description Design schemas. Build tables, FKs, PKs,Building queries, stored procedures,Eval

Blog Content

sql

Finish Wordpress Plugin
October 16th, 2009 Finish Wordpress PluginWe require modifications to an wordpress plugin.There is a fully functional existing version and a new version about 90% completed that requires finishing off.In addition you will create a new version of the plugin which will require you to change the name of the plugin and a few menus, and then to remove some functionality (it is a trial edition).The changes required are mostly cosmetic, but also there is some functionality in the old version which h

Blog Content

ssis

ssis: Archiving files with VB.Net
When creating ssis packages it's a common requirement to be able to archive the processed files. Here's VB.Net code snippet, with a quick walkthrough, that does exactly that. The script uses two variables, inFiles and archiveFiles . The variable inFiles contains the folder we want to move files from, and archiveFiles is the destination. Configure your variables in BIDS like below. Add a script task to the designer. Right click the script task, choose 'Edit'

Blog Content

ssrs

ssrs Performance Optimization and Analysis
Recently, I came across a very good article on ssrs Performance Analysis by Tom Mills using a tool called Fiddler . As the homepage of this tool states, "Fiddler is a Web Debugging Proxy which logs all HTTP(S) traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP(S) traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language." This article de

Blog Content

mssql

Integrate Optin Script
October 15th, 2009 Integrate Optin ScriptDear Freelancer,I have an Optin Script and an Optin Template.I Need to Integrate Optin Script to Optin Template.I Attached all Files.Payment Will be escrow. Thankyou. Regards, EsperanzaTradeSimilar JobsPhp Fox Expert WantedXml To mssql Db Script NeededVideo/picture Portfolio ScriptUpload ContentTroubleshoot Vb Script PageSwoopo Penny Auction CloneSimple Website To Be BuiltScript To Merge Csv DocsScript To Merge Csv DocsScript Installation Of TrafficScr

Blog Content

mssql

Integrate Optin Script
October 15th, 2009 Integrate Optin ScriptDear Freelancer,I have an Optin Script and an Optin Template.I Need to Integrate Optin Script to Optin Template.I Attached all Files.Payment Will be escrow. Thankyou. Regards, EsperanzaTradeSimilar JobsPhp Fox Expert WantedXml To mssql Db Script NeededVideo/picture Portfolio ScriptUpload ContentTroubleshoot Vb Script PageSwoopo Penny Auction CloneSimple Website To Be BuiltScript To Merge Csv DocsScript To Merge Csv DocsScript Installation Of TrafficScr

Blog Content

ssas

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on ssas and SSRS by Sunil Kadimdiwan. He did a full int

Blog Content

sql server

What Is Using The Most Space In Your Database ?
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database server with about 6TB of direct attached storage (DAS), I have to worry much more about space utilization. The stakes are also a little higher, since it is much harder to add space with DAS than with a modern SAN. There are several aspects to this problem, such as how large are your data files, how full are they, and how large are your database backup files. Within a database, you need to be

Blog Content

database administration

Oracle Certification Releases Live Exam: 1Z0-053 %26ldquo;Oracle database 11g: administration�II%26rdquo;
The new %26ldquo;Oracle database 11g: administration II%26rdquo; certification exam is now live in production. This new exam (1Z0-053) is a single exam requirement for those holding the Oracle database 11g Administrator Certified Associate (OCA) to earn to Oracle Certified Professional (OCP).Candidates can register now for the live exam, which is available at Pearson VUE testing centers worldwide with immediate scoring and pass/fail status. Candidates who participated in the beta can expect to receive your beta

Blog Content

mssql

Which version of MS SQL is supported?
Gossimer currently supports MS SQL Server 2005 %26ndash; 9.00.1399.06 (X64) Developer Edition (64-bit).

Blog Content

sql server reporting services

Unhandled Exception, Error while switching panels, SSRS, sql server 2005 reporting services
I tried to add reporting services today to my existing sql server 2005 instance on Windows 7. I installed it successfully however upon first run I faced an Unhandled Exception in WMI Component. Also when I clicked server Status or any other option it said unable to switch panels WMI error again. Well upon googling it for a while I found nothing useful and thought to dig it myself. I came to the conclusion that there must be some difference between Service packs. I queried my server and found tha

Blog Content

sql

Create An Ea Using Ichimoku
I'm using a forex strategies with 57.1% of success rate in manual trading so far. To eliminate the bad trades I would like to create an EA to check the trading conditions with 80% probability. I'm using Ichimoku indicator signals, 3 EMAs,traditional MACD cross overs with Fractals. I've tried to simplify the explanations. If you need further assistance please contact me. I've attached some screen shots and Ichimoku tutorials as well. =================================================== PRE CO

Blog Content

t-sql

SQL SERVER %26ndash; Comic Slow Query %26ndash; SQL Joke
Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detail report of the same at SQLAuthority News %26ndash; Community TechDays in Ahmedabad %26ndash; A Successful Event . After the event, I received many emails requesting the comic strip I had shown in my presentation. I had presented two different comic strips: one before the presentation and the other after the presentation. B

Blog Content

ssrs

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on SSAS and ssrs by Sunil Kadimdiwan. He did a full int

Blog Content

ssis

Dew Drop %26ndash; October 11, 2009
� Jump to: .NET / Visual Studio | Web Development | Design / Methodology / Testing | Silverlight / WPF | Podcasts / Screencasts / Videos | Community / Events | Database | Miscellaneous | More Link Collections | Book of the Day � .NET / Visual Studio Zune HD Level Program Written in XNA (John O'Donnell) Beware Uri.ToString and � Did FxCop tell you to use System.Uri? (Keith Brown) Mono, open source and Azure (Louis Salin) T4 Toolbox: Support for Visual

Blog Content

mssql

How do I Upgrade my MS SQL 2000 database to MS SQL 2005?
Follow the below mentioned instructions to upgrade your existing MS SQL 2000 database to MS SQL 2005: Take a backup of the current database. Click here to know how to make a backup copy of your db >> � Delete the database that you have just backed-up from your Gossimer Control Panel. Click here to know how to Delete your database >> � Add the MS SQL 2005 database from your Gossimer Control Panel. Click here to know how to Add a

Blog Content

database administration

Where Can I Find The database administration Option On Wordpress?
Question %26ndash; I have a blog on wordpress and I have to do this: Log in to your hosting account and from the control panel locate database administration. But I can'tsee the database admistration option.Where is it?Under what option? Related posts:Building Your Website With Wordpress (part 1)How Do I Update A Wordpress Account Installed With Fantastico?Moving Your WordPress (...continued) Related posts: Building Your Website With Wordpress (part 1) How Do I Update A Wordpress Account Instal

Blog Content

t-sql

SQLAuthority News %26ndash; Accessing SQL Server Databases with PHP
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, conne

Blog Content

t-sql

SQLAuthority News %26ndash; Accessing SQL Server Databases with PHP
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, conne

Blog Content

ssrs

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on SSAS and ssrs by Sunil Kadimdiwan. He did a full int

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

sql

Dolphin Boonex Site
October 9th, 2009 Dolphin Boonex Site have a site up needs work to be completed Similar JobsInstall Dolphin Boonex ScriptInstall Dolphin Boonex ScriptDolphin Boonex ProgrammerDolphin Boonex ProgrammerDolphin Boonex ProgrammerDolphin Boonex CustomizationDolphin Boonex Authorize.netCustomize Boonex Dolphin SiteViral Video SubmitterTraffic To Escort SiteSocial Network Due In 24 HoursSocial Bookmarking 10�10x200Simple Monthly Data EntrySimple Backlink GenerationSeo Traffic %26 Link BuildingSeo Pr

Blog Content

ssis

09 ott Carta d'identit�: TFA � Universit� Categoria: Insegnamento
Riguarda tutti coloro che in Italia vogliono intraprendere la carriera di insegnanti e al contrario della morta e sepolta ssis, scuola di specializzazione per l' insegnamento secondario, adesso il TFA eviter� il precariato, %26hellip;Fonte Articolo:Carta d'identit�: TFA � Universit�

Blog Content

sql server

What a backed up Database Mirror looks like
One thing you need to be careful about with sql server 2005/2008 Database Mirroring is making sure that you don't exceed the I/O capacity of the storage subsystem of the sql server instance where the mirrored database lives. If you do this with High Safety mode (synchronous) mirroring, your applications will be slowed down, waiting on the mirror. This usually happens when you do something that generates an unusual amount of log activity (such as index creation or maintenance, or shrinking a d

Blog Content

sql server reporting services

Unhandled Exception, Error while switching panels, SSRS, sql server 2005 reporting services
I tried to add reporting services today to my existing sql server 2005 instance on Windows 7. I installed it successfully however upon first run I faced an Unhandled Exception in WMI Component. Also when I clicked server Status or any other option it said unable to switch panels WMI error again. Well upon googling it for a while I found nothing useful and thought to dig it myself. I came to the conclusion that there must be some difference between Service packs. I queried my server and found tha

Blog Content

t-sql

SQL SERVER %26ndash; Queries Waiting for Memory Allocation to Execute
In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait on a memory grant will not appear in the resultset of following query. SELECT�TEXT , query_plan , requested_memory_kb , granted_memory_kb , used_memory_kb , wait_order FROM sys.dm

Blog Content

t-sql

SQL SERVER %26ndash; Queries Waiting for Memory Allocation to Execute
In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait on a memory grant will not appear in the resultset of following query. SELECT�TEXT , query_plan , requested_memory_kb , granted_memory_kb , used_memory_kb , wait_order FROM sys.dm

Blog Content

sql

How to change Min/Max Memory in sql Server?
Step 1: Open SSMS Step 2: Connect to desire Server and right click on the server (for i.e. sqldbpool) and Select properties � Step 3: Click on memory tab and configure Min and Max memory

Blog Content

ssas

SERIE DM Excel %26ndash; Parte 4: %26ldquo;Highlight Exceptions%26rdquo;
Bueno, en esta parte de la serie de miner�a de datos desde Excel 2007 les muestro un video donde uso la caracter�stica %26ldquo;Highlight Exceptions%26rdquo;, muy �til para encontrar informaci�n an�mala en un conjunto de datos. Podr�n ver que esta herramienta es m�s poderosa de lo que uno se imaginar�a, pues uno podr�a definir f�cilmente que tan exigente debe ser para determinar que un dato es an�malo, entre otras cosas. Les recomiendo ver este video, pues esta caracter�stica les puede ser muy �til y c�mo s

Blog Content

ssis

Data Transformation Services vs. ssis: The key differences
I recently published an article on� SearchSQLServer.com about� DTS and ssis where I talk about some of the differences .� Obvsiolly I didn't cover all the differences between DTS and ssis, just some of them.� So don't go railing on me that I didn't cover something. Denny

Blog Content

ssrs

Dew Drop %26ndash; October 7, 2009
� Jump to: .NET / Visual Studio | Web Development | Design / Methodology / Testing | Silverlight / WPF | Podcasts / Screencasts / Videos | Community / Events | Database | SharePoint | Miscellaneous | More Link Collections | Book of the Day � .NET / Visual Studio Imaginet and Telerik Introduce Free Team Workload Management Tools (Charles Sterling) Extending the Entity Framework Provider Model to support DDL (Alex James) Lightweight Debugging for Hybrid C#

Blog Content

sql server reporting services

Reordering the Table position in SSRS
New Question Created by UmaD

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

sql server

sql server string join
Today our dev team asked the question "Is there a way to join strings in sql server from a table output?" Immediately the DBA and I said yea concatenate. Well while that may be possible this might be an easier way. At first I though that using a select @var = @var + text would not concatenate across the table but it does. Ex. declare @blah table (text varchar(max)); insert into @blah values ('a'); insert into @blah values ('b'); insert into @blah values ('c'); insert into @blah values ('

Blog Content

sql server reporting services

Reordering the Table position in SSRS
New Question Created by UmaD

Blog Content

t-sql

SQL SERVER %26ndash; Interesting Observation %26ndash; Query Hint %26ndash; FORCE ORDER
SQL Server never stops to amaze me. As regular readers of this blog already know that besides conducting corporate training, I work on large-scale projects on query optimizations and server tuning projects. In one of the recent projects, I have noticed that a Junior Database Developer used the query hint Force Order; when I asked for details, I found out that the basic concept was not properly understood by him. Today, let us try to understand its working and the effect of this hint. Further,

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

mssql

Sugarcrm Email %26 Modules
October 5th, 2009 Sugarcrm Email %26 ModulesI need email automation setup for sugarCRM and custom modules set up. Here is the detail for this job: 1. i will only look at you response if you put your astrological sign in the subject line %26ndash; (there is too many responses from people that don't even bother reading these specs %26ndash; this is an attempt to cut down on this %26ndash; I don't actually care what sign you are 2. The mail automation i need is: when a contact is entered OR imported i need that to trigg

Blog Content

sql

Private Project for SICS (SalesMaker) by skyeso
Fix SalesMaker as we discussed. (Budget: $30-250, Jobs: PHP, sql)Originally posted here:Private Project for SICS (SalesMaker) by skyesoPosted in Latest Projects.Tagged with description, freelance, messages-posted, outsource, php, project, provider-rating, sql. Byadmin%26ndash;October 5, 2009

Blog Content

ssas

Software Database Engineer SQL Server BI SSRS SSIS ssas
WA Redmond, Software Database Engineer SQL Server, BI, SSRS, SSIS, ssas Description: Software Database Engineer Database Design T SQL, Business Intelligence SSIS, SSRS, ssas, SQL Server PerformancePoint and SharePoint We are looking for a talented, motivated, self starting individual to work on fast paced Business Intelligence projects for a support group for a variety of console, handheld and PC video game

Blog Content

ssrs

SQL Developer Anblicks Virginia Beach VA
SQL,ssrs,SSIS,DTS,Stored Procedures,Health Care experience,Triggers, REQUIRED Need 8+ years of experience. Strong in communication Strong experience in SQL... From Dice 03 Oct 2009 08:10:13 GMT save job, email, more...

Blog Content

ssis

SQL Programmer Info Technologies United States
Windows, Oracle, and SQL technology. As DCA continues... and maintaining SQL code SQL, T SQL, DTS, and ssis packages, OLAP and Data Marts in a Microsoft SQL... From Info Technologies 03 Oct 2009 05:18:06 GMT save job, email, more...

Blog Content

sql server

AppDev %26ndash; LINQ Using Visual C# 2008
AppDev %26ndash; LINQ Using %26ndash; Visual C Sharp 2008 DVD-iNKiSO | 1.3Gb In this course, you'll learn to use the exciting new .NET Framework 3.5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you'll learn about the new language features added to Visual C# in Visual Studio 2008 in order to [...] Related posts: AppDev sql server 2008 Installing Querying Security DVD AppDev ASP.NET Using Visual Basic 2008 Vol.1%262 AppDev Exploring Microsof

Blog Content

database administration

Navicat Premium 8.2.14
Navicat Premium is regarded as a easy-to-use as substantially as multipurpose multi-connections database administration agency that is created to earmark you to enter to MySQL, PostgreSQL and Oracle databases simultaneously within a azygos application, making database brass to binary kinds of database.Read original story of :http://wareseeker.com/Software-Development/navicat-premium-8.2.14.zip/3bea8c15bb Navicat Premium 8.2.14Tags: administration, connections database, database, databa

Blog Content

mssql

Cookie Unique Session Id
A cookie is already set up on website. It is downloaded when user logs in for the first time. 1. Give the existing cookie a unique session ID when it is first downloaded. 2. Every time the user revisits the website, and is already logged in or logs in, update the same cookie on their machine with a new unique session ID. Log the new unique session ID in the customer table on the database. Revisiting the website means visiting any of these pages: http://www.bankinggrapevine.com/default.asp h

Blog Content

sql

dbExpress driver for sql Server 4.55
dbExpress utility for MS sql Server (DbxSda) provides admittance to MS sql Server database. It entireness using broad action Microsoft OLE DB technologies. DbxSda supports MS sql Server 2005, sql Server 2000 and sql Server 7.Read original story of :http://wareseeker.com/Software-Development/dbexpress-driver-for-sql-server-4.55.zip/7d6478172 dbExpress driver for sql Server 4.55Tags: Access, DbxSda, driver, ms sql server, Server, sql, sql server 2000, sql server 2005, sql server 7, sql s

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

ssrs

Reporting Services (ssrs/MSRS) 2008 Error: Set used with the complement operator must have all members from the same level
When you use the Not In operator in a ssrs 2008 MDX query filter to exclude a named set, it uses a the complement operator in the constructed MDX. This is fine as long as "all members [are] from the same level." Since you got this error, they are not You can get around this by using the Except() MDX function instead of letting ssrs use the Complement operator In the ReportServerService log, you'll see something like this: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseExcept

Blog Content

ssas

Kerberos SPN Generation Setup Tool %26ndash; Common Tab
The last post %26ldquo; Kerberos SPN Generation Setup Tool %26ndash; Documentation, Instructions %26rdquo; gave a review of where to find help basically in the form of %26ldquo;Online Documentation%26rdquo; and the %26ldquo;Instructions tab%26rdquo;.� This is a continuation of the series of blog posts %26ldquo; Kerberos SPN Generation / Setup Tool %26rdquo; that describe how to use the Kerberos SPN Generation Setup Tool Beta for Kerberos Constrained Delegation with Microsoft BI tools.� This post covers the first Input section tab %26ndash; the %26ldquo;Common tab%26rdquo;.� You can downl

Blog Content

ssis

Odio freddo su Israel
Odifreddi, il Matematico impertinente , fresco prepensionato dell'Universit� di Torino come ha rivelato Campus , non ne vuol sapere di godersi il suo buen retiro dedicandosi alla sua attivit� di divulgatore scientifico. Giorni addietro, ha messo il cappello anche sulla polemica Israel , quella montata nei contro il docente della Sapienza, reo di aver guidato il tavolo tecnico ministeriale che ha lavorato alla riforma delle ssis , le scuole di formazione degli insegnanti.� Polemica che,

Blog Content

database administration

uCertify 1Z0-053 OCP: Oracle database 11 8.01.05
PrepKit OCP 1Z0-053, OCP: Oracle database 11g: administration II is an mutual code covering that helps you learn, tracks your progress, identifies areas for improvements and simulates theRead original story of :http://wareseeker.com/Home-Education/ucertify-1z0-053-ocp-oracle-database-11-8.01.05.zip/6c61b6eb0 uCertify 1Z0-053 OCP: Oracle database 11 8.01.05Tags: administration, database, improvements, interactive software application, OCP, oracle, oracle database, PrepKituCertify 1Z0-05

Blog Content

sql server reporting services

AppDev.Microsoft.sql.server.2008.Analysis.services.SSAS.DVD-iNKiSO
AppDev Microsoft sql server 2008 Analysis services SSAS DVD-iNKiSO ENG | ISO | 980Mb In this course, you will learn how to use Microsoft sql server 2008 Analysis services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes, cube storage and aggregation designs to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices [...] Related posts: AppDev ASP.NET Using Visual Basic 2008 Volume 2 DVD-iNKiSO AppDev sql server 2008 Ins

Blog Content

sql server

Customized test feed for SSP
Related Posts New SSP Blogger: John SansomSqueaking in just before Thursday's contest deadline comes our newest... sql server %26ndash; Difference between Line Feed (\n) and Carriage Return (\r) %26ndash; T-sql New Line CharToday, we will examine something very simple and very generic... Test post for MybloglogUndergoing MyBlogLog Verification... 71-450 Beta Test ReviewI wrote this test today. It was not bad. Some... Dev, Test and Production sql server environmentsFellow DBA Jason Crider asked me about my idea

Blog Content

t-sql

SQL SERVER %26ndash; SQL Server Management Studio and Client Statistics
Client Statistics is very important. Many a time, people relate queries execution plan with query cost. This is not a good comparison. Both are different parameters, and they are not always related. It is possible that the query cost of any statement is less, but the amount of the data returned is considerably large, which is causing any query to run slow. How do we know if any query is retrieving a large amount data or very little data? In one way, it is quite easy to figure this out by just lo

Blog Content

sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Content

sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Content

ssis

ssis - Avoiding the Sort Components
When using a Merge or Merge Join component in a data flow, your incoming data is required to be sorted. While it may be easy to drop a Sort component into your data flow, it may make more sense to perform the sort in your source query (if you are using a source such as an OLE DB Source component). If you decide to use an ORDER BY in your source and want to tell the ssis Data Flow that your data is sorted, follow the below steps: First, ensure that your data is being sorted with the ORDE

Blog Content

ssas

Senior DBA - SQL
Senior Database Administrator Urgent position for Senior SQL DBA. We are looking to recruit a self-starting, creative and innovative Senior DBA .Based in our Dublin office, this role requires an enthusiastic person who is committed to the role and sets their own priorities. The successful candidate will have the opportunity to work in an open, dynamic environment and collaborate closely with business users at all levels and serve a key role in designing, developing and maintaining complex and in

Blog Content

mssql

Magento Shopping Cart
I need a Magento shopping cart modification to allow the following functions. 1. To allow three groups of users to login to the site (extension will be provided). 2. Three different prices be assigned to each group (extension will be provided). 3. To allow users to print price lists, invoices and shipping notes and labels for their own [...]

Blog Content

database administration

Cross Country Infotech (CCI) Walk-in for Java, J2EE, Networking System Admin.
This job is posted by Tushar and available at itjobsdelhi.blogspot.com Cross Country Infotech (CCI) Walk-in on Sept, 19th 2009 at Pune Software Developer (4-10 years exp): Java, J2EE, Alfresco, ECM, Documentum, PeopleSoft, WebLogic, Data Warehousing, Business Objects, DataStage, Informix 4GL Infrastructure Management (4 to 10 years exp): System administration (Solaris / Unix / Windows / WebLogic), System Security, Networking, database administration (Oracle/Postgre

Blog Content

sql

Signpost
Sometimes I feel as if all I do is direct people where to find the things they are looking for. Much like a signpost does. Now, I am not complaining about this. In fact, I want to be the signpost for others. I have no problem helping people find the information they need. And that is what I am doing here as I point you to a new article of mine over on Simple-Talk . It is on sql Server consolidation and is based upon a series of blog posts I did here . I enjoyed writing on the topic an

Blog Content

sql server reporting services

sql server 2008 R2: Creaci�n de un informe de tipo mapa!
Siguiendo con las novedades que vienen con sql server 2008 R2, y en particular con la nueva regi�n de datos de tipo Mapa que tenemos disponible para crear informes en sql server reporting services 2008, en esta ocasi�n os dejo un v�deo demostrativo sobre como construir un informe utilizando este nuevo tipo de regi�n. El v�deo ha sido realizado por Alberto Rivera .

Blog Content

sql server

Java/J2EE Jobs: Team Lead Required for an IT Company
Posted on September 16th, 2009 Java/J2EE Jobs: Team LeadSkills: Java, J2EE, Springs, iBatis, JSF, Java Rebel, IntelliJ, Selenium, Ant, MS sql server, Servelets, SVNExp: 4 %26ndash; 6 YearsJob Description: Good track record. Knowledge of Hibernate, Spring FrameWork, Core Java, JSP, Servlets, JDBC Desirable Skills -Spring, iBatis, JSF, SVN, Java Rebel, IntelliJ, Selenium, Ant, MS sql server with 5 years of proven experience. Team Leading Capabilities. Experience on JUnit testing. Experience on any jav

Blog Content

t-sql

SQLAuthority News %26ndash; Download Microsoft SQL Server StreamInsight CTP2
Microsoft SQL Server StreamInsight is a platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for timely and relevant processing of data. StreamInsight allows software de

Blog Content

ssrs

BI Training Update
We are now in the finale of our training, the Final project week. In our final project we will develop a system that can be useful for Setfocus. Initially they sent us the relational database that served as basis for the development of the OLAP Database. On the first day, we developed a dimensional model in MS Visio and generate a script for the schema that we can use as our staging database. We just finished the ETL part using SSIS and tomorrow our target is to finish cube creation using SSAS.

Blog Content

database administration

Active Directory Plus
Click to enlarge Active Directory Plus 2.5.5.0 ADUC+ is an easy to use, drag %26 drop application based on Microsoft's Active Directory Users and Computers. It allows you to administer your own forest as well as any external domain you trust. With ADUC+ you can restore deleted objects WITH their properties, such as group memberships, exchange settings and telephone number. In fact, you can Roll Back any changes you make to your Active Directory or Network Environment. Suppose you have accidental

Blog Content

t-sql

SQL SERVER %26ndash; Plan Caching and Schema Change %26ndash; An Interesting Observation
Last week, I had published details regarding SQL SERVER %26ndash; Plan Caching in SQL Server 2008 by Greg Low on this blog. Similar to any other white paper, I have read this paper very carefully and enjoyed reading it. One particular topic in the white paper that caught my attention is definition of schema change. I was well aware of this definition, but I have often found that users are not familiar with what exactly does a schema change mean. Many people assume that a change in the table structur

Blog Content

sql

sql Server 2005 Setup Doesn't Recognize IIS 7 on Windows Server 2008 R2 x64
Have you ever received a warning message when installing sql Server 2005 that indicates that you do not have Internet Information Services (IIS) installed, even though you have and it is working perfectly fine? I ran into a similar situation when I was installing sql Server 2005 Enterprise x64 on a Windows Server 2008 R2 Enterprise x64 edition. Here's what the warning message looked like. Notice that the warning is related to the IIS Feature Requirement and ASP.NET Version Registration Requireme

Blog Content

mssql

Need Ajax To Use Comet
Hi, I have a page with data that changes with Ajax. I need it to send the data using Comet Push Technology instead. Please only bid if you are familiar with Comet. Place bid

Blog Content

database administration

OCA Oracle database 11g: administration I Exam Guide (Exam 1Z0-052)
OCA Oracle database 11g: administration I Exam Guide (Exam 1Z0-052) by Paperback: 733 pages Publisher: McGraw-Hill Osborne Media; 1 edition (May 2, 2008) Language: English ISBN-10: 0071591028 ISBN-13: 978-0071591027 Description of OCA Oracle database 11g: administration I Exam Guide (Exam 1Z0-052) A Fully Integrated Study System for OCA Exam 1Z0-052Prepare for the Oracle Certified Associate Oracle database 11g administration I exam with help from this exclusive Oracle

Blog Content

ssrs

Kerberos SPN Generation / Setup Tool
This is the first installment for a series of blog posts that describe how to use the Kerberos SPN Generation Setup Tool Beta in terms of documenting and helping you plan and creates SPNs for Kerberos Constrained Delegation with Microsoft BI tools.� The following is the outline of this series.� I will update this post as I complete the individual segments.� You can download the Kerberos SPN Generation Setup Tool Beta at RobertLambrecht.com .��� Rather than just complain about Microsoft no

Blog Content

t-sql

SQLAuthority News %26ndash; Risk and Health Assessment Program for Microsoft SQL Server %26ndash; Scoping Tool v1.2
This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server %26ndash; Scoping Tool v1.2 Reference : Pinal Dave ( http://blog.sqlauthority.com ) Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server

Blog Content

sql server

sqlAuthority News %26ndash; Risk and Health Assessment Program for Microsoft sql server %26ndash; Scoping Tool v1.2
This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft sql server. Download Risk and Health Assessment Program for Microsoft sql server %26ndash; Scoping Tool v1.2 Reference : Pinal Dave ( http://blog.sqlauthority.com ) Posted in Pinal Dave, sql, sql Authority, sql Documentation, sql Download, sql Query, sql server

Blog Marketing

ssas

Senior DBA - SQL
Senior Database Administrator Urgent position for Senior SQL DBA. We are looking to recruit a self-starting, creative and innovative Senior DBA .Based in our Dublin office, this role requires an enthusiastic person who is committed to the role and sets their own priorities. The successful candidate will have the opportunity to work in an open, dynamic environment and collaborate closely with business users at all levels and serve a key role in designing, developing and maintaining complex and in

Blog Marketing

sql server integration services

Lowongan Kerja Terkini sebagai sql server integration services - PT. Cygnet Pericon
PT. Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial services Industry in the Asia Pacific region.� Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance.� We also leverage on our partners' knowledge and world-class experiences to deliver global prod

Blog Marketing

sql server reporting services

Jessica Moss Reports On sql server reporting services
In this RunAs Radio podcast , Richard and I talk to Jessica Moss about sql server reporting services (SSRS). SSRS can replace typical reporting products like Crystal Reports, but also provides a tool for having users build their own reports. The conversation also moves into the Business Intelligence side of reporting, looking at how SSRS works with Analysis services to provide a deeper level of reporting. Jessica M. Moss, a Microsoft sql server MVP and business intelligence mentor with Solid

Blog Content

sql server reporting services

Jessica Moss Reports On sql server reporting services
In this RunAs Radio podcast , Richard and I talk to Jessica Moss about sql server reporting services (SSRS). SSRS can replace typical reporting products like Crystal Reports, but also provides a tool for having users build their own reports. The conversation also moves into the Business Intelligence side of reporting, looking at how SSRS works with Analysis services to provide a deeper level of reporting. Jessica M. Moss, a Microsoft sql server MVP and business intelligence mentor with Solid

Blog Content

ssis

ssis, SAS Developer jobs, walkin on Sat 12th Sept 09
Posted on September 10th, 2009 ssis DevelopersQualification: Any GraduateExp: 3-9yrsWalk-in Date: 12th Sept 09Time: 10:00am to 01:00pm Company Name: CTSLocation: PuneVenue:Cognizant Technology Solutions 3rd floor, Winchester, Hiranandani Business Park, Powai,Mumbai.Website: https://www.cognizant.comKeywords: CTS walkins, DataWarehousing, DBA, jobs in CTS, Jobs in Mumbai, Mumbai Career, Mumbai jobs, Mumbai walkins, SAS, Saturday Walkins, Software Developer, ssis, Walkin Mumbai, Weekend Jobs, We

Blog Content

mssql

Forum Posting Contest
September 10th, 2009 Forum Posting ContestI started a new forum at www.forum.trafficgeek.net that uses the forum script IP Board version 3 (IPB3). I wish to start a posting contest and need a utility program written to count the posts.I would like this program to do the following:Scan the mysql database and determine the top 10 posters within a specified date range.I would like to specify (or omit) certain forum sections from the post count. For example, I do not want to include the chat fo

Blog Content

t-sql

SQL SERVER %26ndash; SQL Server Desktop Screen Background
Buck Woody (MSFT) has published a blog post about SQL Server Desktop Screen Background. I really like the SQL Server Desktop background and I have replaced that background on my work laptop. I came across this particular post because I am regular reader of his blog. Few of the other interesting posts written by him are following. Who do I talk to in Microsoft about%26hellip; Test your Restores, or, a Cautionary Tale If due to any reason, the original image is moved, you can download the imag

Blog Marketing

ssis

Transaction Log Shipping Copy job update
I need to configure TransactionLogShipping of a database between two database servers. Primary database is on production server that is SQL Server 2008 Standard installed on Windows Server 2003 x32 (used as web server as well). Secondary database is on SQL Server 2008 Developer installed on Windows Server 2008 x64 (I'll use it as development database with almost up-to-date data for developing and testing heavy statistics reports). And both servers are in DIFFERENT networks. OK. Let's config

Blog Marketing

sql

Senior Software Engineer in Test
Skills/Requirements:� Experience testing distributed systems Worked on high volume websites, Understand of and interaction with an operations team, Influenced their development team to have testability designed into a product Expertise in Java + one or more dynamic languages

Blog Content

sql server reporting services

SSRS 2008: Como a�adir tus propias plantillas de informe!
Como sab�is, sql server reporting services (SSRS) cuenta con dos plantillas pre-definidas para crear informes. Una de ellas nos permite crear el informe desde cero (plantilla de tipo Report Item) y la otra a trav�s de un asistente (plantilla de tipo Report Wizard): Pero, �Podemos a�adir nuestras propias plantillas de informe? Por supuesto, lo �nico que tenemos que hacer en el BI Management Studio es: Crear la plantilla de informe base que en s� es un informe, pero que contiene

Blog Content

mssql

Cs-cart Modification
I am using CS-Cart for my site. I need someone to customize the template and improve some features including: _ News function with thumbnail ( on user interface and admin interface). This function is already on the site. Just a customization. _ Look and feel %26ndash; categories border and positioning. _ Integrate forum ( Vbulletin or else) All features are [...]

Blog Content

database administration

TECH SUPPORT-VOICE EXECEUTIVES REQUIRED
Location:Hyderabad/ SecunderabadKey Skills:Technical support,BE,BtechSpecialization:database administration (DBA),Client Server,Software EngineerJob Function:IT/Telecom - SoftwareIndustry:CRM/CallCentres/BPO/ITES/Med.TransQualification:School %26 Gra... Related posts: BPO Walk-Ins @ ACCENTURE : Customer / Tech Support : On 31 A 4 Sep 2009 HTML clipboard Customer Care %26 Support Executive Location:Bengaluru/ BangaloreKey Skills:communication skill,Specialization:Client Server,Tra

Blog Marketing

sql server

Checking Naming Conventions of MSsql Constraints and Indexes
If you create constraints and indexes in Management Studio, they are automatically named based on their type and the name of the table they belong to. If you create them manually, or overwrite their default names, naming may end up inconsistent. Here are two simple queries to check for naming conventions. Check that the constraint names match 'constraint type' + 'table name': SELECT p.name, CASE c.type WHEN 'F' THEN 'FK' WHEN 'D' THEN 'DF' WHEN 'UQ' THEN 'UK'

Blog Marketing

ssrs

Vertical Text Rotation in ssrs Text Boxes
If you are trying to make text display/rotate vertically, try changing the text box's writing mode to tb-rl.References:http://msdn.microsoft.com/en-us/ms189363.aspx

Blog Marketing