2019-01-16
163 reads
Editorial
Measuring Effectiveness
Being effective is important to Steve. Today he talks about the things you might consider when trying to determine if your group is being effective.
2019-01-15
69 reads
Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
145 reads
Do you have a security to-do list?
Security is important, and Steve wonders if any of us have a list of things we do that improve security.
2019-01-11
106 reads
2019-01-10
129 reads
Is Failure Allowed?
Failure is one of the ways we get better as software developers. Does that apply to DBAs?
2019-01-09
77 reads
2019-01-07
174 reads
The Giving Back Workload
Volunteering is a good thing for us to do, but it can be overwhelming at times.
2019-01-04
90 reads
Lack of Memory
It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.
2019-01-03
147 reads
2019-01-02
180 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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