Creating and Using Failover Groups in Azure DBaaS – Part 1
Introduction
Hello everybody! Welcome back! One of my favorite features in Azure SQL DBaaS is Failover Groups. I have been working...
2017-12-22
175 reads
Design Concepts For Better Power BI Reports Part 4: The Squint Test
Data visualization should be iterative. You should get a good initial draft put together and then check to make sure...
2017-12-22
804 reads
A Business Lesson from an Oil Change
When I first moved to the city where I now live, I found an oil change place just a couple...
2017-12-21
390 reads
Capture Index Maintenance Operations
If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:
Where is that Mask? December 28,...
2017-12-20
16 reads
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
674 reads
Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
384 reads
Making a Difference: Andy Warren
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
358 reads
AHHH I need a Blog Topic!!!
One of the hardest things you can do as a blogger is to come up with a post topic. Do...
2017-12-20
357 reads
Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
982 reads
Interview with Guy In A Cube’s Adam Saxton and Patrick Leblanc
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...
2017-12-20
374 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