AdventureworksCI Step 4 Pushing to GitHub
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server...
2015-07-22
9 reads
Setting specific colors for PowerView charts
I was listening for Phil Collins' "True Colors" song in my car audio this morning and it reminded me about...
2015-07-21
5,395 reads
Argenis Without Borders – v2
Last year at the PASS Summit, Kristen Benzel and Argenis Fernandez put on a fundraiser to raise money for Doctors...
2015-07-21
704 reads
SQL Server – New Database Backup Encryption with SQL Server 2014
With the release of Microsoft SQL Server 2014, we have the first version of SQL Server that supports encrypting database...
2015-07-21
691 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 of the SQL Server Recipes book is finished....
2015-07-21
10 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
545 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,522 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
550 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,706 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,522 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers