June 2020 Blog Posts by Steve
At the beginning of June I realized that I was slightly behind on my blogging, so today, June 30th marks 30 days of 30 blog posts in the month of June. Some other big blogging months were March 2015 and …
Search results for: replication
Weekly Summary – June 19, 2020
Here is a list of my blog posts from the last week. SQL Server Text Data – Reclaiming spaceJune 18, 2020Earlier in the week I answered a question about reclaiming space, and after that post, I decided to put it …
For merge publications, the version of the Subscriber must not exceed the version of the Publisher
Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all of them. Consider a merge replication setup with a publisher, a distributor and 2 or …
Find databases running on an older compatibility level
The SQL Server compatibility level is a SQL Server setting. This is the setting that controls some of the features of how the SQL Server database engine runs, for instance the cardinality estimator. Some people have found problems with certain …
Find databases running on an older compatibility level Read more »
Corruption Challenge Week 4 – The Winning Solution
Congratulations to Randolph West who won the corruption challenge this week with the following solution which restored all of the data. First he restored the database to get started. Note some of his code and comments have been reformatted to …
Corruption Challenge Week 4 – The Winning Solution Read more »
Database Corruption Challenge Week 4 Results
It is my pleasure to announce the winners in the Week 4 Database Corruption Challenge. But first how about a rundown of challenge. In order to make up for the difficult time that Challenge #3 was issued, Challenge #4 was …
SQL Sunday Fun – Word Search with SQL Server Keywords
The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET …
SQL Sunday Fun – Word Search with SQL Server Keywords Read more »
My Resume
You can download my resume as a PDF. SteveStedmanResume.PDF The the most up to date work information visit my Linked In Profile: http://www.linkedin.com/in/stevestedman Background For 30+ years I have been working in the software development and database areas. I first started …
Possible Topics For Virtual Classes
Virtual Class Topics Any of the following topics are available for the virtual classroom. Beginning SQL Server Introduction What is SQL Server? Installing SQL Server 2008 SQL Server Management Studio Differences between SQL Server 2005 and SQL 2008 Introduction to …