Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
539 reads
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
539 reads
If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...
2017-11-17 (first published: 2017-11-06)
6,275 reads
TLDR:
If you build an SSDT project you can get an error which says:
"SQL71502: Function: [XXX].[XXX] has an unresolved reference to...
2017-11-06
1,123 reads
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference to object [XXX].[XXX].”
If the code that is failing is...
2017-11-06
40 reads
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference...
2017-11-06
124 reads
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference...
2017-11-06
49 reads
Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012.
Brand new “SSISDB” database launched as SSIS...
2017-11-16 (first published: 2017-11-06)
24,161 reads
I registered for Summit about a month before getting actively involved in the dbatools project, so when I saw the team was running a pre-con and I was going...
2017-11-06
17 reads
I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different...
2017-11-05
716 reads
Defining the Problem
Imagine I have two different systems - say, a CRM and an ERP - on different SQL Servers. Both systems...
2017-11-05
505 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers