Detect Worst Performing SQL Queries – Part 2
This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL...
2012-01-31
1,517 reads
Tabular Model
One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model...
2012-01-31
3,509 reads
Orlando IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.
2012-01-31
1,788 reads
SQL Server 2012 Express RC
The new version of the lovely SQL Server edition, Express Edition!
Take a look the new link for the download and...
2012-01-31
3,247 reads
When DBCC INPUTBUFFER disappoints
Today we have an alert from one of the client server about blocking, I have immediately start looking at it...
2012-01-30
1,739 reads
Breaking Down TempDB Contention (part 2)
Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...
2012-01-30
3,039 reads
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,604 reads
The affordable self-service BI revolution has started.
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been...
2012-01-30
1,896 reads
Complex reporting off a SSAS cube
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,361 reads
The Idera ACE Program, So Far
The Idera ACE program is something I’ve been involved with for over a year now. I’ll share a bit of...
2012-01-30
1,675 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