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
212 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
336 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
241 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
30 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
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Marketing Analyst: The Data-Driven Superhero Your Company Needs
Want to blend your love of marketing with the power of data? Becoming a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers