Philly Wrap SQLSaturday 200, HealthSQL and beyond..
SQLSaturday 200 is already looking further away in the rear view mirror, but it was a great event!
Joey D'Antoni, Sebastian...
2013-06-05
970 reads
How To Make Your DLL Into A NuGet Package for a Private NuGet Feed
This is my reinterpretation of the documentation on NuGet.org, modified to remove the public publishing steps, and to add local...
2013-06-05
25,189 reads
From the 2013 Techno Security Conference - Cloud Computing and Digital Forensics
I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...
2013-06-05
1,169 reads
CHOOSE in SQL Server 2012
The CHOOSE command is new in the T-SQL as of SQL Server 2012. I hadn’t ever had the chance to...
2013-06-04
1,372 reads
SQL Saturday Baton Rouge Call for Speakers closes June 6!
SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).
This year's pre-conference banquet...
2013-06-04
680 reads
My 2 cents on SQL Server 2014
Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of...
2013-06-04
2,807 reads
Windows Azure pay per minute – Time is money !
One of the most exciting news which got announced yesterday was related to Windows Azure. When Scott Guthrie mentioned that billing...
2013-06-04
701 reads
Helping Database Administrators
Let’s be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on...
2013-06-07 (first published: 2013-06-04)
1,775 reads
SQL Server 2014!
Just when you thought you got a handle on SQL Server 2012, here comes the next version! SQL Server 2014 was announced...
2013-06-07 (first published: 2013-06-04)
6,989 reads
Notes from 2013 Techno Security Conference Tuesday Keynote
There's enough from this morning's 2013 Techno Security and Forensics Investigation Conference to split into multiple blog posts. I'll focus this...
2013-06-04
1,164 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