TSQL Tuesday - Databases and DevOps
DevOps isn't running SQL Server in a container and pushing code to it from Jenkins
When we talk about DevOps we envision that we have the ability to check-in code,...
2017-06-13
16 reads
T-SQL Tuesday #91–Early DevOps
This month the T-SQL Tuesday invitation is from Grant Fritchey, my colleague at Redgate Software. Surprise, surprise, the topic is...
2017-06-13
452 reads
T-SQL Tuesday #91 – Start Talking
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-06-13
104 reads
T-SQL Tuesday #91 – Start Talking
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-06-19 (first published: 2017-06-13)
992 reads
DevOps and Visual Studio
The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps...
2017-06-13
1,147 reads
Buzzword Bingo
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
984 reads
How/Why/What is DevOps?
Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps...
2017-06-13
566 reads
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it...
2017-06-20 (first published: 2017-06-13)
10,598 reads
Power BI Custom Visuals Class (Module 55 – Enlighten World Flag Slicer)
In this module you will learn how to use the Enlighten World Flag Slicer Custom Visual. The Enlighten World Flag...
2017-06-20 (first published: 2017-06-13)
2,043 reads
SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!
Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...
2017-06-13
1,697 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