Reblog: June 7 to June 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-14
879 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works. There were over 500 attendees! The abstract...
2013-06-14
1,288 reads
Few thoughts and updates
Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval.
There is a reason behind...
2013-06-14
1,198 reads
Colorado SQL Events : June 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-06-14
890 reads
Improving performance by using SET STATISTICS IO
When I started using SQL Server the company I was working for at the time had no skill in this...
2013-06-14
2,867 reads
The Side Effect of NOLOCK (video)
A while back I put together a blog post on the side effect of NOLOCK. Today I thought I’d push...
2013-06-13
548 reads
Security Questions: Migrate Logins Between Servers
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-13
589 reads
Levels in IT consultancy
The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...
2013-06-13
1,085 reads
Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
602 reads
Printing the Report Parameters on SSRS
I'm surprised there isn't an option in the Report Manager for allowing you to include on the print out of...
2013-06-17 (first published: 2013-06-13)
6,225 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