Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
Changing of the Guard
This Friday's poll looks at security and password changes. What interval do you think is appropriate and why? Steve Jones asks and gives you a few thoughts on his own experiences.
Changing of the Guard
This Friday's poll looks at security and password changes. What interval do you think is appropriate and why? Steve Jones asks and gives you a few thoughts on his own experiences.
Changing of the Guard
This Friday's poll looks at security and password changes. What interval do you think is appropriate and why? Steve Jones asks and gives you a few thoughts on his own experiences.
Changing of the Guard
This Friday's poll looks at security and password changes. What interval do you think is appropriate and why? Steve Jones asks and gives you a few thoughts on his own experiences.
Enterprise Policy Management Framework with SQL Server 2008
The Enterprise Policy Management (EPM) Framework leverages and extends the new Microsoft SQL Server 2008 Policy-Based Management feature across an entire SQL Server enterprise, including down-level instances of SQL Server such as SQL Server 2000 and SQL Server 2005.
SQL Server Analysis Services ( SSAS ) - Introduction
Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. This article thoroughly explores the architecture of SSAS and how it can be implemented.
Finding a Mentor
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
7 Ways To Crash a Database
Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.
Beware the REPLACE function when doing heavy string parsing
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work with, so I had no choice.
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