SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

It's not you; it's us

Today we have a guest editorial from Gail Shaw.

By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those certifications are no longer being offered after Oct 1, 2013. The announcement was made in email, late on Friday night is the US, which was Saturday morning for those of us living in European/Middle East/African timezones.

To me the news itself wasn’t the worst part, though it’s bad enough. How the news was given was what hurt the most.

The announcement was sent late Friday evening (the sender's timezone), right before a US holiday weekend, by email.

That smacks of cowardice, of not being willing or interested in answering questions. Not offering explanations or dealing in any way with the inevitable fallout. Replies to the email resulted in an Out Of Office autoreply.

Some people have said it was like ending a relationship via text message (which I saw happen once. It wasn’t pretty). Personally I’m imagining it being more like ending a job by slipping a resignation letter under my boss’s door at 4pm on a Friday afternoon. I can’t even imagine how little respect I’d have for someone to consider doing that.

The people at Microsoft Learning (MSL) had other options. They could have delayed the mail until Tuesday morning, when there would be people in the office to answer questions, offer explanations, and otherwise act like they respected the people affected. They could have scheduled remote meetings for each of the product groups involved. After all, it’s not like there are millions of people who had to know. This would let them tell people ‘face-to-face’, with ample opportunity for questions, comment, explanations, etc.

They chose to send an email at a time that almost guaranteed there would be no explanations, no answers forthcoming for days. To say that the choice of time and medium upset people would be an understatement. The uproar has been loud to say the least.

The only explanation that has been offered was by Tim Sneath from Microsoft Learning, posted as a comment on a Connect item Saturday afternoon. Nice, but that should have been in the initial email, not posted in reaction to a plea many hours later.

Additionally some of his comments do not hold water under examination.

“We want it to be an elite community, certainly. But some of the non-technical barriers to entry run the risk of making it elitist for non-technical reasons. Having a program that costs candidates nearly $20,000 creates a non-technical barrier to entry. Having a program that is English-only and only offered in the USA creates a non-technical barrier to entry.”

Except those barriers were already being removed. SQL Server moved a few years back to an exam-only format where that $20,000, USA-only problem no longer existed. Back in June the same changes were announced for most of the other products (Training Optional for Microsoft Certified Solutions Master (MSCM) Certification). Those non-technical barriers to entry were already falling.

“Deciding to retire exams for the Masters program was a painful decision - one we did not make lightly or without many months of deliberation.”

“Many months of deliberation.” If that’s the case, why was there ongoing work with Prometric during those months to expand the numbers of exam centres that the exams were offered at? (Increased number of Prometric Test Centres) These centres no longer require the Redmond-based training component  and were in many different countries, substantially increasing the availability of the certification exams.

Surely if there were high-level discussions about cancelling a certification, you wouldn’t still be signing people up for forthcoming training rotations? (See George Roubchinsky’s and Jorge de Almeida Pinto’s comments on the same Connect item above). Were there really months of deliberations that apparently few to no others in MSL knew about?

“Over the next couple of months, we'd like to talk to many of you to help us evaluate our certifications and build something that will endure and be sustainable for many years to come.”

Right…  “Fool me once, shame on you. Fool me twice, shame on me. Fool me thrice….” I don’t think so.

Let’s say in 6 months’ time MSL comes up with some new top-level certification. How long will it take for people to trust them again, after this little botch-up? How long will it take for that new cert to have any market awareness? The MCM was just starting to gain some traction and awareness when MSL changed the name to MCSM. And if that new certification hasn’t gained appreciable traction after a year or two, will they throw that one away as well and start afresh once more?

What does that leave us with? The MCSE as the top of the Microsoft certifications? Don’t get me started on that name. I suspect if I put MCSE on my CV I’ll have people asking me to configure routers and set up mail boxes. Then there’s the use of the word ‘Expert’, which I personally hate.

I mean, the MCSE is such a well-respected certification, surely anyone with that cert knows what they’re doing? Right?

Right. The dumps and usage thereof aren’t the sole problem, nor are the bootcamps that cram into a candidate just the knowledge they need to memorise and nothing more. The MCSE and other certifications just don’t test for technical competency well enough.

I wrote (and passed) the exam “Implementing a Data Warehouse with SQL Server 2012” during the beta-program. If you look at the skills measured, that exam covers SSIS mostly, with some DQS (Data Quality Services) and MDS (Master Data Services)

I’ve never used MDS, I’ve never used DQS, I’ve never used SSIS 2012 and I’ve never done more than basic data flows in SSIS 2008 and I didn’t study at all. What exactly can passing that exam tell me about someone? Not much apparently.

This decision, along with the recent ending of TechNet sends a poor message about just how much Microsoft values the people working with their Enterprise server products and about how much they value the people with deep technical knowledge of their products. Or maybe I should say how little.

From my side, message received Microsoft. Message received, loud and clear.

Gail Shaw from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

ADVERTISEMENT
SQL Prompt

Make working with SQL a breeze

SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

SQL Monitor

Optimize SQL Server performance

“With SQL Monitor, we can be proactive in our optimization process, instead of waiting until a customer reports a problem,” John Trumbul, Sr. Software Engineer. Optimize your servers with a free trial.

sqlinthecity

SQL in the City – Free SQL Server training in the US

Don’t miss out on learning about best practices for SQL Server database development and administration from top SQL Server MVPs. Sign up to a free seminar or event in San Diego, Denver, Pasadena or Charlotte. Find out more and register

Featured Contents

 

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

Ben Miller from SQLServerCentral.com

What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool. More »


 

Opportunity for Business Intelligence developer

Press Release from Red-Gate

Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters. More »


 

New Enhanced Column Store Index in SQL Server 2014 – Part 1

Additional Articles from Database Journal

Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses compression aggressively to reduce the disk I/O needed to serve the query request. In this article, Arshad Ali talks about the new enhanced columnstore index feature in SQL Server 2014. More »


 

From the SQLServerCentral Blogs - Query Stats

SteveHood79 from SQLServerCentral.com

DBAs rarely use the full potential of sys.dm_exec_query_stats.  It’s common to see the queries for looking at the most expensive... More »


 

From the SQLServerCentral Blogs - Learn SQL Server Performance Tuning Basics in a Single Day

jsterrett from SQLServerCentral.com

Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction... More »


 

From the SQLServerCentral Blogs - Exploring Excel 2013 for BI Tip #11: Color Scales

DataOnWheels from SQLServerCentral.com

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly... More »

Question of the Day

Today's Question (by Vinay Kulkarni):

What technique is used by the SQL Server to maintain Durability of Transactions?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: ACID.

We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the Contribution Center.

ADVERTISEMENT

SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Dwain Camps):

What is the difference between the following 2 queries:

-- 1
SELECT ROW_NUMBER() OVER (ORDER BY NEWID())
 FROM sys.all_columns

-- 2
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NEWID()))
 FROM sys.all_columns

Answer: No difference.

Explanation: There is no difference. Because NEWID() is a non-deterministic function it returns one value for each row. It doesn't matter if the returned value is enclosed within a sub-SELECT or not.

Ref: NEWID() - http://msdn.microsoft.com/en-us/library/ms190348%28v=sql.105%29.aspx/html


» Discuss this question and answer on the forums

Featured Script

Add user with DDL Trigger

Teshome Asfaw from SQLServerCentral.com

DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.

1. Copy and paste the code on managment studio

2. Make sure you change the @username to the name you want

3. Make sure the username exists

4. run create database <db_name>

5. check if the user is added to the role in the created databse

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2014 : Administration - SQL Server 2014

Execution Plan Drilldown Issue - I am trying to list the execution plan in xml (SET SHOWPLAN ON) of a given sp in a query...

Help with sql statement - I am new to vb and sql . please bear with me I have a database name database 1. I have...


SQL Server 2012 : SQL 2012 - General

Using WMI alert for mirroring in Sql server 2012 - We are using mirroring in Sql Server 2012 and we are using WMI alerts for some of events such as...

SQL Server Full to Simple to Full Recovery Model - Whenever I have a huge log file for any database with Full as its recovery model This is what I do...

Understanding messages about long checkpoint - Hi all Lately I've seen some messages about long checkpoints in our server. The messages look like this: FlushCache: cleaned up...

Two languages for full text search. - Hi, we have a column in a table in wich data is stored in a varbinary(max) field. The data is stored in...

Minimum Active Directory required for SQL Server 2012 Enterprise - I have had a request from our Network Admin as to "what is the minimum level of Active Directory required...

AAG Backup - Hi all I have 2 doubts on this can anyone please clarify: On primary for system database backup I have...

How to login using sqlcmd - Hi, my rdbms version :2012 sqlexpress I created the login using the below commands: [code="sql"] SETUSER GO USE master GO IF EXISTS( SELECT * FROM sysdatabases WHERE name='permissionsDB' ) DROP...


SQL Server 2012 : SQL Server 2012 - T-SQL

how to combine more than one SET operator correctly, to solve problem - It's come to my attention, from taking SQL Server 2012 practice tests, that I don't know how to combine SET...

Comlplicated query help - I have a query that I run as a stored procedure. It was written by someone else, and I am...

MDX/SSRS Chart Question - I have the following MDX query pulling information for a chart that shows hours worked (Values) by month (Category Group)...

ISNULL results - Hi there, I have two super queries below that go off and for a 'Job Ref' pulls back the 'Number...

Cannot convert valid Char(24) date/time to date/time data type - Hi, I have collected some data using TYPEPERF. This command creates tables in the database specified in a DSN. The table with the...

Msg 4862, Level 16, State 1, Line 1 - with reference to OPENROWSET (TRANSACT-SQL) http://technet.microsoft.com/en-us/library/ms190312.aspx example E data [code] 1 Data Item 1 2 Data Item 2 3 Data Item 3 [/code] no-xml format file [code] 9.0 2 1 SQLCHAR 0...

Pagination options SQL 2012 vs 2008 (Performance perspective) - I need to understand which one is better with respect to performance : 1. SQL 2012 has introducted FETCH OFFSET ... SELECT...

How many columns in INCLUDED Index are 'Too Many' ??? - Dear All, I have a query that takes [b]22 seconds[/b]. If I create below index then query finishes in [b]5 seconds[/b], but...

Need to iterate through sets - I have a Project master table (tblProjects). Each project has zero or more Work Orders in the work order table...


SQL Server 2008 : SQL Server 2008 - General

make VARCHAR field longer on a large table - >>>>Scenario: SQL Server 2008 R2 on a Windows cluster, 256 GB RAM, 32 CPU there is a non-partitioned table with 2.5 Billion...

Query Help - Hello Everyone I need to develop something in my logic. I have one code '7MTWRF', this is string and i need...

SSRS, merge/use data from 2 .rdl - Hi, I have SickDays.rdl and Encounters.rdl, they both independent reports in SSRS and implemented as stand alone RDLs. Now I want...

Difference Between Restore And Attach - What is the difference between Attach And Restoring a Database in Sql Server?Looks like a Simple question?please folks share your...

Condition requirement - Hi, I am trying to do a lookup in SQL and have to create a SQL code for the following condition...

How to install SSIS/SSAS/SSRS - Hello, Was curious if someone could help or point me in a direction. We have SQL 2008 installed and as part...

[Microsoft][ODBC SQL Server Driver]Login timeout expired - hi everyone! i am a student working with SQL SERVER 2008R2 on windows 8 64-bit os.. from a month i...

SQL 2000 Install - I need to install SQL 2000 on a VM that already has 3 instances of SQl 2008 R2 installed. Something in...

Transaction Log Functionality Question - I know Gail will have the answer, maybe someone else will too. I have a database that will fill up the...

Sql Server Objects Naming Conventions - Hello all I have recently been tasked with putting a naming convention in place for a new Sql Server Database/Project. I...

Servr patching install - Hi, I need to update sp2 and cumulatives in our sql server r2 2008. i could see in microsite site that...

How to update string based on Dates. - Create Table #temp ( Lnno varchar(15), Inst_Date Datetime , Amount Numeric(12,2) ) Create Table #temp1 ( Lnno varchar(15), No_of_Month Int, Date_Pattern varchar(15), ) Insert Into...

Shrink the database only upto its initial size which is set - I have some database which are already created which are already created with default initial size. But i want to...

UNION or UNION ALL? - Is it better to use union or union all for combining two select statement queries..?? I am checking a SP where...

Error log in eventvwr - Hi friends, Am receiving the below log in eventvwr. Why am I getting this log? Please help me to get rid...

Please help with a Trigger - Hi There, I have just joined this great forum. I have a question regarding Triggers pls I have a table dbo.Levels and I...

Updating using # table - Please help me to update the columns using a temp table by using inner join for a set of tables...

Match Varbinary(max) with another Varbinary(max) - i have a table with one binary column. that contains 0x00010100000101010101......00 column datalength is 35040, i am prepare this data...

sql 2012 dumps - Can any one send the sql 2012 dumps for getting the certified ?

fill the missing/incorrect values for the gender column - Hi I have a gender column like this: Gender -------- F AAA M null F M null Can some give me an idea how can I create and implement a strategy...

Not able to select match and non match by left join - I would like to check category by lob that exists or not on the basis of @Match Parameter. I can do...

Test and document recovery scenarios - I have to test and document possible recovery scenarios in SQL Server 2008 R2. I can think of the following scenarios....

List objects to move - In one database(Order), all my objects (in this db, some objects are not my app) for a app have to...

Dynamic SQL and DATEADD with User Defined Variable in Number/2nd position - This syntax SET @sql = 'SELECT * FROM <sometable> WHERE dateadd(hh, ''' + @tzoffset + '''), END_DATETIME) BETWEEN ''' + @StartDate + ''' AND ''' + @EndDate + '''' returns this error Conversion failed when converting...

Fastest way to read a 600MB table (in memory) - A few days ago I came across this interesting problem: I cannot get more than 15-19mb/s is there any limitation that...

Cannot open New SSIS Project in SQL Server 2008 R2 - I installed SQL Server 2008 R2 and Visual Studio 2008. However, after several installations and un-installations. I could no longer...

Activity Monitor - % Processor Time Grayed Out - Does anyone know why the % Processor Time area within Activity Monitor would be grayed out?

There is insufficient system memory in resource pool 'internal' to run this query" - Hi, We have a certain customer running SQL 2008 64bt Standard, windows 2008 std. The server is using about 3.8GB of...


SQL Server 2008 : T-SQL (SS2K8)

Converting GMT to EST - I need to write a function that converts a time from GMT to EST taking daylight savings time into consideration....

help me for Find and replace - i have the following strucrue and the data as folloows [code] DECLARE @DetTbl AS TABLE (id INT IDENTITY (1, 1), Detail NVARCHAR...

Table dependencies - Hi, I want to get the list of dependency tables(through all the levels ie child of child) that are depends...

IF Statement based on Multiple SELECT Statements - Hi Basically, I'm attempting to write a statement based on multiple conditions. So, there will be 2 SELECT statements, IF the...

Finding row number which caused the error in Table value parameter insertion - Hi I am trying to write a Bulk import procedure, i am using table value parameter to insert thousands of rows...

Split Data - Hi All, I have written 3 queries and put them in 3 cte statements each is a different report. 1. FCR...

sql query - Thanks, RT

sp_getrecords to get all records from a table - Hi, I have tried and created one sp which will get the table name as input and will return all...

How to insert multiple rows into a table with identity column - Hi, I am having trouble inserting the multiple rows into a table with identity column. The error i get is... An explicit...


SQL Server 2008 : SQL Server Newbies

Advancing Knowledge of Subqueries - I am currently reading through Itzik-Ben-Gans [i]Microsoft SQL 2008 T-SQL Fundamentals book[/i] and I've made sense of it so far....

Please help on these error messages - Please help, I am getting these error messages. Msg 156, Level 15, State 1, Line 38 Incorrect syntax near the keyword 'AS'. Msg...

error:Setuser failed because of one of the following reasons: the database principal 'schemaUser' does not exist, - with reference to http://technet.microsoft.com/en-us/library/ms191534(v=sql.100).aspx I copy the commands word by word [quote] E. Granting VIEW DEFINITION permission on an XML schema collection SETUSER GO USE...


SQL Server 2008 : Security (SS2K8)

Tracking User access to a database on SQL 2008R2 Standard - Hi I am new to SQL 2008R2 Standard edition and I have been requested to track users/l ogins trying to access...


SQL Server 2008 : SQL Server 2008 High Availability

SQL 2008 Mirroring + Mirroring + Log Shipping - Using SQL 2008 R2, 1. Can I create either a Mirror off of a Mirrored database, or can I create...


SQL Server 2008 : SQL Server 2008 Administration

Memory settings in SQL SERVER - I have 4GB Ram on OS and What will happen to my SQL server if i configure Min memory settings...

sql server using more memory issue - sql server is 2008 r2 on 64 bit systems and os is windows 2008. Hi friends at one of our client...

unable to connect to server - Hi all. here we are trying to connect to server which is not accessible and it through the below error. Error:The operating...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Cost in Execution Plan summing up more than 100 - Hello All, In rare cases, I saw some strange behaviour in the execution plan. What I believe is that it...

UPDATE Query gets stuck as a part of the procedure but completes fine when run independently - One of the update query which updates a column after joining records from seven tables gets stuck indefinitely when it...

Primary Key and Clustered Index: how to set in this example? - hi there, hope it's the right forum ;-) I have an example where I am not sure about setting my primary key...

Question related to missing index DMV's ? - This formula is given by microsoft to find out the index performance impact "user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 )". But what is...

intermittment slow data modification on sql 2008 r2 - Hi Folks, I am working with sql server 2008 r2 standard (build 10.50.4000) Occasionally (not all the time) we get slow data...

urgent help with stored procedure performance tuning - I have a stored procedure to do the performance tuning, so below are the list of questions could someone please...


SQL Server 2005 : Administering

Delete .bak & .trn - Anyone has a script which would delete old backups (7 days old) in each database directory folder. The backups are...


SQL Server 2005 : SQL Server 2005 Compact Edition

Duplicate Rows in certain time - Hello, i had this problem allready in a normal SQL Server Version and solve it with CTEs or Cursors. Now I have...


SQL Server 2005 : SQL Server 2005 Security

How to deny restore database in sql server to SA? - Hi need a help ? Mistakenly restored the prod database instance instead of development and i am having full privelage(sysadmin) on...

Cannot connect to SSIS from SSMS - I am using SP2 and cant connect to SSIS from SSMS. Also, I have another problem. I try to connect...


SQL Server 2005 : SQL Server 2005 Performance Tuning

Adding Indexes produces faster execution times, but not the numbers to support it - I took a database and use SQL Profiler to trace the data while a computer program executed a complete cycle...

Types of Wait do we see.. Query using Paralleism !!! - Hi All, Can i have to know while a query is getting executed then...What type of wait do we see ... If...

Different Execution Plan on different servers - Hello all, i have a query, on T environment it performs fine (20 seconds), but on Q environment not (6 minutes)...


SQL Server 2005 : SQL Server 2005 Integration Services

SSIS help - I manually run reports now in the following manner: Run two different sql scripts that pull data from yesterdays date, I...

SSIS REPLACE Double Quote - I was trying to use the Replace function in the Derived Column transform to strip double quotes (abbrev for inches...


SQL Server 2005 : T-SQL (SS2K5)

Ugly SQL Statement takes to long to run. I need speed up help - SELECT DISTINCT TOP 40 A.INV_ITEM_ID ,SUM(A.QTY_REQUESTED) AS QTY_REQUESTED ,ISNULL((SELECT SUM(B.QTY_ONHAND) FROM PS_BU_ITEMS_INV B WHERE B.INV_ITEM_ID = A.INV_ITEM_ID GROUP BY B.INV_ITEM_ID),0) AS ONHAND ,ISNULL((SELECT SUM(C.QTY_REQUESTED)...

Is this a "gaps and islands" problem? Finding gaps in overlapping times. - The following can be pasted into SSMS so that it is both more readable, and easier get your teeth into...

What is RBAR? How can I avoid it? - Hi, I'm new to t-sql and I do not know much regarding how to write efficient queries. I read an article...


Reporting Services : Reporting Services

How to pass Null value to Multivalue Parameters in SSRS - Hi Folks, Could you please help me out, how can I pass Null Values to Multivalue Parameters dropdown and how can...

Replacing the SSRS server, but not the DB server, how to migrate reports? - Sometime in the next few weeks or so, I'm going to be migrating an SSRS server from one machine to...

Report Services SQL 2000 Installation - Hi Guys, I have had a hectic month trying to resolve this. We have reporting services 2000 on two different servers, namely...

Converting part of a string to a date - Hello everyone, I am very new to this forum but came across many good forum posts so I decided to...

Report writer on vacation. Never used SSRS. Simple question about "where is the data request accessed" - I am staring at the report in Visual Studio and I can not figure out what button to push, or...


Reporting Services : Reporting Services 2005 Development

Proper way to deploy to SSRS 2005 - We've got SSRS 2005 installed on an old server. It's the only working version of it we have, so I...


Reporting Services : Reporting Services 2008 Development

Format DateYear - = format(Fields!period.Value,"MM-yyyy") When I use this , it changes my data from yyyymm to "MM-yyyy" ie 201308 to "MM-yyyy" Any ideas???

Report Using DAX.. - Hi, I have a dataset Query as below. EVALUATE ( TOPN(20 , CALCULATETABLE( SUMMARIZE( 'OppItem' ,'Account'[Account] ,'Account'[CountryCode] ,'External'[EXTDesc] ,'Opportunity'[Deal] ,'Opp Owner'[Opp Owner] ,'Account'[Account Owner Resource] ,'Opportunity'[Prob] ,'Opportunity'[Fiscal Book Date] ,"XYZ" ,[Sum of Sales] ,"ABC" ,[Sum of Marketing] ,"Margin" ,[Sum...

update a table after data driven subscription complete - I have to update a table after data driven subscription complete. Is it possible to add a new step to...

Average issue - Hi, When calculating the average value, its ignoring the zero values. For ex: to calculate the average of 10,20,30,0,0 it is calculating...


Programming : Connecting

error-login time out expired - hi everyone! i am a student working with SQL SERVER 2008R2.. from a month i am facing this error whenevr...


Data Warehousing : Integration Services

Help required in SSIS 2008 - Hello, I am new to SSIS. Can anyone help me provide solution for below mentioned scenario… I want to transfer data from...

SSIS Failed with unknown value returned - Good day, I'm having a problem with a ssis package, which fails 99% of the time. The error message returned: Message Executed as user:...


Data Warehousing : Analysis Services

SSAS 2012 - Calculated Member that uses measures at different grains - I'm trying to set up a calculated member - [i]budget remaining[/i] that is dependent on two native measures - [i]expenses[/i] and [i]budget[/i]...

A duplicate attribute key has been found... - im going through an exercise book with examples of SSAS cube creation and deployment. One exercise is to create a time...


SQLServerCentral.com : Anything that is NOT about SQL!

Fantasy football 2013 - I renewed the league, you should be getting an email soon. At the moment, there are no open spots, but...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


SQLServerCentral.com : SQLServerCentral.com Website Issues

Visit Counter - Hi, Not sure if this is the correct place to post, but I have a query about my visit counter. So far...


Career : Presentations and Speaking

Communicating with Non-Technical Users - Good Morning All, After a google search and looking in servercentral I cant seem to find any article or advice as...

To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com