Latest 100 Posts
- SQL Server Backup and Recovery Readiness Assessment
Assessing SQL Server Backup and Recovery Readiness: A Must-Do for IT Managers and DBAs In today’s digital-first environment, ensuring the resilience and reliability of your SQL Server databases is not just recommended; it’s …SQL Server Backup and Recovery Readiness Assessment Read More »
- April Promo Join Types Poster
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in … - Exclusive Invitation: Master SQL Join Types with a Free Webcast
Are you ready to deepen your understanding of SQL Join Types? Join us for an exclusive, live webcast that promises to elevate your SQL skills. This is your chance to be one of …Exclusive Invitation: Master SQL Join Types with a Free Webcast Read More »
- Launching Today: Comprehensive SQL Server Replication Course – Enroll Now!
We are thrilled to announce the launch of our latest course at Stedman’s SQL School, entirely focused on SQL Server Replication! Available starting today, this course offers an in-depth exploration of all things …Launching Today: Comprehensive SQL Server Replication Course – Enroll Now! Read More »
- My Join Types Course
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in … - SQL Server Wait Type: PREEMPTIVE_OLEDBOPS
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the … - Common Waits Reported by Daily Monitoring This Month
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. …Common Waits Reported by Daily Monitoring This Month Read More »
- Join Types Shirt
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in … - Push vs Pull Replication Video
Here is a short video that I created explaining the difference between Push and Pull replication. Watch it on YouTube. https://youtu.be/ykHsAHH-ggs?si=Msr4jRgeygOs3_Gq Replication Course Enrollment Information Want to learn more about replication? If you’re … - Join Types on your wall
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in … - Database Health: Wait Statistics and Blocking Queries
In addition to its customizable dashboard, intelligent alerting system, and powerful reporting capabilities, the Database Health Monitor also provides valuable insights into wait statistics and blocking queries. Wait statistics are a crucial component …Database Health: Wait Statistics and Blocking Queries Read More »
- Exclusive SQL Server Replication Training Session
Join Steve Stedman for an exclusive online presentation on SQL Server replication techniques on April 24th at 10:30 AM Pacific Time. This special session will delve into the fundamentals of Transactional Replication, Merge …Exclusive SQL Server Replication Training Session Read More »
- Don’t Miss Out With Join Types MonthWelcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in …
- SQL School: Master the TSQL Output Clause with My SQL Server Course
Hey there, fellow SQL enthusiasts! I’m Steve Stedman, and I’m excited to share my SQL Server course on the TSQL Output Clause. If you’re like me and passionate about mastering SQL Server, then …SQL School: Master the TSQL Output Clause with My SQL Server Course Read More »
- Fighting back against Ransomware
In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have … - Stories of Corruption
Grab a blanket and get comfortable. It’s story time with Steve Stedman and Derrick Bovenkamp! In this 10 min video they will share with you database corruption stories. From these stories hopefully you’ll … - Demystifying SQL Server Join Types: A Guide to Mastery
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in …Demystifying SQL Server Join Types: A Guide to Mastery Read More »
- Understanding Merge Replication in SQL Server
Understanding Merge Replication in SQL Server In the world of data management, ensuring that information is up-to-date and accessible across different locations is crucial for businesses to function efficiently. This is where the … - SQL Server Corruption: Will It Get Better
At Stedman Solutions we have done many corruption repairs since 2015. When I talk about corruption, most of this information comes from real world scenarios that actually happened at different businesses that we … - New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU26 for 2019 (15.0.4365.2 – April 2024) CU25 + GDR (15.0.4360.2 – April 2024) 2024-04-11 Here are the latest updates for … - Join our next livestream – SQL Server Self Assessment
We are excited to invite you to our next exclusive livestream event presented by Stedman Solutions and hosted by our very own Steve Stedman! This event is a fantastic opportunity for anyone interested …Join our next livestream – SQL Server Self Assessment Read More »
- Join Types Shower Curtain
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in … - Our Free Joins PosterWelcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in …
- New SQL Update from MicrosoftToday Microsoft released a new update for SQL Server. SQL Server 2019 CU25 for 2019 (15.0.4355.3 – February 2024) CU25 + GDR (15.0.4360.2 – April 2024) 2024-04-09 Here are the latest updates for …
- Immutable Backups
Securing SQL Server Against Ransomware: The Role of Immutable Backups Securing SQL Server Against Ransomware: The Role of Immutable Backups In the digital age, data is arguably an organization’s most valuable asset. For … - Securing SQL Server: Windows Local Groups as SQL Logins
In SQL Server, you can create logins using Windows local groups as a way to manage access to the database server. This means that you can add users to a Windows local group …Securing SQL Server: Windows Local Groups as SQL Logins Read More »
- Daily Server Monitoring – SQL Versions for AprilOut of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private …
Daily Server Monitoring – SQL Versions for April Read More »
- SQL Server DBCC Commands: DBCC IND
SQL Server’s DBCC IND command is an undocumented database console command that is used to display the allocation and deallocation status of the data pages in a table or index. This command is … - April is Join Types MonthWelcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in …
- More that Just SocksWelcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in …
- SQL Server Wait Type: LATCH_SH
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the … - Celebrating World Backup Day with Stedman’s SQL School
Celebrating World Backup Day with Stedman’s SQL School: Unlock the Secrets of Efficient Backup and Recovery As we mark World Backup Day on March 31st, it’s a timely reminder of the critical importance …Celebrating World Backup Day with Stedman’s SQL School Read More »
- DBCC CHECKDB Options Explained
In SQL Server, the DBCC CHECKDB command is a critical tool for ensuring the integrity of your databases. It performs checks on the logical and physical integrity of all the objects in the … - Embrace Efficiency and Growth: The Integrated Power of Managed Services
Embrace Efficiency and Growth: The Integrated Power of Managed Services In today’s fast-evolving business landscape, organizations are constantly seeking ways to optimize their operations, scale efficiently, and ensure the robust management of their …Embrace Efficiency and Growth: The Integrated Power of Managed Services Read More »
- SQL School: Master SQL Server Performance Tuning
Performance tuning in SQL Server is essential for efficient database management. The Performance Tuning Course offered by Stedman’s SQL School is specifically designed to equip database professionals with the knowledge and tools necessary …SQL School: Master SQL Server Performance Tuning Read More »
- Elevating SQL Server Performance with Managed Services
Elevating SQL Server Performance with Managed Services from Stedman Solutions In the realm of database management, SQL Server stands out for its robustness, scalability, and wide range of features catering to various business …Elevating SQL Server Performance with Managed Services Read More »
- Database Health: Insight Into Database PerformanceAs 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 …
Database Health: Insight Into Database Performance Read More »
- Sleep Better With Managed Services From Stedman Solutions, LLC.
Finding Peace of Mind with SQL Server Managed Services As the owner or manager of a business that relies on SQL Server for critical data management and operations, the thought of your SQL …Sleep Better With Managed Services From Stedman Solutions, LLC. Read More »
- SQL Server Corruption: Can I Prevent CorruptionIf you are reading this article becuase you are trying to repair your corruptin database, please reach out ot us at Stedman Solutions we can take a quick look and help determine your …
- Securing SQL Server: Force Encryption SettingSQL Server instance level settings allow you to control various aspects of the behavior of your SQL Server instance. One such setting is the ability to force encryption for all connections to the …
- Common Waits Reported by Daily Monitoring This MonthEach 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. …
Common Waits Reported by Daily Monitoring This Month Read More »
- Stedman Solutions SQL Server Managed ServicesEnsuring Peace of Mind for Your Database Management In the world of data-driven decision-making, the reliability, performance, and security of your SQL Server databases are paramount. For many organizations, however, managing and optimizing …
- The Challenges of Relying Solely on an In-House DBA
The Challenges of Relying Solely on an In-House DBA: Insights from Stedman Solutions In the fast-paced world of IT, the database is the backbone of any organization, storing critical data that drives decision-making …The Challenges of Relying Solely on an In-House DBA Read More »
- SQL Server DBCC Commands: DBCC SHRINKDATABASEDBCC SHRINKDATABASE is a DBCC command in Microsoft SQL Server that can be used to reduce the size of a database by moving pages of data from the end of the file to …
- SQL Server Wait Type: PREEMPTIVE_OS_GETFILEATTRIBUTESWait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the …
SQL Server Wait Type: PREEMPTIVE_OS_GETFILEATTRIBUTES Read More »
- Configuring Database Mail in SQL Server: Video
Configuring Database Mail in SQL Server: A Dual Approach In the realm of SQL Server management, setting up Database Mail is a critical task for database administrators. It enables the sending of email … - Cut Costs Without Compromising Quality
Cut Costs Without Compromising Quality: Outsource Server Maintenance with Managed Services and Watch Your Savings Grow Welcome back, fellow data enthusiasts! Today, we’re diving into a topic that’s not only crucial for your … - New SQL Update from MicrosoftToday Microsoft released a new update for SQL Server. SQL Server 2022 CU12 for 2022 (16.0.4115.5 – March 2024) CU10 + GDR (16.0.4100.1 – January 2024) 2024-03-14 Here are the latest updates for …
- SQL School: Master SQL Server Joins with My Comprehensive CourseHi there, I’m Steve Stedman, and I’m excited to share with you my SQL Server course focused on SQL Server Joins, available at http://SteveStedman.com/joins. As an experienced database professional, I’ve designed this course …
SQL School: Master SQL Server Joins with My Comprehensive Course Read More »
- Stedman SQL School: Database Corruption Course
Hello, I’m Steve Stedman, and I want to talk about my SQL Server course on preparing for corruption. This course is designed to help SQL Server professionals be better prepared for the event … - Enhancing Business Continuity with Stedman Solutions
Enhancing Business Continuity with Stedman Solutions SQL Server Managed Services In today’s digital landscape, the resilience of your SQL Server databases against unexpected events is crucial for maintaining business continuity. The ability to …Enhancing Business Continuity with Stedman Solutions Read More »
- Dangers of Removing Indexes
In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having … - Database Health: Monitoring Backups with Database Health MonitorMonitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server …
Database Health: Monitoring Backups with Database Health Monitor Read More »
- Not Using All CoresUnderstanding SQL Server CPU Utilization When working with SQL Server, you might encounter situations where it seems not to utilize all available cores or is capped at a maximum of 50% CPU load. …
- Scale Your Business
Scale Your Business worry-free! Join Managed Services at Stedman Solutions and Reclaim Your Time. In the dynamic landscape of today’s economy, scaling a business is a commendable yet formidable task. As enterprises strive … - Join Our Upcoming Livestream EventsWe are excited to invite you to two exclusive livestream events presented by Stedman Solutions and hosted by our very own Steve Stedman! These events are a fantastic opportunity for anyone interested in …
- Daily Server Monitoring – SQL Versions for MarchOut of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private …
Daily Server Monitoring – SQL Versions for March Read More »
- Enhancing Business Continuity with Cloud-Based SQL Server Log Shipping
Enhancing Business Continuity with Cloud-Based SQL Server Log Shipping In today’s digital-first world, safeguarding your data against unforeseen events is crucial for maintaining business continuity. With the reliance on digital platforms at an …Enhancing Business Continuity with Cloud-Based SQL Server Log Shipping Read More »
- How Critical Is Your SQL Server Performance?
How Critical Is Your SQL Server Performance? Understanding the Impact of Slowdowns In the realm of SQL Server management, performance isn’t just a technical metric; it’s a cornerstone of business efficiency and success. … - SQL Server Performance Assessment with Stedman Solutions
Mastering SQL Server Performance: An Insightful Journey with Stedman Solutions Welcome to the Stedman Solutions blog! I’m Steve Stedman, and today I’m thrilled to share with you the essentials of our Comprehensive Database …SQL Server Performance Assessment with Stedman Solutions Read More »
- TSQL Output Clause Course
Have you seen our SQL short course on the TSQL Output Clause? The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and … - SQL Server Corruption: What Causes CorruptionMicrosoft SQL Server’s database corruption can lead to severe operational complications, making crucial data inaccessible and potentially jeopardizing business continuity. Comprehending this problem requires a firm grasp of corruption indicators, its root causes, …
- Monitoring for Corruption
Guarding Against the Unseen: Vigilance in Monitoring SQL Server Database Corruption In the realm of data management, database corruption within SQL Server stands as a silent yet formidable adversary, capable of inflicting considerable … - March is Peace of Mind Month
Stedman Solutions introduces, Peace of Mind Month, granting you satisfaction and reassurance for your SQL Server through Managed Services. The month of March is “Peace of Mind Month” for us at Stedman Solutions. … - SQL Server Managed Services: A Cost-Effective, Hassle-Free Solution
SQL Server Managed Services: A Cost-Effective, Hassle-Free Solution to Your Database Needs In the ever-evolving landscape of database administration and maintenance, businesses face the crucial decision of ensuring their SQL Server environments are …SQL Server Managed Services: A Cost-Effective, Hassle-Free Solution Read More »
- SQL Server Wait Type: BACKUPIO
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the … - Securing SQL Server: Disable CLRCLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR on SQL Server allows you to create stored …
- Understanding RTO and RPO
Optimizing Your Backup Strategy: Understanding RTO and RPO In the intricate landscape of data management and disaster recovery, the concepts of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) are pivotal in … - How Vital Is Your SQL Server Data? A Guide to Preparedness
How Vital Is Your SQL Server Data? A Guide to Preparedness In an era dominated by data, the significance of your SQL Server data to your business’s success is paramount. Despite its importance, …How Vital Is Your SQL Server Data? A Guide to Preparedness Read More »
- Strategically Managing SQL Server Growth
Strategically Managing SQL Server Growth: Balancing Expansion and Costs As businesses flourish and evolve, the underlying data infrastructure must adapt accordingly. SQL Server, serving as a cornerstone for numerous organizations’ IT ecosystems, is … - A Guide to Business Continuity Planning
Fortifying Your Business Against the Unexpected: A Guide to Business Continuity Planning In an era where business operations are increasingly digital and data-driven, the importance of a robust business continuity plan cannot be … - Stay Ahead: The Imperative of Keeping SQL Server UpdatedStay Ahead: The Imperative of Keeping SQL Server Updated In the rapidly evolving world of technology, maintaining the currency of your software is not merely a matter of accessing the newest bells and …
Stay Ahead: The Imperative of Keeping SQL Server Updated Read More »
- Common Waits Reported by Daily Monitoring This MonthEach 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. …
Common Waits Reported by Daily Monitoring This Month Read More »
- Stedman Solutions Can Turbocharge Your Database Performance
Is Your SQL Server Performing Slowly? Discover How Stedman Solutions Can Turbocharge Your Database Performance In the realm of database management, SQL Server stands as a cornerstone for countless organizations, powering critical applications …Stedman Solutions Can Turbocharge Your Database Performance Read More »
- SQL Server DBCC Commands: DBCC CLONEDATABASEDBCC CLONEDATABASE is a DBCC command in Microsoft SQL Server that can be used to create a copy of a database on the same server. It is primarily used for testing and debugging …
- Database Health: Monitoring Backups with Database Health MonitorMonitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server …
Database Health: Monitoring Backups with Database Health Monitor Read More »
- SQL School: Master SQL Server Joins with My Comprehensive CourseHi there, I’m Steve Stedman, and I’m excited to share with you my SQL Server course focused on SQL Server Joins, available at http://SteveStedman.com/joins. As an experienced database professional, I’ve designed this course …
SQL School: Master SQL Server Joins with My Comprehensive Course Read More »
- New SQL Update from MicrosoftToday Microsoft released a new update for SQL Server. SQL Server 2019 CU25 for 2019 (15.0.4355.3 – February 2024) CU22 + GDR (15.0.4326.1 – October 2023) 2024-02-15 Here are the latest updates for …
- Exclusive SQL Performance Tuning Training
Steve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your … - Three Fantastic Ways to Master SQL Server Join TypesThree Fantastic Ways to Master SQL Server Join Types Hey there, SQL enthusiasts and database professionals! It’s Steve Stedman from Stedman Solutions, LLC. Today, I’m excited to share with you three incredible ways …
Three Fantastic Ways to Master SQL Server Join Types Read More »
- Why is my SQL Server slow?
Understanding the Causes of SQL Server Performance Issues As a seasoned SQL Server expert and the owner of Stedman Solutions, LLC, I’ve encountered a myriad of reasons why a SQL Server database might … - Database Health Monitor v1055 Released Today
Today we have a new release of Database Health Monitor. This release has perhaps the biggest performance improvement that I have had on the product in the last 5 years. I completely changed … - SQL Server Corruption: Stories About Causes of CorruptionThe integrity of a Microsoft SQL Server database can be severely undermined by corruption, leading to data inaccessibility and potential operational disasters. Steve Stedman’s comprehensive approach to identifying and rectifying such corruption is …
SQL Server Corruption: Stories About Causes of Corruption Read More »
- SQL Server Wait Type: PREEMPTIVE_OS_WAITFORSINGLEOBJECWait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the …
SQL Server Wait Type: PREEMPTIVE_OS_WAITFORSINGLEOBJEC Read More »
- Learn SQL In The ShowerSome people say I am obsessed with Join Types, they may be right, you can decide. Todays featured join product is the Joins Shower Curtain. Joins Shower Curtain Start you day out right …
- 5 Things to Check When Your SQL Server is Performing Slowly
Need help with this, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. First 5 Things to Check When Your SQL Server is Performing …5 Things to Check When Your SQL Server is Performing Slowly Read More »
- Unlock the Power of SQL Joins with Your Free Downloadable Poster!
Steve Stedman here from Stedman Solutions, LLC. If you’ve ever grappled with the complexities of SQL join types, I’ve got something exciting for you. We’re offering a FREE downloadable poster that breaks down …Unlock the Power of SQL Joins with Your Free Downloadable Poster! Read More »
- Daily Server Monitoring – SQL Versions for FebruaryOut of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private …
Daily Server Monitoring – SQL Versions for February Read More »
- Securing SQL Server: Basic Security MeasuresThere are several ways that you can secure SQL Server, including: Enabling authentication and authorization: This helps ensure that only authorized users can access the SQL Server instance and the data it stores. …
- SQL Server DBCC Commands: DBCC WRITEPAGEDBCC WRITEPAGE is an undocumented and unsuported DBCC command in Microsoft SQL Server that can be used to write a page of data from a database to a specified file on disk. It …
- User Tables in the Master Database and Disaster Recovery
This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Risks: User Tables in the Master Database and Disaster Recovery …User Tables in the Master Database and Disaster Recovery Read More »
- Database Health: Monitoring Backups with Database Health MonitorMonitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server …
Database Health: Monitoring Backups with Database Health Monitor Read More »
- Database Health Monitor Feb 2024 ReleaseToday I released the February 2024 update of Database Health Montior with some new features and improvements. Here is what was included in this release: February 2024 – Version 1052 Release NotesNew Features• …
- Database Health Monitor – Free DowloadHello there! My name is Steve Stedman, and I want to tell you about my amazing product, the Database Health Monitor. As a professional database administrator, I understand how vital it is to …
- February: The Month of Performance at Stedman Solutions!
February: The Month of Performance at Stedman Solutions! February is here, and at Stedman Solutions, LLC, we’re declaring it Performance Month! As a seasoned expert in SQL Server since 1990, I’m excited to …February: The Month of Performance at Stedman Solutions! Read More »
- Staff Augmentation – We can help
As the founder and owner of Stedman Solutions, LLC, I know how important it is to address the challenges you face when it comes to your DBA or developer’s absence or the overwhelming … - Iterating Over SQL Server Certificates with Cursors
Iterating Over SQL Server Certificates with Cursors Welcome to another SQL Server educational post! Today, we’re going to explore how to use cursors to iterate over all certificates in the sys.certificates system view. …Iterating Over SQL Server Certificates with Cursors Read More »
- Understanding Slow SQL Server Error Log AccessThis is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Mitigating Slow SQL Server Error Log Access Are you experiencing …
- Our Managed Services Team is Your Lifeline for SQL Server ManagementManaging SQL Servers is a critical but often complex task. That’s why our Managed Services offer you the assurance and expertise of our team acting as your part-time or fractional DBA, for a …
Our Managed Services Team is Your Lifeline for SQL Server Management Read More »
- Top 10 SQL Server Wait Types for Performance TuningTop 10 SQL Server Wait Types for Performance Tuning Understanding these wait types is key to identifying performance bottlenecks in SQL Server: CXPACKET: Indicates parallelism-related waits. High values suggest inefficiencies in query parallelization. …
Top 10 SQL Server Wait Types for Performance Tuning Read More »
Getting Help from Steve and the Team
Contact us for your Free 30 minute consultation ORschedule your appointment now.
Leave a Reply