Keep It Simple
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
2009-03-10
70 reads
Articles
Reasons Why You May Not Want to Use a Heap
For a book project I am working on, I have started compiling a list of reasons why heaps aren't usually a good choice when designing a database. Now, I didn't say that heaps are always bad, but in most cases, I think they should be avoided so pleae read the list to see why.
2009-03-10
3,333 reads
What comes first, the application or the database?
Many of the concepts behind Domain Driven Design are noble and valid but the silo-based approach to development that inevitably springs from this philosophy gives Tony Davis cause for concern.
2009-03-09
404 reads
The Challenges of Being Safe
Securing your data is a challenge. Steve Jones has a few comments no just how hard it can be to obfuscate your production data as you move it to development environments.
2009-03-09
875 reads
The Challenges of Being Safe
Securing your data is a challenge. Steve Jones has a few comments no just how hard it can be to obfuscate your production data as you move it to development environments.
2009-03-09
644 reads
The Challenges of Being Safe
Securing your data is a challenge. Steve Jones has a few comments no just how hard it can be to obfuscate your production data as you move it to development environments.
2009-03-09
641 reads
T-SQL Debugger is back in SQL Server 2008
Debugging capability in SSMS was a long sought feature by users and finally the Microsoft SQL Server team decided to provide this feature in SQL Server 2008.
2009-03-09
4,514 reads
Using schema binding to improve SQL Server UDF performance
SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.
2009-03-09
4,200 reads
What Does Support Look Like?
With a new version of SQL Server being released every 2-3 years now, what does that mean for support from Microsoft? What about from DBAs?
2009-03-07
526 reads
What Does Support Look Like?
With a new version of SQL Server being released every 2-3 years now, what does that mean for support from Microsoft? What about from DBAs?
2009-03-07
62 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers