Author Archives: dbafromthecold

VMUG Ireland – Belfast

~

The second VMUG Ireland event of the year is taking place on the 15th of June in Belfast!

When: Thursday 15th of June @ 2pm until 5pm
Where: Ormeau Baths at 18 Ormeau Ave, Belfast BT2 8HS

Tickets are 100% free and are available here: –
https://my.vmug.com/s/community-event?id=a1Y4x000001x8RhEAI

We will be starting at 2pm with VMWare speaker Niels Hagoort with his session: –

What do migrations to VMware Cloud look like in real life?

Join Niels in this largely demo-led session! We’ll have a closer look into architecting for cloud migration. How do you plan and design for workload migrations into VMware Cloud on AWS? What are the considerations to take into account? This talk helps to execute successful workload migrations, showing multiple options to assist with migrating from an on-prem vSphere environment into VMware Cloud on AWS!

Then we have a session from community expert Johan van Amersfoort: –

What if Jurassic Park had a Modern Workspace?

Ever wondered how a company in the mid 90s would have operated, if they had the tech from today? You will get the answer in this session. Johan will focus on what’s possible when using the VMware Anywhere Workspace to improve employee experience across the entire workspace landscape. Be prepared for a session where you will get answers to the following questions: What should a secure digital workspace look like? How can we reduce the attack service without impacting IT too much and still create a great UX? How can we make the digital workspace fully future proof?

We’ll also have more two sessions that will be announced in the coming days!

Hope to see you there!

EightKB 2023 – Schedule and Registration

~

The schedule for EightKB 2023 Edition has been announced!

We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: –

N.B. – If you click on the session on the website, it shows the session abstract…nice touch eh?

Once again we have five top class speakers delivering five great, in-depth sessions on various SQL Server internals topics.

As any conference organiser knows, session selection is the worst part of running a conference. We only have five slots in each event which meant we ended up not picking some amazing sessions. I want to say a MASSIVE thank you to all who submitted.

We’ve also opened up registration for the event, it’s completely free and you can sign up here: – https://eightkb.online/

The event will be in Zoom and we’ll have chat going in the EightKB channel in the SQL Community Slack…please come and hang out with us there!

EightKB and Mixed Extents are 100% community driven with no sponsors so, we have our own Bonfire store selling t-shirts!

Don’t they look snazzy?!

Any money generated from the store will be put straight back into the event.

Hope to see you on May the 24th!

Video – Recovering data with crash consistent snapshots

~

A while back I posted a blog on how to recover data with crash consistent snapshots.

Snapshots are pretty handy in certain situations so I thought I’d show you them in action!

In the video below I’m being a little bit more dramatic than in the blog post 🙂

What I’m going to do is: –

  1. Take a crash consistent snapshot of the AdventureWorks database volumes
  2. Corrupt a table in the database with DBCC WRITEPAGE
  3. Overwrite another volume on the server with the snapshot taken
  4. Attach a copy of the AdventureWorks database to the SQL instance
  5. Retrieve the data in the table from the newly attached database

Here we go!

Thanks for watching!

EightKB Topics

~

Hello all, I’ve been speaking to various people about EightKB and there does seem to be a misunderstanding out there about the topics of submissions that we are looking for.

This is entirely our fault…we have marketed ourselves as “The SQL Server internals conference” and people have taken that to mean that we only want submissions on database engine internals…which is 100% not the case.

So I thought it would be handy to list out the topics that we are looking for here.

This list is not exhaustive so please, if you think something is missing please do submit anyway! 🙂

Availability Groups (all types incl. distributed)
Backups & Restores
Basically any new feature in SQL 2022
Cloud Architecture
Collations
Compression
Containers
Encryption
Engine internals
Failover Cluster Instances
In-Memory OLTP
Indexing
Kubernetes
Log Shipping
Managing very large databases
Memory internals
Mirroring
Partitioning
Performance tuning (OS and SQL Server)
Query tuning (APRC, Intelligent Query Processing, Query Store)
QuickAssist Technology
Replication
Resource Governor
S3 object access/polybase
SQL Auditing
SQL Server on Azure (SQL Database, Managed Instance, Arc Data Services)
SQL Waits
Scaling SQL Server
Snapshots
Statistics
Stretch Databases (lol)
TempDB
Virtualisation

So if you have a deep understanding of one of these topics, please do consider submitting to our next event in May. The call for speakers is open until the 22nd of April: –
https://sessionize.com/eightkb-may-2023/

We are looking for experts in areas of SQL Server, not necessarily expert speakers. If you haven’t presented before we will be more than happy to guide you through submitting, preparing, and then presenting your session.

Your session can be 45, 60, or 75 minutes long. You can do as many demos as you’d like…or none at all!

You can answer questions during the session…or questions can be collected during the session and you can respond after the event.

We have no slide template for the event…you can use whatever you’d like for your slides. I personally hate powerpoint!

Finally, after the event we will give you an unbranded recording of your session for you to use however you’d like 🙂

Thanks for reading!

Data Ceili 2023 – Schedule and Registration

~

Today we have announced the schedule for Data Céilí 2023 and have opened registration!

We have two days of great sessions for you, the 8th of June will have full day training sessions and then on the 9th of June we’ll have a full day conference of regular one hour sessions!

The schedule for the conference is: –

Information and registration for the full day training sessions is available here: –
https://www.dataceili.io/precons-2023

Registration for the conference is available (completely free) here: –
https://www.dataceili.io/registration

Hope to see you there!