The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It is generally used before installing SQL Server in order to ensure that new hardware can handle your expected loads. Bob Sheldon explains what it is and how to use it.
More information and choice are generally good things, but there can be problems. Steve Jones notes that we can't let freedom paralyze us.
The code in this tip will show how to use two system stored procedures to identify all iterations of a given string in the available SQL Server error logs since a specific point in time.
What's the state of software in 2014. After reading Tim Bray's analysis, Steve Jones presents his.
It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Dwain Camps sets the candidates to work and identifies the winners and losers.
Spend a day with top experts from the world of business analytics and business intelligence on Feb. 5 and learn how to get the most from your data in a series of 12 free, live training webcasts with on-demand replay.
A method to create and populate Date and Time dimension tables for a data warehouse project.
Excel is used quite often to build software, or at least, it's worksheets and formulas simulate software. Steve Jones notes there are lots of problems with this practice.
Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.
When DBAs too often find themselves trading sleep for Megabytes, it's time for a different approach to detection and alerting of disk space problems. So argues Rodney Landrum.
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Not sure if this is really a relational theory question but it seems about...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers