Custom Navigation controls in SharePoint 2010
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
956 reads
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
956 reads
Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you...
2013-07-29
738 reads
One Client I was working with wanted a named set that would give them the last 5 years. Of course...
2013-07-22
1,016 reads
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...
2013-07-19 (first published: 2013-07-15)
2,141 reads
Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop...
2013-07-10 (first published: 2013-07-08)
2,694 reads
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...
2013-07-05 (first published: 2013-07-01)
1,705 reads
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
769 reads
Sometimes we get data in some bad forms. For example look at the below table:
The names and the amounts are...
2013-06-18 (first published: 2013-06-17)
2,087 reads
Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually...
2013-06-12 (first published: 2013-06-10)
3,705 reads
If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an...
2013-06-03
1,048 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers