Goodbye, 2013
For me, 2013 was one of the most interesting and busy years of my life. It was a good year...
2014-01-01
780 reads
Blog Posts
Happy new year!
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...
2014-01-01
645 reads
MDX #36 – Many thanks to the reviewers
In this blog, I’d like to give special thanks to the people below who have taken time to write reviews...
2014-01-01
526 reads
MDX Implementing Logical AND On Members of the Same Hierarchy
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In my prior blog post, I discussed...
2014-01-01 (first published: 2013-12-24)
1,893 reads
MVP Award for 2014
Earlier this morning I received a notification from the Microsoft MVP program that I’ve been recognized as a SQL Server...
2014-01-01
659 reads
Supporting Wikipedia & Other Organizations
I just sent Wikipedia five bucks. As someone who uses Wikipedia and finds it useful, I’m willing to donate in...
2014-01-01 (first published: 2013-12-26)
1,298 reads
While loop in SQL server
In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....
2014-01-01
22,877 reads
Wrapping Up 2013
Last year, I did a wrap up post of the year (also 2011 and 2010) to see where I landed from...
2014-01-01
760 reads
2013 - The Year of Community Speaking
So, the end of 2013 is upon us and what a year it has been. The SQL Server 365 blog...
2013-12-31
1,181 reads
2013 in review
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2013-12-31
1,167 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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