TSQL Recipes – 2014 Edition
Announcing…the book At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished....
2015-07-21
6 reads
TSQL Recipes – 2014 Edition
Announcing…the book
At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition...
2015-07-21
544 reads
Excel BI Tip #28: Using member expressions in the CUBEVALUE Function
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-07-28 (first published: 2015-07-21)
2,500 reads
Columnstore Indexes – part 61 (“Window aggregate functions”)
Continuation from the previous 60 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A lot of financial calculations in the...
2015-07-21
547 reads
SQL Saturday 440 - Pittsburgh
SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more
about SQL Server and network with the...
2015-07-21
3,693 reads
Include File Name in Content Using Power Query
When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name...
2015-07-28 (first published: 2015-07-21)
27,366 reads
PSSDiag Configuration Manager – A Companion for SQLNexus
Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The engineer will typically send...
2015-07-21
1,553 reads
Consequences of wrong database autogrowth settings
In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re...
2015-07-30 (first published: 2015-07-21)
7,847 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are...
2015-07-21
439 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are...
2015-07-21
39 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers