Blog Archives

Sync your database with source control

SchemaDrift is a tool that I have created to compare the schema between two databases. It can also compare (and save) the schema to a directory in a file system. Point it to a directory in your source control system,

Posted in SchemaDrift Tagged with:

Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)

On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be a three part session on functions. This

Posted in 70-461 Training Tagged with: , , , , ,

Using Cursors, followed by Using String Functions

On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors,

Posted in Classes, Query Certification Tagged with: , , ,

Next Week’s Free SQL Training: MERGE Statement and Recursive Queries

Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL

Posted in Classes, Query Certification Tagged with: , , , ,

Next Free SQL Query Training – OUTPUT Clause and Derived Tables

On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session. This is a free training provided by Steve Stedman and Aaron Buma to prepare for the Microsoft 70-461 SQL Queries

Posted in Classes, Query Certification Tagged with: , , , , ,

Database Health Monitor Beta 10 Released

Today I am happy to announce that Database Health Monitor Beta 10 has been released. Click here to go to the download page. The following changes have been made since Beta 9.3. New Features Updated new, fresh icon. Adding filegroup

Posted in Database Health Tagged with: , , ,

What are your favorite SQL Conferences / Trainings?

I am starting to fill out my schedule for SQL related conferences to attend this year, and I wanted to if anyone has any favorite conferences that I may be overlooking. PASS Summit 2015 is the big, must attend conference,

Posted in SQL Server Tagged with:

Database Health Monitor – Beta 8 – Soft launch

Today I launched Database Health Reports Beta 8 as a soft launch. What I mean by the soft launch is that other than updating the DatabaseHealth website and this blog posting, I haven’t done much to promote it.  Why you

Posted in Database Health Tagged with: , , , , , , ,

SQL Server Performance for Developers

For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to

Posted in DevTeach Tagged with: , , , , ,

SQL Server FILESTREAM and FileTables

Monday: Using FILESTREAM and FILETABLES in SQL Server Configuring and Using FILESTREAM and FILETABLES in SQL Server.  Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in

Posted in DevTeach Tagged with: , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives