Video Tutorial: Creating a SQL Server Databases
In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll...
2017-07-31
588 reads
Monday Coffee: The evolving DBA
Over the weekend I saw a few tweets about the role of the DBA. These tweets (and corresponding blog posts)...
2017-07-31
570 reads
Change RegisterAllProvidersIP setting on an existing Availability Group
Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...
2017-08-17 (first published: 2017-07-30)
21,664 reads
Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)
Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Do you remember one of the major...
2017-08-16 (first published: 2017-07-30)
1,603 reads
Dynamics 365 AX – Creating Data Entities for BYOD Azure Database including those without a natural key
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...
2017-07-29
762 reads
That thing you want to do? Do the thing.
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
693 reads
Columnstore Indexes – part 108 (“Computed Columns”)
Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/
As we are approaching the RTM (release...
2017-07-29
857 reads
How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016
One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to...
2017-07-28
715 reads
Speaking at SQL Saturday Denver (#673)
Wow, I can hardly contain my excitement. I was selected to speak at SQL Saturday Denver on September 16, 2017. I’ll...
2017-07-28
321 reads
Power BI NFL Football Stats Comparisons and Analysis Report is now available!
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-07-28
571 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