MS Access – Store a Different Value than Displayed in a Combo Box
It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...
2016-10-13
485 reads
Check Database Server Workload - Batches/ Sec
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
3,164 reads
This Week In Data – Episode 8 (Mastering the Tech Interview)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-12
524 reads
Why Can’t I View My Power BI Content Pack?
I had a call with a customer this morning discussing different ways to publish Power BI content and how to...
2016-10-20 (first published: 2016-10-12)
1,126 reads
Diff All Files - Reviewing Changesets Quickly
Update: 2017-07-14
Still find this incredibly awesome! Developer just updated for Visual Studio 2017 after a lot of hard work. Github...
2016-10-12
284 reads
Stretch Databases in 60 seconds
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...
2016-10-12
15 reads
Stretch Databases in 60 seconds
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
235 reads
Webcast Tomorrow: Building an Auditing Framework for SQL Server
Faced with auditing SQL Server on a regular basis with no 3rd party tools? Where do you start? That’s what...
2016-10-12
451 reads
The Snippet Manager in SQL Prompt
I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet...
2016-10-12
727 reads
So Long, Farewell, I Hate to Say Goodbye
The Sound of Music is one of my all time favorite movies. It reminds me of some great times with...
2016-10-12
526 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
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