I dont use the Visual Studio SSDT Publish
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am doing a publish through visual studio and it doesn't...
2015-08-19
4 reads
Ed Elliott's Sql Developer Blog
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
695 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
38 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
39 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one 2008. The 2012 project referenced the 2008 project as...
2015-08-17
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-21 (first published: 2015-08-17)
1,957 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-17
33 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-17
26 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of ram and a few hundred megabytes of hard disk...
2015-08-17
3 reads
AdventureworksCI Step 5 Adding tSQLt to the solution
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-31 (first published: 2015-07-22)
1,590 reads
Blogs
Trace Flag 1448 – Lessons from a Technical Interview
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)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Locking Hierarchies
Comments posted to this topic are about the item Locking Hierarchies
Question of the Day
Locking Hierarchies
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;