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
184 reads
Editorials
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
334 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
285 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
178 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
648 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
513 reads
The Wisdom Department
Steve Jones talks about the way business ought to run, with more long term goals and objectives taking precedence over short term revenue. One idea that might help us is having a wisdom department that looks forward and tries to grow the business for the long term.
2011-03-07
405 reads
SLA Contracts
This Friday Steve Jones talks about the commitments and contracts that you may have with your customers. Do you know what they are? Is the contract explicitly spelled out? Take this Friday's poll and share your answer with everyone else.
2011-03-04
585 reads
Slow Fixes
Today we have an editorial reprinted from Jan 15, 2006 as Steve is on vacation. This one talks about the patching process at Microsoft, and why it sometimes is slower than we might like.
2011-03-03
380 reads
MVP Summit 2011
Steve Jones talks a little about the 2011 MVP Summit and what the annual event means to the average DBA.
2011-03-01
179 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers