SQL Vulnerability Assessment
A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.
What is...
2017-12-12
166 reads
Blog Posts
The Eleven Days of Festivus 2017
Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about...
2017-12-12
330 reads
The One Piece of Career Advice I Wish I’d Gotten
Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...
2017-12-12 (first published: 2017-11-29)
2,525 reads
T-SQL Tuesday #098–2018 Goals
A great topic for T-SQL Tuesday this time from @sqlmal. It’s Setting Learning Goals for 2018, and it’s a topic...
2017-12-12
486 reads
T-SQL Tuesday #97 – We don’t need no Education! (or do we?)
TweetG’day,
Well, it’s T-SQL Tuesday time again -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This...
2017-12-12
532 reads
When Best Practices Aren’t Best
Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...
2017-12-12
396 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously...
2017-12-11
20 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices,...
2017-12-11
453 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously...
2017-12-11
20 reads
Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,266 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