01: Hardware and Database Tuning for SQL Server..
02: Bare Metal Tuning Part1..
03: Bare Metal Tuning Part2..
04: High End Testing..
05: SQL Configuration Options and Trace Flag Secrets..
Myths and Reality of Iterative Testing..
SSWUGtv: Cloud Technology Partners: Ben Grubin, Director of Product Management from Cloud Technology Partners..
SSWUGtv: How do you decide where to host (cloud)? Check out some great tips on today's episode...
SSWUGtv: What's in a job title? How do you set proper job titles? Laura Rose has the answers...
SSWUGtv: What does the iCloud have to do with SQL Server? Find out on today's episode...
SSWUGtv: Wes Kranz, Senior Director, Database Products, from Embarcadero Technologies discusses a major new ..
SSWUGtv: How do you approach the first few days after a vacation? Laura Rose has some great tips...
SSSWUGtv: Laura gives tips on how to work through issues with a problem business partner...
SSWUGtv: SQL Server upgrades – planning the moves, making the choice, considerations..
SSWUGtv: Is mono-tasking or multitasking better? Laura answers the question...
SSWUGtv: SQL Server performance – breaking up is hard to do – working across server, in-memory and more..
SSWUGtv: Laura gives some tips on appropriately showing your appreciation to a client..
SSWUGtv: SQL Server Security thoughts – encryption application points and techniques...
Introduction to Power Query..
SSWUGtv: Laura gives tips on how to overcome your first mistake at a new job...
SSWUGtv: SQL Server Backup and restore – to the cloud! (Or not?)..
00: Introduction to Data Ware House..
02: Introduction to SSIS..
03: Introduction to Control Flow..
04: Introduction to Connection Managers..
05: Introduction to Data Flow..
06: Advanced Control Flow..
07: Advanced Data Flow..
08: Script Tasks and Components..
09: Troubleshooting and Debugging..
10: Data Quality Services and Master Data Services..
11: Deployment Models..
SSWUGtv: Laura answers: What is a good CRM for remote employees that tracks what they are doing every minute?..
SSWUGtv: Steve talks about SQL Server Permissions and walling off the castle...
Resilient Career Choices for IT Professionals..
Setting up SQL Server on Windows Azure..
SSWUGtv: How can women navigate office politics while staying professional, staying focused on their career ..
SSWUGtv: Today, Steve discusses SQL Server present-day considerations – flash loads and crowds...
SSWUGtv Security Edition: Steve and Patrick discuss using UDF and Triggers for automatic encryption in SQL Se..
SSWUGtv: How do you handle friending requests from your boss? How about your employees?..
SSWUGtv Security Edition: Today, Steve and Patrick discuss the advantages of upgrading from DES to AES..
SSWUGtv Security Edition: Patrick Townsend explains whether you should encrypt at the application level or da..
SSWUGtv: Today Laura Rose gives tips on how to get a great reference...
SSWUGtv: Today, Steve discusses choosing your IT services best weapons (Office, Google Apps, etc)...
SSWUGtv: Today, Steve gives great advice on choosing your best weapons: hosting selection (cloud, on-premise,..
SSWUGtv: How introverts can break into a manager role even though they aren't the most aggressive/outspoken?..
01: Key basics..
02: Core statements..
03: Using Like, Aggregation..
04: Stored procedures, Views..
SSWUGtv Security Edition: Encrypting data for higher education institutions with Steve and Patrick Townsend...
SSWUGtv: Today, Steve discusses making checklists for your systems...
SSWUGtv Security Edition: Key management vs. key storage with Steve and Patrick Townsend...
SSWUGtv: High Scalability Blog- Data doesn't need to be free!..
SSWUGtv Security: Your cloud provider isn't encrypting your data! ...and other misconceptions...
SSWUGtv: If you use cheap resources, does that make you a lazy DBA?..
SSWUGtv: Our newest speaker, David Dye, talks with Steve about his experiences with SSIS and his new workshop..
Career Boosting Resolutions..
SSWUGtv: Today, Steve addresses self-service BI data-use issues...
SSWUGtv: How do you make sure you plug up data protection holes? Steve is giving away some great tips today...
00: SSIS Advanced Techniques Workshop-Preview..
SQL Server – Auditing SQL using SQL Audit..
SQL – Dealing with geographic data..
Introduction to Power Map..
01: SSIS – Creating dynamic packages..
02: SSIS – Error handling and troubleshooting..
03: SSIS – Deployment models..
04: SSIS – Replacing dynamic SQL with variables and expressions in SSIS..
05: SSIS – Leveraging the Execute SQL task in SSIS..
Intro to Power Pivot..
SSWUGtv: How Can Remote Employees Connect with Co-Workers?..
SSWUGtv: Are DBAs becoming irrelevant? Steve's got an interesting opinion on today's show...
SSWUGtv Security Edition: Steve and Patrick help you to pick out questions you should ask your cloud/saas ven..
SSWUGtv: What perks should you hold out for as you're negotiating a position with a company?..
SSWUGtv Security Edition: The cloud, certifications, and you...
SSWUGtv: How do you manage two jobs? Laura Rose has some great tips!..
Backup, Restore and Options with SQL Server..
SSWUGtv: Today, Laura answers the question of how to boost morale among peers...
SSWUGtv: Laura Rose answers the question, what is the best way to handle personal crisis at work?..
Creating a Memory-Optimized Table..
Rows and Indexes..
Transaction Processing and Concurrency Control..
Checkpoint and Recovery..
Special Edition with Kalen and Steve..
SSWUGtv: How do you make sure that you are productive, even if you only have five minutes? Laura Rose has som..
Lesson 1 - Overview and the Hybrid Cloud..
Lesson 2 - Engine Enhancements, Part 1..
Lesson 3 - Engine Enhancements Part 2..
Lesson 4 - Updatable Columnstore..
Lesson 5 - In memory OLTP..
SSWUGtv Security Edition: Today, Steve and Patrick discuss what the cloud means for data security...
SSWUGtv: At what point are you being too greedy in salary negotiation?..
SSWUGtv Security Edition: In a cloud environment, why would someone choose a VPC over a traditional cloud env..
SSWUGtv: How do you spot potentially bad bosses before accepting a job? Laura Rose has some great tips for yo..
SSWUGtv Security Edition: Encrypting data with Microsoft's .NET encryption libraries...
SSWUGtv: When to Tell Your Boss "No" - and how to do it in a way that won't offend them!..
SSWUGtv: If you have multiple job offers, how do you know that you're making the right decision? Laura Rose h..
Hands-on Transact-SQL Fundamentals..
5 Things I wish I knew about TSQL..
SQL Performance Guidelines..
SSWUGtv: Are your meetings a waste of time? How do you fix that and make them worth the time you spend? Laura..
SSWUGtv: Steve and Admound Chou, Product Development Manager - Data Quality Solutions, talk about clean data...
SSWUGtv: How do you take over a new department with a weak team? Laura Rose has some great tips today...
SSWUGtv: Laura Rose is on the show today, giving tips on how to get the most out of your team...
SSWUGtv Security Edition: Today, learn about using on-board encryption to secure data with Steve and Patrick...
SSWUGtv: Kevin discusses licensing costs for the major Database Platforms. See the attached diagram for detai..
SSWUGtv: How do you know when it is time to ask for a raise? Laura Rose has some great tips today!..
SSWUGtv Security Edition: Steve and Patrick discuss encryption and key management in Windows Azure...
SSWUGtv: Why do bosses seem to be happier than non-managerial workers? Laura has the answers today!..
SSWUGtv: Kevin Kline discusses SQL Server Licensing in 20 minutes..
SSWUGtv: How do you recover from a bad review or a termination? Laura Rose is on the case...
SSWUGtv: Steve and Joseph Vertido MD-MVP Channel Manager / Data Quality Analyst talk about clean data and SSI..
SSWUGtv: Bragging tips for the terminally shy - with Laura Rose!..
SSWUGtv: Today, Laura gives tips on how to rebuild confidence after you've been out of work for some time...
SSWUGtv: What encryption key manager is right for me? (Cloud, VM, HSM, Hosted HSM, etc.)..
SSWUGtv: Are you an introvert? Here are some great public speaking tips to get you through your next nightmar..
SSWUGtv: Steve and Patrick discuss overcoming the challenges of securing data in Windows Azure...
Manage SQL Server Efficiently with PowerShell Remoting..
Dimensional Modeling for the DBA..
SSIS Patterns-Performance testing and optimization using Hashing..
SMO Internals for High Performance Automation..
The Future of the DBA..
Excel 2013: BI for the Masses..
SSWUGtv: AMI announces the launch of its greatly enhanced StorTrends Hybrid SSD Array in today's interview wi..
SSWUGtv: Want some advice for improving your odds of finding, getting called for, and eventually landing a po..
SSWUGtv: Kevin Kline discusses the Microsoft MVP certification program...
Serene Velocity: Reporting Services and Analysis Services Data..
Flash vs Disk vs SSD..
Analysis Services Introduction..
Prototyping with PowerPivot: Handling External Analysis Services 2012 Grouping..
Ten Breakthroughs That Changed DB2 Forever..
Choosing a Microsoft Reporting Technology..
SSWUGtv: Laura Rose gives some advice to those who want to change their career completely. What are the first..
SSWUGtv: Steve discusses his opinion on the recent Google acquisition of Nest. Be sure to comment with your o..
SSWUGtv Security Edition: The Target breach has opened up a lot of possibilities. Patrick Townsend and Steve ..
SQL Server 2012 Licensing Options..
Lessons Learned: Being Agile in a Waterfall World..
Be Friendly to SQL using some Best Practices..
Bridging the Chasm: BI Theory vs. Practice..
ETF v2 (Enhanced Threading Framework)..
The Secret Life of APPLY: Working Smarter, Not Harder – Level 300..
SSWUGtv Security Edition: Today, we discuss HIPAA/HITECH Compliance with Patrick Townsend...
Creating an End to End Power View Reporting Solution..
T-SQL Fundamentals: Logical Processing Order..
Building BI Semantic Model Tabular in 60 minutes..
Recompile or Reuse? Making the Most of Plan Cache..
Automate Policy-Based Management using PowerShell..
Encryption and Key Management in the Cloud..
SSWUGtv: Laura Rose gives great tips about how to handle competition at work gracefully...
SSWUGtv: 12 steps to take in advance of your next holiday or vacation to make sure you can make the most of y..
SSWUGtv Security Edition: Today, we discuss the Adobe Data Breach, and how they were doing encryption wrong...
Stephen talks with IBM's Leon Katsnelson about data warehousing on the cloud. Don't miss the whitepaper on..
SSWUGtv: Which is more valuable - being a Jack of All Trades or an Expert of One or a Few?..
SSWUGtv: Craig Mullins is on the show today with Stephen, talking about Relational Database Performance!..
SSWUGtv: Metalogix' Hudson Casson talks with Stephen about Total Email Management and Migration Solutions for..
SSWUGtv: How do you find the time for professional development? If you don't make the time to manage your car..
SSWUGtv: Kevin Kline and Steve discuss where database services will go in 2014...
SSWUGtv: Chuck Ezell is on the show today talking with Steve about Performance Tuning approaches. Don't miss ..
SSWUGtv: Stephen and Skyla Loomis from IBM discuss JSON document store capabilities in DB2...
10 Hidden Time Wasters..
Build Your Holiday Entourage..
10 Career Boosting Resolutions..
SSWUGtv News: 3D printers, Carbon Negative Power, and Attention-Powered Cars! Don't miss it...
SSWUGtv - Data Points Briefing: Kevin discusses Service Packs and Cumulative Updates in SQL Server...
SSWUGtv: Everyone wants to work well with their co-workers and boss. But sometimes it's difficult because of ..
SSWUGtv News: floating Google demo centers, false Apple unbreakable encryption, and Windows through the years..
SSWUGtv Security Edition: What security items you should look for in a hosting partner? Find out with Townsen..
SSWUGtv: John Treadway from Cloud Technology Partners is on the show to talk about releasing PaaSLane static ..
Get That Raise..
SSWUGtv Data Points Briefing: Kevin discusses the PASS Summit, innovations in recovery and Availability...
SSWUGtv: Sometimes entertaining chatty coworkers borders on wasting time. How does one balance the networkin..
SSWUGtv: Steve talks to DH2i's Founder and CEO, Don Boxley regarding the launch of its brand new DxConsole Hi..
SSWUGtv Security Edition: What top industries do hackers focus on and why? Financial services, hospitality an..
SSWUGtv: Check out how the combination of ViSX with Microsoft SQL Server ensures dramatically accelerated and..
SSWUGtv: How do you maximize the benefits of attending a conference? Laura Rose has some great tips!..
SSWUGtv: Data Points Briefing- Kevin tells about some miscellaneous enhancements that are coming within the S..
SSWUGtv: The advantage of working from home can also be its downfall...
SSWUGtv News: Steve nearly destroys the studio with a light saber! Also, take a trip to mars, the solar syste..
SSWUGtv - Data Points Briefing: Kevin and Steve discuss SQL 2014 CTP, upcoming PASS announcements and some in..
SSWUGtv: Steve interviews IBM's Jessica Rockwood about Best Practices of Optimizing BLU Acceleration for Anal..
SSWUGtv News: This week, Wireless charging, Hardware Buttons (Pressy), and the XPocalypse!..
SSWUGtv Data Points Briefing: Kevin Kline discusses SQL Server 2014's X Velocity, AKA column store...
SSWUGtv News: This week, hear about Metalogix's brand new suite of email migration and archiving solutions!..
SSWUGtv: Do you need a mentor? Laura Rose has some great tips on how to find one!..
SSWUGtv - Data Points Briefing: Kevin discusses the SQL SERVER 2014 CTP (part 2)..
SSWUGtv: How do you tell employees bad news, whether it's serious or not? Laura Rose is on today's show with ..
SSWUGtv News: Susan Bradley's letter, AWS Security Issues, and a Jet Powered Beer Cooler! Check out the links..
SSWUGtv Data Points Briefing: Kevin discusses the SQL SERVER 2014 CTP and Buffer Pool Extensions...
SSWUGtv: Most people hate their jobs because they feel that they do not have any control. What do you do if y..
SSWUGtv News: Enterprises' archaic java and flash, odd travel gadgets, and biobracelet passwords...
SSWUGtv Data Points Briefing: Kevin Kline discusses SQL Server 2014 and the features that you can try out in ..
SSWUGtv: How do you prevent yourself from becoming a bad boss? What are the pitfalls to avoid?..
SSWUGtv News: Malicious QR codes, MIT's 110 core processor, and mind control...
Kevin Kline is going to be hosting a show with SSWUG every Thursday - find out what it will be about in today..
SSWUGtv News: A new version of Skype compatible with Win8, Ballmer's departure from Microsoft, and the ease o..
SSWUGtv Security Edition: What are the implications of choosing a hosting providor and how do you choose secu..
SSWUGtv: How do you quantify goals with intangible goals?..
SSWUGtv News: This week we're talking about the USB 3.1, Talking Robots, and a Single 3D lens..
SSWUGtv Security Edition: Virtualized Environments and Key Management with Patrick Townsend..
SSWUGtv: It's important to do one brave thing a week at work - what is the bravest thing you've ever done?..
SSWUGtv News: 3D Storage Chips, Britney Spears on Physics, and Lab Meat..
SSWUGtv Security Edition: What kinds of key considerations are ISVs faced with when working in HIPAA-type are..
SSWUGtv: How do you manage mediocre employees? Get some tips from Laura Rose!..
SSWUGtv: We're getting ready for tomorrow's webcast with George Baklarz from IBM!..
SSWUGtv News: Fly-eating lamps, China's massive Windows XP problem, and electric roads!..
SSWUGtv: How do you stay focused on your work during the summer months? Take some tips from Laura Rose!..
SSWUGtv News: Urine batteries, Talking Cars, and Spamming the NSA today!..
SSWUGtv: How do you keep your job safe while your company looks for contractors?..
SSWUGtv News: Free Supercomputers, Big Data Bob, and 3d printed Duck Foot!..
Where should I be encrypting my data..
SSWUGtv Security Edition: Cross-platform security; how do you have a hybrid environment and keep it secure?..
SSWUGtv: When you have employees working remotely, how do you keep them from feeling left out and keep them i..
SSWUGtv News: Breaking News! Plus, Microsoft and the DOJ, plus BYOD causing issues at global companies...
Using Log Shipping for High Availability..
Dimension Modeling 101..
Dimension Table Design 101..
Fact Table Design 101..
Visual Studio Test Projects..
Deploying OLAP Solutions with Visual Studio 2008..
Performance Tuning for Analysis Services..
SQL 101 - The Essentials..
SQL 102 - The Essentials: Beyond the Basics..
SQL 103 - The Essentials: DMVs and T-SQL for the DBA..
ABCs of CTEs..
Do Certifications Really Matter?..
Extended Events: Working Smarter, Not Harder..
Become Your Own Picasso: Writing Better T-SQL..
Doing More (ETL) With Less (Effort) by Automating SSIS..
Processing Flat Files with SSIS..
SQL Data Services 101..
Disk and I/O Tuning on SQL Server 2005..
Surviving the Data Avalanche..
Incremental Data Warehouse Loads with Merge & CDC..
Avoiding Common Pitfalls in SSIS..
SSIS Connectivity Options in SQL Server 2008..
Hosting PowerShell in a .NET Applications..
Build an Excel Solution in PowerShell..
Build a .NET Solution in PowerShell..
Intro to Data Modeling..
Secrets of the Phantom Row..
7 SQL Server Development Practices More Evil Than Cursors..
Microsoft Single Sign-On Service..
Data Access Madness: Choosing a Strategy for Accessing Data..
Web UI Warfare: MVC vs. Web Forms..
Building, Configuring, Hosting and Deploying a Service-Oriented Application with Windows Communication Founda..
Building Reliable Distributed Services with Windows Communication Foundation 3.5..
Beginning Feature Design..
Using SharePoint's Built-In Mobile Features..
Customizing the Content Query Web Part..
Panic! Disaster Strikes..
SQL Server 2008 Data Compression..
Designing Advanced Searches..
Securing SQL Server..
SQL Server Forensics..
Next Generation Data Warehousing with SQL Server 2008..
Performance Data Collection for SQL Server 2008..
Pervasive Business Intelligence..
Platform For All Data..
Using Access with SQL Server..
Building Simple Reports with Reporting Services..
Creating and Managing User Accounts..
Using Excel with SQL Server..
Importing and Exporting Data with SQL Server..
Using and Understanding the Surface Area Configuration Tool..
Using Word and SQL Server..
Backing Up Your Databases..
Documenting Your System..
Installation and Configuration..
Maintenance Checks: On-Going Well Being..
Restore Your Database..
SQL Server Counters..
Creating Databases: Options and Best Practices..
Jobs and Alerts..
SQL Server Engine..
Fault Tolerance Options..
Performance & Scale..
Visual Studio Team System Database Edition..
ESB Toolkit 2.0 for BizTalk Server 2009..
Implementing BizTalk Solutions with ESB Toolkit 2.0..
DTS Conversion to SSIS..
Database Management: What Really Matters part 1..
Database Management: What Really Matters part 2..
Database Management: What Really Matters part 3..
Database Management: What Really Matters part 4..
Getting Started with PowerPivot (1 of 4)..
The IT Perspective on PowerPivot (2 of 4)..
Building Advanced Applications with PowerPivot (3 of 4)..
Beyond the Desktop: PowerPivot in your Business Infrastructure (4 of 4)..
15 Minutes on Clustering..
Upgrade to SQL Server 2008..
SharePoint and SQL Server 2008 Business Intelligence: Part 1..
SharePoint and SQL Server 2008 Business Intelligence: Part 2..
Processing Late Arriving Facts with Integration Services..
Using the Data Profiling Task in SSIS 2008..
Convert Your Script to a Custom Task in Five Easy Steps..
Customizing Dynamic Data..
jQuery Quick Hit..
Visual Studio 2008 Tips & Tricks..
Policy Based Management of SQL Server..
PowerShell for SQL Server..
Why Do We Make This So Hard?..
SQL Server 2005 Full Text Search..
SQL Server Merge Replication..
SQL Server Transactional Replication..
SQL Server 2008: Drive Your Way to the DMV..
SQL Server 2008: High Availability Through SQL Server..
SQL Server 2008: The Power of Reporting..
BI for the DBA: Using the Data Collector in SQL Server 2008..
Check In Your SQL!..
Using CLR Integration..
New Data Types and T-SQL Enhancements in SQL Server 2008..
DBA Basic Checklist..
Files and Filegroups..
Add It Up: Analysis Services Aggregations..
PerformancePoint Services 101..
Financial Analytics with SQL Server Analysis Services..
Full Spectrum Business Intelligence..
Preparing for Microsoft Project Gemini..
Dimension Table ETL with SSIS..
Fact Table ETL with SSIS..
SSAS Cube and Dimension Processing with SSIS..
Are You Following Your Own Best Practices?..
Improving Daily Imports with Partitioned Tables..
Necessary Evils: Building Optimized CRUD Procedures..
SQL Statement Tuning with Query Optimizer Strategies..
SQL Statement Tuning with SHOWPLAN..
Managing SQL Server Reporting Services 2008..
Developing Reports with SQL Server Reporting Services 2008..
Seven Extraordinary Things to do with Integration Services 2008..
Embedding Reporting Into Applications with the ReportViewer Control..
Enriching the Design of a Microsoft SQL Server 2008 Analysis Services UDM..
So this Query walks into a bar.....
The Sci-Fi Computer..
What's New in ASP.NET 4..
Deploying ASP.NET Apps the Easy Way..
Get jQuery.ready() with Rachel Appel..
ASP.NET Security: It's the least you can do..
Developing and Deploying an On-Premise .NET Application with Azure Table Storage..
Developing and Deploying a WCF Application with Azure Compute Services and Azure Table Storage..
Business Data Catalog..
Capacity Planning in SharePoint 2007..
Configuring Enterprise Search..
Auditing Your Users: Who's in your database?..
Database Change Process..