Recharging Again
I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week...
2012-12-21
918 reads
Blog Posts
Tempdb Contention That Can’t be Soothed
Tempdb Contention That Can’t be Soothed By Adding Files
Tempdb Contention via Idera diagnostic manager
I’ve talked a lot in the past...
2012-12-21
1,460 reads
The Principle of Least Privilege
One of the tenets of good security is that no person or process is granted more rights than it needs...
2012-12-21 (first published: 2012-12-17)
3,397 reads
On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll explain about that later in this post. This should...
2012-12-20
7 reads
On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll...
2012-12-20
1,562 reads
PASS SQLRally Nordic 2012 videos online
All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free. Lot’s of great BI info. Check...
2012-12-20
894 reads
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,544 reads
Active Directory Group Membership and Powershell
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...
2012-12-19
837 reads
Find Nth highest salary using RANKING functions
Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...
2012-12-19
50,529 reads
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to date. And here we are only on the seventh...
2012-12-19
9 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers