Deactivate SQLTreeo license
Version SQLTreeo SSMS Add-in version 0.8.4 or higher. Purpose Deactivate a SQLTreeo license when your workstation is unavailable. SQLTreeo is...
2017-10-19
144 reads
Blog Posts
Let Her Finish: Voices from the Data Platform
This year I had the pleasure of contributing a chapter to a book along with some very special and talented...
2017-10-19
627 reads
Seattle SQL Pro Workshop 2017
Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2017-10-19
8 reads
SQL Data Generator–Getting a value based on another column
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-19
1,448 reads
SQL Server Temporal Tables
Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...
2017-10-19 (first published: 2017-10-11)
2,111 reads
SQLSaturday Orlando 2017 Notes – Part 1
Part 1 will be about things we did (or didn’t) do and some lessons learned. In Part 2 I will...
2017-10-19
437 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit...
2017-10-19
737 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit...
2017-10-19
66 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit...
2017-10-19
89 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit testing T-SQL, so much so that I thought that...
2017-10-19
10 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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