Implicit and Explicit Conversions
Code that depends on implicit conversions can live for years in production without issue. However Steve Jones says that you shouldn't depend on these conversions
2011-03-17
439 reads
Editorials
The Business
How is your IT relationship with "the business"? Andy Warren asks today if there is a real client relationship between the implementers of technology and the consumers.
2011-03-16
256 reads
A SQL Conference In The Sun
SQL Connections, part of Dev Connections, is coming in a few weeks. Now is the time to register and get the chance to learn in a sunny location.
2011-03-15
75 reads
NoSQL is Not the Answer
NoSQL solves some problems in the database world, but not all of them. It's also not an evolution of the relational database, but as Steve Jones notes, it has some features we might see in SQL Server.
2011-03-14
442 reads
Serialising tabular and relational data.
Guest editorial by Phil who bemoans the difficulty of transferring tabular data by file between differing databases, spreadsheets and analysis tools.
2011-03-14
182 reads
Max Memory
This Friday Steve Jones asks for who's got the best bragging rights. Let us know this Friday just much RAM is a lot.
2011-03-11
327 reads
DBA Concerns
A survey of Oracle DBAs shows them having a number of security concerns. Steve Jones thinks that a survey of SQL Server DBAs would be similar.
2011-03-10
281 reads
Quality Over Timing
Is quality job one for software companies? Steve Jones asks what you think and comments on why quality might not be as high as we would like.
2011-03-09
165 reads
Avoiding Logging
It seems that some people think that you can perform actions in SQL Server without logging them in the transaction log. Steve Jones talks about this myth and says it's not even an option he'd like to have.
2011-03-08
636 reads
Is Microsoft neglecting SMO?
Phil Fator, the self-confessed wild man of T-SQL, finally comes clean: he's a secret PowerShell user. But for the DBA, what is PowerShell without SMO? Is Microsoft giving the latter the care and attention it needs?
2011-03-07
505 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers