SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups
Earlier today I was required to pull the list of all SQL Login Accounts, Windows Login Accounts and Windows Group Login...
2013-08-06
1,423 reads
DMV-12 : Retaion in Session & Transaction……..sys.dm_tran_session_transactions
sys.dm_tran_session_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188739.aspx
Returns correlation information for associated transactions and sessions.
This DMV helps...
2013-08-06
1,175 reads
SSRS: Display Series on SSRS Chart Based on Parameter Value
I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30,...
2013-08-09 (first published: 2013-08-05)
3,369 reads
August 2013 – Monthly SQL Server Checklist
I can’t believe it’s already August. I had planned to get to the lake more this year, spend more time...
2013-08-05
589 reads
Last Weeks Top “Reading” Links #44
It’s Monday, it’s time for weekly round-up #44. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-08-05
1,007 reads
Best Practices to Deliver BI Solutions Presentation
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
837 reads
Speaking at PASS Summit
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC....
2013-08-05
719 reads
Database Permissions Queries
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,450 reads
there are 1000 reasons to celebrate
As many of you know, I created a facebook group named 'Living For SQL Server' couple of months back.
SQL Server...
2013-08-05
1,402 reads
Be Cautious Offering Guidance
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,340 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
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...
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