SQL PASS Summit 2013 – Simply Amazing
This past week I attended my third SQL PASS Summit in Charlotte, North Carolina. All I can say is – WOW....
2013-10-28
822 reads
Blog Posts
SQL Saturday in Verona!
This year I will speak at PASSSQL Saturday in Verona with a session based on database and source control management.
“PASS SQLSaturday’s...
2013-10-28
342 reads
IT Pro Camp Tampa 2013
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
913 reads
My PASS Summit 2013 Presentations
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...
2013-10-27
880 reads
Cumulative SUM in SQL Server
Sometimes we need to find sum of first and next row in cumulative way.
Create table and insert data:
CREATE TABLE [dbo].[testsum](
...
2013-10-25 (first published: 2013-10-19)
41,482 reads
Reblog: October 18 to October 24
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-25
965 reads
Understanding the PIVOT function
The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...
2013-10-25
3,117 reads
Architecture Reasons for Putting BLOBs in the Database
I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...
2013-10-24
5,051 reads
MDX #32 – Vincent Rainardi’s blog
I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...
2013-10-24
919 reads
Microsoft releases SQL Server 2014 CTP2
Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...
2013-10-24
1,835 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCU SUBANG Hub/Wa. 0817-819-444
Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
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