to search by track, speaker, or session category.
Sessions Found: 82
10 Cloudy Questions to Ask Before Migrating Your SQL Server
Cloud adoption of database-related services continues to accelerate, but the choices for which...
10 DBA Tasks for Azure SQL: Whats Different from On-Prem
Adoption of Cloud is at an all time high, with no end in sight. Managing a small fleet of databases...
3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Need to report on some data from SharePoint? We will look at three different techniques to pull...
42 TSQL Functions
SQL Server has many build in T-SQL functions. This session will introduce you to a selection of 42...
A Beginner's Guide to Becoming a Performance Tuner
Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you...
A Dive into the System Databases
This session will delve into details of the system databases. These are created when the system is...
A Moment in Time: About Temporal Tables
Are you a developer or analyst who has been asked what changed for a particular record, and thus...
A Practical Starter Guide to SQL Notebooks
Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or...
Accessing SQL Server with PowerShell
If there's one tool that you haven't picked up but should, it's PowerShell. Some people think...
Advanced Virtual SQL Server Performance Tuning
Your business-critical SQL Servers should not suffer from virtualization and infrastructure...
An Introduction to Azure Data Studio
This session will provide a high level overview of Azure Data Studio and highlight some of the...
An Introduction to Data Science with Python for Data Professionals
Data Science is currently the hottest topic among data analysts and technologists, but getting...
Azure SQL Database - Where is my SQL Agent?
You migrate your on-premise SQL Database to cloud, taking advantage of PaaS offering of Azure SQL...
Azure SQL Managed Instance - Experiencies from the Field
In this pre-conference you will learn the best practices, tips and tricks on how to successfully...
Jose Manuel Jurado Diaz
Azure SQL Managed Instance - Technical Overview, Deployment, Best Practices and Monitoring
In this session you will learn the Managed instance deployment, best practices, challenges and...
Azure Synapse Analytics Overview
Azure Synapse Analytics is Azure SQL Data Warehouse evolved: a limitless analytics service, that...
Azure Vs. AWS: And the winner is!!!
You've been given an awful task of comparing two of the most prominent cloud vendors. What would...
Back to the future - Migrating our SQL Server OnPremise Database to Azure
We will cover the main aspects to migrate to one of the three architectures available in SQL Server...
Jose Manuel Jurado Diaz
Boosting Azure SQL Database Performance Using Hyperscale
Hyperperscale is a new service layer that leverages Azure architecture to scale horizontally the...
Build a Fence Around Your Azure SQL Database
The cloud is just using someone else's computer. It is even more important to keep your resources...
Building a modern data warehouse
Embarking on building a modern data warehouse in the cloud can be an overwhelming experience due to...
Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database
In this case study, I detail how I went about designing and implementing a Speaker Database for the...
Data Lake Overview
The data lake has become extremely popular, but there is still confusion on how it should be used....
Datacenter and/or Cloud - When to Use One, the Other, or Both
As with all other items in your toolbox the datacenter (local or in the cloud) needs to be used...
Disaster Documents: The role of documentation in disaster recovery
I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001. ...
Don't just code it—Generate It
Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates...
Exploring the Power BI Desktop Designer
Learn why Microsoft Power BI is taking market share in the enterprise reporting tools area. The...
Extended Events - How to collect the first 10 or every 4th event
Extended Events offers a rich filtering mechanism, called predicates. Have you ever thought of...
Extending Power BI Reporting with Python Scripting
Must developers use the Power BI desktop application to design the report using standard visuals...
First Day on the Job: Getting to Know Your Database
You're starting a new job as one of the database people, whether it is an analyst, developer, DBA,...
Sessions Found: 82
Back to Top