Conditional Formatting and Quick Calcs in Power BI Desktop
There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official...
2016-06-07 (first published: 2016-05-31)
2,760 reads
Goodness-of-Fit Testing with SQL Server Part 7.4: The Cramér–von Mises Criterion
By Steve Bolton
…………This last installment of this series of amateur tutorials features a goodness-of-fit metric that is closely related to...
2016-05-31
1,181 reads
Deletes Ignore Check Constraints
I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in...
2016-06-03 (first published: 2016-05-30)
3,559 reads
Upcoming Webinars and Events
This coming week is packed full of fun events! On Wednesday, June 1st at 2pm Eastern, I’m participating in a...
2016-05-29
899 reads
Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)
Continuation from the previous 82 parts, the whole series can be found at http://www.nikoport.com/columnstore/
A lot of things were changed in...
2016-05-29
1,007 reads
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,162 reads
Restore a SQL Server Database with Different Methods
Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a...
2016-06-02 (first published: 2016-05-28)
4,111 reads
Where are SQL Server 2016 Client Tools?
So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools...
2016-05-27
4,875 reads
My 24 Hours of PASS Session Files
I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of...
2016-05-27
995 reads
Why I'm not attending PASS Summit 2016
I know there has been a lot of drama in the community recently, much of it centered around what people...
2016-05-27
1,104 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers