If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware’s I/O capacity meets the needs of a database application, if you need performance baselines, or if you want to identify any performance-related issues, then why not use the sqlio utility?
Do you know how often to back up your SQL Server transaction log? Steve Jones has a few thoughts today and notes that you definitely need to know how to restore the log backups.
With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.
Microsoft published a vision for their data platform and SQL Server recently. Steve Jones has a few thoughts on what this means for you. Hint: it's cloudy.
The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.
SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on Friday March 7 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
We've all been there, trying to improve performance in a panic situation and not making things better.
Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. Today, Joe Deebeeay had a problem, no one else could help, so he found these exiled experts. Together Joe and the DBA-Team get to the bottom of high disk I/O.
In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers.
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers