TGI SQL Friday - 16th September 2016 Weekly roundup
I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an...
2016-09-16
454 reads
I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an...
2016-09-16
454 reads
A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...
2016-09-23 (first published: 2016-09-16)
1,239 reads
I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.
As a SQLSat...
2016-09-15
383 reads
I tend to try and get code on the screen quickly and then start to remove things. I’m a visual...
2016-09-15
623 reads
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
430 reads
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...
2016-09-15
1,320 reads
In this module you will learn how to use the Bubble chart Power BI Custom Visual. The Bubble chart allows...
2016-09-22 (first published: 2016-09-15)
1,544 reads
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
387 reads
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount...
2016-09-15
489 reads
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
501 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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