Entity Data Modeling with Visual Studio
While there are a lot of tools out there for data modeling, there is one option that is free if...
2013-12-30 (first published: 2013-12-26)
13,074 reads
Review of Change to PASS Bylaws
As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly...
2013-12-26
535 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
12 Days of Christmas 2013 Day 2
This is the second installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-26
11 reads
12 Days of Christmas 2013 Day 2
This is the second installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-26
628 reads
Powershell Backups and Post Frequency Change
It's been a good run doing a post every day. I'm scaling it back a bit. I liked getting these...
2013-12-26
764 reads
12 Days of Christmas 2013 Day 1
Last year I did a mini-series themed around the 12 Days of Christmas. I am going to do a similar series this year. Over the next 12 days, I...
2013-12-25
12 reads
12 Days of Christmas 2013 Day 1
Last year I did a mini-series themed around the 12 Days of Christmas. I am going to do a similar...
2013-12-25
593 reads
Christmas Day Winner and RDC Clients: Day 13
Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free...
2013-12-25
524 reads
Question of the Week -25/12/2013- Question1
Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it contains...
2013-12-25
481 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