Configuring Azure Data Sync
In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an...
2017-11-10 (first published: 2017-11-01)
1,404 reads
In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an...
2017-11-10 (first published: 2017-11-01)
1,404 reads
I’m proud to announce to you that I’m partnering with the folks over a Brent Ozar Unlimited to provide live,...
2017-11-01
507 reads
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here! If you want to learn about the...
2017-11-01
21 reads
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here!...
2017-11-01
497 reads
UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx
http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.pngNot in Seattle for some reason this week? Like maybe you stayed home...
2017-11-01
451 reads
The undead of Halloween are now upon us. Among the hordes of data zombies roaming the streets in lab-coats and fishnet stockings, few of us are still scrambling to...
2017-11-01
11 reads
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2017-11-01
463 reads
Issue : One email report is working fine from long time but suddenly it failed today with below error.
Error :
Msg 22051,...
2017-11-01
1,310 reads
[2017-Oct-31] If you have never read the "Iacocca: An Autobiography" book by Lee Iacocca, I highly recommend it. I read it...
2017-10-31
638 reads
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators. While SQL Server 2017 added so many great...
2017-10-31
73 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