Creating and Using Failover Groups in Azure DBaaS – Part 2
Connecting to Failover Group
So in Part 1 of this series, we created and configured our Failover Group. Well, now that...
2017-12-26
149 reads
SQL and NOT SQL: Best of 2017
Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...
2017-12-26
431 reads
SQL and NOT SQL: Best of 2017
With only a few days left in 2017, I thought it would be fun to do a year in review post. Below you'll find some of my top 5...
2017-12-26
11 reads
Extended Events Permissions
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...
2017-12-26
145 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
161 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,427 reads
What is the Automatic Plan Correction in SQL Server 2017?
SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about...
2017-12-25
652 reads
My Interview at Data Platform Geeks 2017
Dear All, Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As always a terrific experience to hangout, interact and...
2017-12-23
21 reads
My Interview at Data Platform Geeks 2017
Dear All, Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As always a terrific experience to hangout, interact and...
2017-12-23
18 reads
Adaptive Query Processing - Adaptive Joins - Plan resue - 3
Continuing on the series on Adaptive Query Processing covered over here, this post would cover what happens to adaptive joins when plans are reused.
To give a...
2017-12-23
27 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