SQL .NET Requirements
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-07-12
168 reads
Finding Inconsistent Key Values–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-07-20 (first published: 2018-07-11)
1,851 reads
Performance as a feature, software developer edition
Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient...
2018-07-11
333 reads
What the Microsoft MVP Award Means to Me in 2018
I recently received my seventh “Most Valuable Professional” award from Microsoft. Oddly, I don’t think I’ve ever written about what this award means to me until this point. In...
2018-07-11
32 reads
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans...
2018-07-10
24 reads
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,195 reads
T-SQL Tuesday 104 – Capture expensive queries with query store
For this month’s T-SQL Tuesday Bert Wagner invites us to share SQL scripts we’ve written that we’d hate to live...
2018-07-10
303 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
21 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
28 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
37 reads
Blogs
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...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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