Upcoming PASS Free Training
Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.
January, 2017
Tuesday,January,31
Introduction to Oracle SQL and PL...
2017-01-27
674 reads
SCOPE_IDENTITY() or @@IDENTITY
I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...
2017-02-01 (first published: 2017-01-27)
3,247 reads
Friday Reading 2017-01-26
Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been...
2017-01-27
409 reads
Microsoft SQL Server 2016 Cumulative update 1 (CU1)
Microsoft just announced Microsoft SQL Server 2016 Cumulative update 1 (CU1)
Microsoft reference: [Click Here]
Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin
2017-01-27
322 reads
What’s a Database Encryption Key (DEK) in TDE
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-02-03 (first published: 2017-01-26)
1,747 reads
Backup/Restore–What’s My Status?
The day begins and you find yourself going through a list in your mind of things that need to be...
2017-02-02 (first published: 2017-01-26)
1,914 reads
SQL Server Community Events
By David Postlethwaite
I have just come back from a successful SQL Saturday in Vienna, Austria where I had 60 people...
2017-01-26
594 reads
Querying My Named Instance in PoSh–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-25
671 reads
Setting Up a Productive Work Environment – #TAPtips
Having a productive work environment for you and your team is important to facilitate tasks being accomplished as well as...
2017-02-03 (first published: 2017-01-25)
1,847 reads
DATEDIFF vs. DATEADD
Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates...
2017-01-25
13,919 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...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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