Renaming a Column–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27 (first published: 2017-12-11)
2,024 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27 (first published: 2017-12-11)
2,024 reads
See Part 1 and Part 2.
Perfect Practice Makes Perfect
I can remember my Air Force ROTC class on communications skills where...
2017-12-29 (first published: 2017-12-11)
1,438 reads
Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...
2017-12-26 (first published: 2017-12-11)
1,452 reads
This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December...
2017-12-25 (first published: 2017-12-11)
2,404 reads
In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In...
2017-12-25 (first published: 2017-12-11)
2,051 reads
This blog post is around the situation where you have SSRS setup to use HTTPS and thus using a certificate...
2017-12-21 (first published: 2017-12-11)
1,867 reads
SQL Server Management Studio comes up with multiple standard reports that show basic performance information. These reports are available without...
2017-12-11
5,002 reads
This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered...
2017-12-11
40,366 reads
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
312 reads
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most of it open source with a permissive license like...
2017-12-09
14 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Comments posted to this topic are about the item Adding Bits I
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