How Do You Find a DBA?
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Database Server Upgrades – The Plan, The Template, and The Task List
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
Asymmetric Keys in SQL Server
I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a nice addition to any DBA's library. It also addresses a complicated subject that Books Online has inadequately covered. In fact, they've...
Attribute Discretization: Using the Automatic Method
Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
SQL Server Optimization
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...