SSAS Trending KPI
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in...
2014-01-27
824 reads
Master Data Services for the Beginner Part 02
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,258 reads
Start/Stop Group of Azure VM's
If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here: http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/), then you can...
2014-01-30 (first published: 2014-01-27)
1,751 reads
Forcing Results To Conform For Exports
This one is a bit off for me. I've had to make SSIS exports kick out in specific ways such...
2014-01-29 (first published: 2014-01-27)
1,535 reads
Does @StrateSQL Need a Unicorn Tattoo?
As I mentioned in a post a couple weeks back, I’ll be jumping into Lake Calhoun in a few weeks...
2014-01-26
565 reads
Master Data Services for the Beginner Part 01
Introduction
About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with...
2014-01-26
5,333 reads
Master Data Services Disaster Recovery Challenges
Introduction
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative...
2014-01-25
3,621 reads
Technology Alignment
Technology Alignment with Enterprise Architecture
A critical component in your Enterprise Architecture program is assuring your organization is leveraging the best...
2014-01-24
606 reads
Blogtrottr – RSS to Email
Anyone who is a fan of RSS Feeds will likely know that the discontinuing of service by Google Reader caused...
2014-01-24
994 reads
Reblog: January 17 to January 23
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-01-24
742 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Question of the Day
Switching Schemas I
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