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,239 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
406 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
321 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,744 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,900 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
591 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
667 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,845 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,871 reads
Career Corner: Go Beyond Networking
Networking with others is good for your career. You should do it. Don’t stop there. Keep going.
Networking builds contacts and...
2017-01-25
504 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers