SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• TDE for multiple databases and severs

  We are self hosting sql servers, we are not using Azure for sql servers. and we would like to do en…

  sqlfriend

  7 replies

  11 months, 2 weeks ago

  By: sqlfriend

• Stored procedure - Delay validation

    I have a utility stored procedure of the form: CREATE PROCEDURE [dbo].[sp_Utility] …

  Pete Bishop

  3 replies

  11 months, 3 weeks ago

  By: Pete Bishop

• Source to Target Mapping (Lineage)

  Hi all, I work with an unusual warehouse and I was wondering if anyone else has this issue, we are …

  glenn.selby

  3 replies

  11 months, 3 weeks ago

  By: Steve Jones - SSC Editor

• how to output date of when a SP was created and last modification?

  Hi everyone I have a query that gives me the list of all SP in my DB.  I would like to modify the q…

  water490

  2 replies

  11 months, 3 weeks ago

  By: water490

• Unable to delete records from table

  Hi, Im unable to delete records from a table.Im a little surprised as have not witnessed this. The …

  narayanamoorthy.a

  25 replies

  11 months, 4 weeks ago

  By: narayanamoorthy.a

• Is anybody using Windows 2022 clustered SQL Failover cluster ( 2019 CU30 )

  How do you configure the cluster resources to be able to use Distributed Transactions ? Documentati…

  Johan Bijnens

  4 replies

  11 months, 4 weeks ago

  By: Johan Bijnens

• Unique Count of IDs per 3 month period

  I have an Appointments table with the fields MemberID and DateOfConsultation. Each member may have …

  SparkOfOrigin

  6 replies

  12 months ago

  By: SparkOfOrigin

• bulk load fails to for SAS when using the ms ODBC Driver 18 for SQL Server

  bulk load fails to for SAS when using the ms ODBC Driver 18 for SQL Server. Aparently SAS has this …

  Johan Bijnens

  3 replies

  12 months ago

  By: Johan Bijnens

• Restoring replicated data

  I am a software developer using MS SQL server as my database. I have setup transactional replicatio…

  mcdaniell2000

  2 replies

  1 years ago

  By: rothj

• Query Help to show record in single row

  Hi All, need help with an SQL query. We have an existing table that's already formatted this way, a…

  sqldba20

  2 replies

  1 years ago

  By: Steve Collins

• how do you manage new columns in a tabular table

  Hi we run 2019 ssas std.  Yesterday i imported my tabular project to vs 2022 and changed data sourc…

  stan

  5 replies

  1 years ago

  By: stan

• MSDTC not available on Windows 2022 clustered SQL 2019 CU30

  I connect to this clustered instance and run : begin distributed transaction Msg 8501, Level 16, St…

  Johan Bijnens

  1 replies

  1 years ago

  By: Johan Bijnens

• blocking folks from using a linked server and plumbing one to specific dsn

  hi, as we get further and further into netsuite connectivity, we want to block just about everyone …

  stan

  5 replies

  1 years ago

  By: Johan Bijnens

• tabular model processed but wont deploy

  hi i imported a tabular model from production into vs 2022,  changed the data source to my dev azur…

  stan

  2 replies

  1 years ago

  By: stan

• blocking folks from using a linked server and plumbing one to specific dsn

  hi, as we get further and further into netsuite connectivity, we want to block just about everyone …

  stan

  1 replies

  1 years ago

  By: frederico_fonseca