to search by track, speaker, or session category.
Sessions Found: 64
“Go Faster!” And Other Things Yelled at the Backup Jobs
This session is an introduction to tuning backups. Learn how to take those backup jobs to disk and...
13 reasons why my query is slow
What if we could analyze a single query with thirteen different performance problems? In this...
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...
Accelerating Development and Testing Using Data Virtualization
Constraining everything in development and testing is database size. Storage is a bottleneck, and...
All About SQL Injection
SQL injection has consistently ranked as one of the top security threats in software development....
An (Advanced) Introduction to Dax
Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be...
Azure Automation: Your SQL Agent in the Cloud
You want to migrate your on premise SQL Database to cloud, and soon recognize that SQL Agent is not...
Back to the Basics: T-SQL 101
Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for...
Basic Database Programming
Abstract: You just found out that a client needs a SQL database to be designed from scratch. ...
Big Data and Hadoop: A primer for the weary DBA
Big Data has become a corporate and household buzzword. But is it just that? You really need to...
Big data architectures and the data lake
With so many new technologies it can get confusing on the best approach to building a big data...
Choosing technologies for a big data solution in the cloud
Has your company been building data warehouses for years using SQL Server? And are you now tasked...
Collecting Performance Metrics
Have you ever had a manager standing over your shoulder, wanting to know why a server is running...
DBAs vs. Developers: JSON in SQL Server
The war between DBAs and developers has been raging since the dawn of relational databases. One...
Destination Azure... building ETL workloads in the cloud!
More and more of our data is originating from or being moved to the cloud, but many of us are doing...
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. ...
Drinking From the Firehose: a Guide to Keeping Up with Technology
Keeping up with technology can feel like a treadmill; you keep running but never get anywhere....
Dynamic SQL: Writing Efficient Queries on the Fly
Dynamic SQL can be a powerful tool that allows you to write fast & efficient queries when the...
Effective Data Warehouse Storage Patterns
Abstract: Many companies start off with a simple data mart for reporting. As the company grows,...
Efficiently Searching Schema in SQL Server
Within a database and the server that hosts it are a wide variety of objects that are of importance...
Essential Linux for the SQL Server DBA
Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for...
Everyone Has a Story to Tell: Developing Your First Presentation
Ever considered giving a presentation of your own? Pondered how your favorite speakers got their...
Execution Plans 101
Do you have a query that you want to tune, but don't know where to start? Execution plans can be a...
Fine tuning your maintenance plans
It is becoming increasingly difficult to have longer maintenance windows despite all our wishes and...
From (User) Story to Tables: Read Between the Lines to Find Your Data
If you work in an agile environment, design requirements often come to us as stories with the...
Getting to and Nailing Your Interviews
Are you stuck in your existing job for years? Do you feel you need to get out, try either a new...
High-Performance SSRS: Techniques For Faster Reports
SQL Server Reporting Services (SSRS) is an easy-to-use tool for automating reports and creating...
How to audit and prevent unwanted user actions.
Abstract: Many corporations are composed of small divisions located in countries throughout the...
How to build your career
In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, a SQL...
How to detect, analyze and minimize SQL Server Blocking and Locking
The goals of this session are to learn the good, the bad, and the ugly of blocking; to discover...
Sessions Found: 64
Back to Top