SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates
Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...
2014-11-14 (first published: 2014-11-11)
9,189 reads
PASS Summit 2014 in Review
I’m finally completely recovered from a great week in Seattle last week for PASS Summit. Now that it’s back to...
2014-11-11
1,197 reads
PASS Summit 2014 in Review
I’m finally completely recovered from a great week in Seattle last week for PASS Summit. Now that it’s back to...
2014-11-11
945 reads
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering of the community has just reached it’s 5th anniversary....
2014-11-11
9 reads
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering...
2014-11-11
586 reads
2014-11-11
510 reads
Power Testing ETL with Power BI – The Process
This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...
2014-11-11
1,297 reads
T-SQL Tuesday #60 – Something New Learned
It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...
2014-11-11
916 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
704 reads
Join me in DC for a full day of Biml
I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml...
2014-11-11
620 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