Planning Your 2010 Professional Development
Virtually all successful DBAs I know put a lot of focus on education, and the best way to make it...
2009-11-24
540 reads
The most optimal join type
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries?...
2009-11-24
983 reads
Planning Out a Holiday Weekend
I've got a four day weekend thanks to the Thanksgiving holiday here in the United States. After reading Jazz in...
2009-11-24
883 reads
SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
821 reads
SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
1,596 reads
Balancing Time Today v Time Tomorrow
I’ve always thought that you should invest where you can. Make a little effort now that will pay back later,...
2009-11-24
742 reads
Opening Doors – Part 2
Yesterday in Part 1 I wrote about opening doors – the art of showing others what is possible within the context...
2009-11-23
537 reads
Some Intel Westmere Benchmarks
PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the...
2009-11-23
987 reads
Replication Scripts: Show All Transactional Publications & Subscribers At Distributor
Anybody who has talked with me about replication or heard me present about it knows that I recommend using a...
2009-11-23
638 reads
Some Ways To Look For Things in SQL Server Modules
If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it...
2009-11-23
511 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