Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc
*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read...
2016-05-31
1,324 reads
I hate saying no
I really do. There is a joke that DBAs say no to everything and there is some truth to that....
2016-05-31
758 reads
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,762 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,188 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,561 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
900 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,165 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,114 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,878 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers