Configure MOSS without GUI || Database name without additional GUID || PSCONFIG command to configure MOSS
Friends, do every time we need the GUI ? or we feel the need of Customized things some times in life....
2013-02-21
1,153 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 8: Sequence Clustering
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,046 reads
MDX #26 – SSN can only be referenced as a member property in MDX
I’ve blogged about the Properties() function before.
MDX #11 – How to get number of cars each customer owned using Properties() function?
MDX...
2013-02-28 (first published: 2013-02-21)
1,975 reads
Windows 2012 for the DBA Setting Your Server to High Performance
Hello Dear Reader! I’ve been doing a lot of work with Windows Server 2012 lately. The interface is wildly different...
2013-02-27 (first published: 2013-02-20)
3,549 reads
A Month of PowerShell – Day 20 (Databases: Table-Valued Functions)
Welcome to Day 20 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26 (first published: 2013-02-20)
2,763 reads
SQL Agent and the case of the missing job owner…
One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some...
2013-02-20
739 reads
SQL Saturday #177 – Silicon Valley
There is something about the Silicon Valley that attracts the innovative and creative individuals. The “misfits, rebels, troublemakers, and the...
2013-02-20
934 reads
T-SQL Tuesday #39 – Wrapup
Last week, I hosted the T-SQL Tuesday blogging party event, and the topic was on how do you use PowerShell...
2013-02-19
988 reads
Cumulative Update – 5 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 5th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-02-19
1,923 reads
Cumulative Update – 6 for SQL Server 2012 Is Now Available !
The 6thcumulative update release for SQL Server 2012 is now available. Cumulative Update 6 contains all the hotfixes released since...
2013-02-19
845 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