Blog

How to implement SQL Azure Activity Monitor using T-SQL

SQL Azure Database Activity Monitor (Using T-SQL) This script reveals how how to implement a SQL Azure Activity Monitor utilising T-SQL. As with everything in life, this is a good news, bad news story. The bad news is SSMS does not have Activity Monitor for SQL Azure Database and sometimes with my SQL Azure Developer hat on, I am only allowed access to the SQL Azure Database and not the

Read More

SSRS Course SSRS Training Course

SSRS Course for Beginners or Developers Learning Outcomes On this SSRS Course, learn how to use SSRS, SQL Server Reporting Services, the Report Designer, Report Manager, Report Layout, Formatting, Data Access, Server Administration, Mobile Reports. Essentially you learn about SSRS Report Development and Delivery. SQL Server Versions All versions of SQL Server are covered as well as if you’d prefer the course delivered in Report Designer or Report Builder. Course

Read More

TSQL Course | Transact SQL Training

TSQL Course | Transact-SQL Training Our TSQL Course can cover Beginners or Intermediate/Advanced training, depending on your needs. So, with this Transact SQL Training, you will learn real-world skills gleaned by experienced SQL Developers. Learn how to write effective SQL statements from the ground up in this TSQL Course. Understand the set paradigm, right from the start. No experience is necessary to go to a good level with clear explanations

Read More

SQL DBA Course – SQL DBA Training Course

Our SQL DBA Course can cover Beginners or Intermediate/Advanced training, depending on your needs. So, with this SQL DBA Training, you will learn real-world skills gleaned by experienced DBAs. It’s not about the bells and whistles because it’s about getting the basics right, again and again. We have been DBAs for many years and we share our experience with you on this SQL course. Sequallity cover SQL Server and typical

Read More

SQL Server Training Course Feedback

Recently, Sequallity delivered the SQL Server 2017 DBA Training Course to a great group. There were difficult questions and some great conversations. Here are a sample of the quotes… “Very approachable and well prepared.” “The trainer was very helpful and happy to cover topics which we found helpful. He was very knowledgeable.” “Presentation Style” “Extensive examples and walkthroughs” At the start of a course, I take a deep breath and

Read More

How to pass 70-764 – Administering a SQL Database Infrastructure in 2 Weeks!

I really enjoyed studying and taking the 70-764 exam but everything is always muddied water, isnt it? Maybe it’s just me. Ok, so it was time to renew the Microsoft Data Platform Competency – Silver, for Sequallity Limited and a funny thing happened on the way.  I had decided to go down the Database Dev route and this consisted of 3 exams, initially.  So, I had passed the first exam

Read More

Sequallity Client Feedback

We like working with our clients and sometimes we get really good feedback and the truth is, it goes nowhere, so here it is in all its anonymised glory, as only good GDPR practitioners would say… N.B. Your proposed changes for the [Redacted] process were put live and we’ve seen a marked improvement in the process since. Thanks for the help on this. The client is referring to Stored Procedure

Read More

SQL Server 2019 Installation Walkthrough (CTP 3.2 August 2019)

Hello. Another version of SQL Server is bestowed upon us at the end of 2019. Recently I installed this so here are screenshots of this SQL Server 2019 installation walkthrough. It’s nice to see the changes as the product evolves.  I wonder how much longer though a physical product will be produced. Or will the robots get us first…If only I was a betting man. SQL Server 2019 Installation Walkthrough

Read More

How to solve HTML Agility Pack Error: the request was aborted, the operation has timed-out error

Recently, I encountered a HTML Agility Pack error. I like to write some code using Visual Studio and C#. I downloaded the HTML Agility Pack recently and I must say, I’m well impressed. I was using C# and Visual Studio 2019 Community edtion and downloading some html and kept getting the above error. You know what fixed it… System.Threading.Thread.Sleep(1000); I put this just after the Load and the Get. I

Read More

How to pass 70-761 Querying Data with Transact-SQL in 3 weeks!

Rather foolishly, I set myself a challenge to study and pass the 70-761 exam in 3 weeks.  (Initially, I set myself two weeks but it was too stressful, so I had to extend it). I really enjoyed the exam (when it was over, and I’d passed).  When I clicked to the End, I really didn’t know what score I’d got. Also, I clicked on review, so I had to wait

Read More