How to create DACPAC file?
In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps...
2018-10-31
2,574 reads
In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps...
2018-10-31
2,574 reads
Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California....
2018-10-22
97 reads
DevOps Terms – and Why They Matter to Database Specialists Find out what is Scrum, Continuous Deployment, TDD and others from...
2018-10-21
63 reads
“This was in Dallas, we had our MVP Summit in Dallas and there were only maybe like less than 10...
2018-10-15
57 reads
Hi guys! Not too much this week as I was very busy on #DataRelay tour across UK whole week (relation...
2018-10-14
53 reads
In this blog post I want to quick go through one of useful capabilities that Microsoft provided with version 2...
2018-10-05
199 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;