In observance of the US federal holiday Memorial day, and in memory of all who have died in service, Stedman Solutions, LLC will be closed for the last Monday in May. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell …
I’m Steve Stedman, a firm believer in the value and power of effective data management. Having interacted with SQL Server extensively, I’ve recognized that data aggregation is a vital tool for anyone seeking to extract the most valuable insights from their data. To share this knowledge and help others master this powerful technique, I’ve launched a new course on Teachable …
SQL School: Elevate Your SQL Skills: Harness the Power of Data Aggregation Read more »
There are several common causes of database corruption in SQL Server, including: * Hardware failures: Hard drives, memory chips, or other hardware components can fail, causing data to be lost or damaged. * System crashes: Power failures, blue screens, or other system crashes can cause corruption in a SQL Server database. * Software bugs: Software bugs can cause corruption in …
DBCC CHECKIDENT is a command in SQL Server that is used to check the current identity value of a table, and also to reset the identity value if necessary. This command is particularly useful when working with tables that have an identity column, which is a column that is automatically populated with a unique numerical value for each row inserted …
As a business owner, you know how critical data is to the success of your business. From customer information to financial records, your data is the lifeblood of your organization. That’s why protecting that data should be a top priority. One of the most important steps you can take to protect your data is to run regular backups on your …
Protecting Your Business: Why Running Backups on SQL Server is Essential Read more »
As an IT professional working on SQL projects, you may occasionally find yourself in need of expert guidance to ensure success. My SQL Server Mentoring services at Stedman Solutions are designed to provide the support and expertise you need to overcome challenges and achieve your goals. With a team of experienced mentors, we’re committed to helping you navigate the complexities …
Propel Your SQL Projects Forward with Expert Mentoring Services by Steve Stedman Read more »
Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Derrick : How do we find corruption? Oh, man, I wish it was as easy as taking out the magnifying glass there. Steve : Yeah, if we had this magic magnifying glass that would let us look at the data bytes like that, that’d be cool. But …
SQL Server Corruption: More about Detecting Corruption Read more »
As a database administrator, I know how important it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, a powerful and user-friendly solution that helps you manage your database environment and improve its overall performance. The Database Health Monitor is …
Database Health: Insight Into Database Performance Read more »
DBCC OPENTRAN is a DBCC command in Microsoft SQL Server that can be used to display information about the oldest active transaction in the database. This can be useful for troubleshooting issues with long-running transactions, as it can help identify the cause of the problem and allow you to take appropriate action to resolve it. To use DBCC OPENTRAN, you …
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS LCK_M_X LCK_M_U CXCONSUMER CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP OLEDB ASYNC_NETWORK_IO XE_LIVE_TARGET_TVF LCK_M_SCH_S Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »