T-SQL Tuesday #114 – Puzzle Party
A few years back I started running regular SQL workshops in my workplace. Teaching beginners the basics of querying databases with SQL, as well as more advanced topics for...
2019-05-07
145 reads
Power BI Interview Questions – Volume 01 – Overview
Welcome to a brand new series that I have started with with Erin Ostrowsky [Blog | Twitter] that will focus on interviewing for a Power
2019-05-06
80 reads
Midlands PASS – Next Meeting and Summit Discount Code
Midlands PASS is an official PASS chapter located in Columbia, SC, USA. Here’s an update about our schedule, as well as the PASS discount code. No May or June...
2019-05-06
80 reads
Launching ADS from SSMS
If you haven’t heard, SSMS v18 went GA (Generally Availability) recently. You can download it from Microsoft, though if you have a preview version, you do need to uninstall...
2019-05-17 (first published: 2019-05-06)
586 reads
Query Store, Plan Forcing and Table Variables
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
2019-05-06
175 reads
SQL Server Large Memory Pages
SQL Server Enterprise Edition can leverage large memory pages to reduce the amount of memory pointers required for larger SQL Server deployments. Reducing the number of pointers makes the...
2019-05-20 (first published: 2019-05-06)
521 reads
db_owner in msdb == sysadmin
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner ... Continue reading
2019-05-22 (first published: 2019-05-06)
560 reads
Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-06
30 reads
Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-06
64 reads
Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-21 (first published: 2019-05-06)
1,013 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Alamat BCA KCP City Center Hub/Wa. 0817-819-444
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers