Speaking at SQL Saturday Oregon
I am so excited and honored that I have been selected to speak at SQL Saturday Oregon on November 3,...
2018-10-16
223 reads
I am so excited and honored that I have been selected to speak at SQL Saturday Oregon on November 3,...
2018-10-16
223 reads
“This was in Dallas, we had our MVP Summit in Dallas and there were only maybe like less than 10...
2018-10-15
77 reads
Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups are encrypted, securing your data in case your media...
2018-10-15
35 reads
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-10-15
493 reads
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take...
2018-10-15
391 reads
In [Contravariant]The image is self-explanatory.
Out [Covarient]The image is self-explanatory.
2018-10-15
81 reads
In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose...
2018-10-15
278 reads
Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices....
2018-10-24 (first published: 2018-10-15)
1,824 reads
In or around Detroit? Come see my Getting Started with Machine Learning session at the Detroit PASS User Group, Thursday, November 8th at 6 PM. Power Point [8MB] Demo...
2018-10-15
42 reads
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick...
2018-10-15
245 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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