2020-06-23
902 reads
SQL Server 2019
Use Polybase to consume Oracle data from SQL Server on Linux 2019
Learn how to set up Polybase in containers to access an Oracle database.
2020-01-09
5,279 reads
Memory-Optimized TempDB Metadata in SQL Server 2019
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
2019-12-19
What’s New in SQL Server 2019
In this video Brent takes a 40-minute look at some of his favorite new features: deferred compilation for table variables, adaptive memory grants, adaptive joins, and air_quote_actual plans
2019-11-08
2019-10-04
717 reads
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
2019-10-03
Introduction to Running SQL Server 2019 on Kubernetes
The release of SQL Server 2019 further extends the ability to host SQL Server instances on Linux, including running Docker-based SQL Server images on Kubernetes clusters. This latest release further extends the multi-platform capabilities by allowing for Kubernetes-based deployments of SQL Server Always On Availability Groups, delivering increased level of resiliency. Read on to learn more about the basic characteristics of these deployments!
2019-07-30
Java & SQL Server 2019 Extensibility Framework: The Sequel
The SQL Server 2019 CTP 2.5 release introduces a new Java implementation; your Java code now needs to inherit an abstract base class from the Java Language Extension SDK.
2019-05-31
High Prices for High Security
I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I've thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step forward, but it had too many restrictions. Kind of like Availability Groups in 2012 and […]
2019-05-30
518 reads
2019-05-25
413 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