The Hassles of Travel
As he prepares for a trip across the Atlantic, Steve Jones talks about some things he doesn't like about travel.
Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005
In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?
Obtaining Index Usage Information
This article shows how the sys.dm_db_index_usage_stats DMV can be used to tune your indexes, and maximize the performance of your database
Checkpoints in SSIS
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
No More Lottery
Steve Jones talks about the lack of a big payday for tech workers. Not that most of us were expecting one.
Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.
Identifying Windows Volumes on a Clustered SQL Server Instance with the DMVs
I am trying to determine which of the logical volumes on the shared disk are associated with each SQL Server instance. Is there a simple method in T-SQL to determine this without having to fire up Cluster Administrator?
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers