Forum Replies Created

Viewing 15 posts - 1 through 15 (of 26 total)

  • Reply To: Exploring the DATE Functions in SQL

    Thank you, @tellery_frmt for your comment.

    If you use months to calculate the DOB, then your age will inflate at the start of your birth month, which is not correct. See...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    February 27, 2020 at 3:23 pm

    #3729297

  • Reply To: Exploring the DATE Functions in SQL

    Thank you, @beervolk. Could you please also explain briefly why do you prefer to use sysdatetime over getdate?

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    February 27, 2020 at 3:11 pm

    #3729290

  • Reply To: Month-over-Month calculation using DAX in Power BI

    Thank you for your comment, @Ray-Giacalone, and @pietlinden.

    If you have a MonthNumber field in your dataset, you should sort all your month-wise charts by that field. That way your month...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    February 19, 2020 at 5:40 am

    #3726979

  • Reply To: Creating Test Data

    Thank you for this @steve-jones-ssc-editor.

    This is one of the important factors that need to be addressed when developers start building any new data application. In my organization, we often use...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    January 13, 2020 at 5:19 pm

    #3715002

  • Reply To: Setting up Management Studio for remote SQL Server

    That's strange.

    Ideally, if it is the default instance, I'd suggest you connect to it using the hostname only (from both SSMS and SQLCMD).

    Hope this answers your question.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    January 6, 2020 at 4:41 pm

    #3712734

  • Reply To: Setting up Management Studio for remote SQL Server

    Can you please run the following query and share a screenprint?

    SELECT SERVERPROPERTY('InstanceName')

    If it returns NULL, then it is the Default Instance otherwise it will return the instance name.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    January 6, 2020 at 4:10 pm

    #3712706

  • Reply To: Setting up Management Studio for remote SQL Server

    @abacrotto

    Fig 1: Default Instance

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    January 6, 2020 at 3:28 pm

    #3712679

  • Reply To: Setting up Management Studio for remote SQL Server

    Hello @abacrotto,

    If I understand correctly what you're trying to say, you have SQL Server running on a notebook (PC #1) and you're trying to connect to it from another PC...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    January 6, 2020 at 2:48 pm

    #3712660

  • Reply To: Setting up Management Studio for remote SQL Server

    Hello,

    I think you have to use the following format to connect to the named SQL instance inside your VM.

    HOSTNAME\INSTANCENAME. (Hostname = VM PC Name)

    I hope this helps.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    January 6, 2020 at 12:35 pm

    #3712612

  • Reply To: How to filter non-existing records in SQL

    Thank you for sharing the link, @chris-wooding.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    November 5, 2019 at 2:34 pm

    #3695148

  • Reply To: How to filter non-existing records in SQL

    Thanks @bob-56901. I'll add that to my to-do list. Will keep you posted of my upcoming posts on this topic.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    November 4, 2019 at 5:01 pm

    #3694440

  • Reply To: Oops, I deleted that data

    That's interesting, @mvdba. Being a developer, I keep myself restricted from fire fighting with the production environment. It is a nightmare for me to update values in production directly, without...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 30, 2019 at 7:00 pm

    #3693245

  • Reply To: Transaction Isolation Levels

    @Bryant-McClellan, NOLOCK seems to be a bit scary to me, especially when reporting financial data. There's a huge possibility that the reports might be generated with incorrect data, leading to...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 3:57 pm

    #3692444

  • Reply To: Transaction Isolation Levels

    Haha! Well said @patrickmcginnis59-10839. Reminded me of one of my old bosses.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 3:22 pm

    #3692420

  • Reply To: Transaction Isolation Levels

    Thank you @pailwriter. It's my pleasure to be helpful to the community.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 3:02 pm

    #3692406

Viewing 15 posts - 1 through 15 (of 26 total)