BI on SQL Azure - Yes you can
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure. Please read my blog here which was actually written...
2015-09-10
10 reads
SQL & BI
BI on SQL Azure - Yes you can
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure....
2015-09-10
474 reads
Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised when I see...
2015-08-28
214 reads
Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring...
2015-08-28
1,042 reads
Entity Sync Relationship - Master Data Services 2016
Entity Sync Relationship is a new feature in Master Data Services 2016. It enables you to share entity data between different models. You can keep a single version of...
2015-08-27
339 reads
Entity Sync Relationship - Master Data Services 2016
Entity Sync Relationship is a new feature in Master Data Services 2016. It enables you to share entity data between...
2015-08-27
1,497 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS)...
2015-08-21
245 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS).When you create a model...
2015-08-21
702 reads
Introducing Python in Hadoop World
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please...
2013-08-18
31 reads
Introducing Python in Hadoop World
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data...
2013-08-18
588 reads
Blogs
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
T-SQL Tuesday #187–Solving Problems
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
Forums
One big server with multiple instances, or multiple smaller servers...
We're currently on SQL 2019 and will likely be looking to migrate to a...
Transitioning AlwaysOn Availability Group to Synchronous Commit Mode
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
CDC & Azure Managed Instances - Performance degredation
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
Question of the Day
The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers