Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a database from a Bacpac and export a schema and data to […]
2022-01-17
5,263 reads
Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation.
2017-06-12
8,010 reads
One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.
2017-04-14
2,268 reads
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.
2015-12-24
5,389 reads
The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.
2015-08-05
5,584 reads
One Way to Handle a Very Complex Database Project with Several Databases and Cross References
2015-05-19
10,507 reads
haha, my method is clearly described in the earlier post. Sorry.
2005-01-21
I thought it was OSQL as well - so apparently did most other people......
2005-01-09
I've found what I was looking for. The function is called ROW_NUMBER(). Here's an example of its usage:select row_number() over (order by name) as row_num , name from sys.all_objects order by name Still don't know what LineNo is supposed to be for though!!!
2004-09-02
I am using XP__SMTP_SENDMAIL to send emails to our main frame based email system. I am wondering whether it is possible to embed bold text within the @Subject and if so how I would need to construct the string in SQL Server T-SQL. Our email system can handle bold text, I can for example paste […]
2004-08-02
196 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers