SQL Server: Showing permissions for a given database user
Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...
2007-11-06
609 reads
Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...
2007-11-06
609 reads
This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...
2007-11-05
912 reads
I try my best to get things right the first time. So often, correcting a mistake or bad choice is...
2007-11-05
675 reads
I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...
2007-11-02
861 reads
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
2007-11-01 (first published: 2002-08-01)
38,991 reads
As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...
2007-11-01
2,173 reads
Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...
2007-10-31
2,601 reads
SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...
2007-10-30
2,569 reads
A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...
2007-10-29
1,675 reads
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,466 reads
I’ve been doing storage load tests for SQL Server for a long time, both...
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers