What we're about

The Sydney SQL Server User Group is a group for Database IT Professionals who are interested in the Microsoft SQL Server technology stack and related technologies.

The group meets monthly and covers topics from the following tracks.

• DBA: Database Administration

The DBA track covers topics that are primarily of interest to the Database Administrator such as SQL Server architecture and internals, disaster recovery, high-availability, hardware, performance optimization, troubleshooting and administration.

• DBD: Database Development

The DBD track is for the Database Developer and covers areas such as database design and optimization, indexing, concurrency, Transact-SQL, coding patterns / practices and query optimization.

• ARC: Architecture

The ARC track is designed to address the needs of Solution / Enterprise Architects. This track is more concerned with solution design, architecture patterns and best practises, scalability, SQL Server technologies, and aligning your business with Microsoft's strategy / vision.

We aim to deliver sessions that are of a higher calibre than paid-for events such as Microsoft TechEd/Ignite. The sessions are technically deep, applicable to your work and full of "lessons from the field". You should walk away from a session with a better understanding of the technology and how it can be applied in your organization.

With that in mind please "spread the word". If you need help getting "managerial approval" to spend 2 hours monthly improving your skillset and ability to deliver better outcomes at work please contact me.

I hope to see at the user group soon!

Victor Isakov

(MCA, MCM, MCSM, MCT, MVP)

Upcoming events (2)

Redux: Good Database Design Patterns and Techniques

Online event

Due to the current COVID-19 pandemic it is unknown when the Sydney SQL Server User Group will be returning to the Microsoft Reactor. So what I would like to is to run a series of more informal, "impromptu", "unplugged" technical sessions to ensure that you keep your SQL Server skills current. (Hint: This knowledge will certainly help you in any job interview!) So the aim is still to run highly detailed, technically deep online-only sessions, but perhaps on subject matter that has been covered before, but updated to the latest version of SQL Server. In the fifth of my "Redux" series we will cover the topic of designing good databases (for SQL Server). Whether you are running on-premise or in the cloud, good database design will ensure optimal performance. Poor database design in the cloud will ensure that you are paying more than you should be in the cloud. In this session we will cover good database design techniques, including table design, database schemas, keys, partitioning, indexing strategies. We will leverage 20 years of experience with examples of what has been done well, poorly and shockingly in the industry to ensure that you do not fall into the same traps and make the same mistakes. Warning: This is perhaps a session that is more important than you realize if you are moving into the cloud at the moment... But you'll have to attend to find out why :)

Redux: SQL Server High Availability

Online event

Due to the current COVID-19 pandemic it is unknown when the Sydney SQL Server User Group will be returning to the Microsoft Reactor. So what I would like to is to run a series of more informal, "impromptu", "unplugged" technical sessions to ensure that you keep your SQL Server skills current. (Hint: This knowledge will certainly help you in any job interview!) So the aim is still to run highly detailed, technically deep online-only sessions, but perhaps on subject matter that has been covered before, but updated to the latest version of SQL Server. In the second of my "Redux" series we will cover the critical topic of high-availability. Since the release of "Wolfpack" in NT 4.0 and clustering SQL Server high availability has come a long way. However the core technologies of failover clustering and availability groups are still misunderstood. Organizations are subsequently lifting and shifting their SQL Server infrastructure into the cloud sub-optimally. In this session we will ensure that your knowledge of SQL Server's high availability is current. We cover topics such as failover clustering, database mirroring and availability groups. We will will ensure you understand the technology correctly, where it shine and it's limitations. Whether you are a Solution Architect, a Data Engineer, Database Administrator, a Developer or a Manager we will ensure that you understand the importance of high availability and the high-availability technology options available in SQL Server.

Past events (65)

Redux: SQL Server Options in Azure

Online event

Photos (21)