Tomorrow June 20th at 1pm PST we launch our very first Live Stream Discussion! Submit a question for our discussion >> Link to our Live Stream << We can’t wait to connect with you in real-time and bring you valuable content, entertainment, and more through these sessions. Stay tuned for updates on our upcoming broadcasts and get ready to join …

Tune in Tomorrow! Read more »

Join Us for This Live Event – Tuesday 20th – 1pm pacific / 4pm eastern  These engaging broadcasts will bring valuable content each week! This weekly event offers excellent opportunities to enhance your SQL skills and expand your knowledge in the field.  Join us every Tuesday at 1pm PST as the Stedman Solutions Team will answer question submissions regarding your …

Live SQL Discussion with Stedman Solutions Kickoff  Read more »

Introducing – Live SQL Discussion with Stedman Solutions  We are thrilled to share the exciting news that our team will now be hosting weekly live streams! This means you can look forward to regular, engaging broadcasts and get your SQL Server questions answered from us on a consistent basis. We can’t wait to connect with you in real-time and bring …

Introducing a Fantastic New Event!  Read more »

SQL Server is a powerful and complex database management system that is used by millions of organizations worldwide to store, manage, and analyze their critical data. While SQL Server is a robust platform, it is not immune to issues that can cause problems in its operation. Therefore, it is essential to take preventative measures to keep a SQL Server healthy. …

Steps to help keep your SQL Server running smoothly. Read more »

The sys.databases table in SQL Server contains information about all databases in the current SQL Server instance. The state_desc column in this table represents the current state of the database, which can have the following possible values: Note that not all states may be applicable to every database, and the state of a database can change depending on its current …

What are all the values of the state_desc column in the sys.databases system table in SQL Server? Read more »

Microsoft SQL Server is a relational database management system (RDBMS) available in several editions to cater to different needs and requirements. Two of the commonly used editions are SQL Server Express and SQL Server Standard Edition. Here are some key differences between them: Cost: Database size limit: Scalability: Features: Use cases: High Availability and Disaster Recovery: In summary, SQL Server …

SQL Server Standard Edition vs. SQL Server Express Edition Read more »

In the last day or two Microsoft has released several updates with security patches. If you have SQL Server running anywhere, please make sure it’s patched. SQL Server 2022 GDR SQL Server 2019  CU19 SQL Server 2017  CU31 then GDR SQL Server 2016  SP3 then GDR then GDR SQL Server 2014 SP3 then CU4 then GDR then GDR

Synonyms in SQL Server are a useful feature that allow developers to create an alias or alternate name for an object in the database. This can be especially helpful when working with complex or large databases, as it allows developers to use more descriptive or intuitive names for objects instead of the default names assigned by the system. There are …

Using Synonyms on SQL Server Read more »

To find the most used data files on SQL Server, you can use the sys.dm_io_virtual_file_stats dynamic management view. This view contains statistics about the I/O activity of all the data files in the database. To use this view, you can run the following query: This query returns the following columns: The query orders the results by the num_of_bytes_written column in …

Query to find the most used data files on SQL Server Read more »