Ralph Kimball Books
If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:
The Data Warehouse Lifecycle Toolkit: Practical...
2013-05-30
2,563 reads
A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,390 reads
I am Speaking at 2013 PASS Member Summit!
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,286 reads
Saving Grace
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...
2013-05-30
1,262 reads
Backup a password, change it, then restore it.
A couple of months ago I talked about moving a login from one server to another without the password. The...
2013-06-05 (first published: 2013-05-30)
2,359 reads
SQL Saturday Charleston!
Finally.... SQL Saturday has come back to... South Carolina! (with apologies to The Rock)
After the last SQL Saturday in Columbia,...
2013-05-30
1,917 reads
SQL Server security webinar series is coming soon!
I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...
2013-06-04 (first published: 2013-05-30)
2,547 reads
Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction
Recently I had to give a Power View demo for a client. Giving a demonstration means of course you have...
2013-05-30
2,959 reads
SSIS 2012 Deployment Fail Part Two: SSIS Server Maintenance Job
Recently I post about a timeout issue I was getting when deploying SSIS projects. It was mainly to do with too much log and previous versions being kept in...
2013-05-30
26 reads
Hangouts Session with Boris Hristov
I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter).
Boris wants to start using the...
2013-05-29
1,281 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