Thomas LaRock
Home
Blog
Portfolio
Data On the Rocks
MSSQL
SET NOCOUNT For SQL Server
You Can’t Marry Your Database, But You Can Have Relations
Tune Workloads, Not Queries
101 Ways to Say NO to SysAdmin Requests
SQL Plan Warnings
Use SQLMap to Connect Directly to Azure SQL Database
Modify SQL Audit for Azure SQL Database
Why AWS and Azure Benchmarks Don't Matter to Me
Reviewing the GigaOM SQL Transactional Processing Price-Performance Testing
Your Dashboards Still Suck
Using SQL Server Performance Objects
SQL Injection Protection
Updated Analytics and Big Data Comparison: AWS vs. Azure
Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
Life is dirty. So is your data. Get used to it.
The Cause of Every Deadlock in SQL Server
Designing a Database: 7 Things You Don't Want To Do
Achievement Unlocked: Certified in Artificial Intelligence
Adding Python Packages to SQL Server 2017
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
Analyzing Stack Overflow Data Directly and with PowerBI
SQL Audit Not Showing Full SQL Statement
Data Collection: How To Gather Meaningful Data
How To Hide an Instance of SQL Server
The Generous DBA
Announcing the Launch of SQL Server Buzzfeed!
Azure SQL Data Warehouse Costs vs AWS Redshift
Azure vs. AWS Analytics and Big Data Services Comparison
Azure Cosmos DB Costs vs Dynamo DB and Neptune
Azure vs. AWS Data Services Comparison
We Need To Talk About Dashboards
GDPR Violations Are Hiding In Your Database - Here's How To Find Them
Is SQL Server 2017 Stable?
The SQL Server Tiger Team Bookmarks
The 7 Data Migration Mistakes You're Probably Making
SQL Data Discovery and Classification
Schema Compare for SQL Server
Auditing Linked Servers
Data Migration Assistant Custom Configuration
When to Use Row or Page Compression in SQL Server
The Seven Samurai of SQL Server Data Protection
Microsoft Azure Threat Detection Types
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
Data Migration Assistant Error During Assessment of SQL Server 2017
SQL Vulnerability Assessment Available in SSMS
What's In Your Database?
Restoring SQL Server Database on Linux Using SQL Operations Studio
Becoming a Query Performance Troubleshooting Expert
Using sqlmap to Test For SQL Injection Vulnerabilities
Audit SQL Server Jobs
SQL Vulnerability Assessment
Killing the "SQL Server is a Memory Hog" Myth
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
Speaking at SQL Server Live!
Why I'm Learning Data Science
Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings
Microsoft MVP For the Ninth Time
Changing Default Database File Locations in SQL Server 2016
12 Ways Smart Data Professionals Act Stupid
Security is a Shared Responsibility
SQL Profiler Will Never Die
Upgrading to SQL Server 2016: Post-upgrade tasks
Upgrading to SQL Server 2016: Upgrade tasks
Upgrading to SQL Server 2016: Pre-upgrade tasks
Upgrading to SQL Server 2016: Reasons for upgrading
View BACPAC Files Using This One Weird Trick
Install-Module dbatools
SQL Server 2016 Updated Privacy Statement
KPIs For DBAs to Show Their CIOs
HOW TO: Solve General SQL Server Connectivity Issues
SQL Slammer Is Back. Here's What You Need to Know
What Does a DBA Do All Day?
How Safe Is Your Data From Theft?
The 5 Deadly Data Management Sins
Join Me at SQL Konferenz 2017
6 Ways To Treat Your Data Right
SQL Server Identity Values Check on GitHub
Using Non-default Ports for SQL Server
The Future of the DBA
Installing SQL Server vNext on Red Hat Enterprise Linux in Azure
2016 Microsoft MVP Summit Preview
Crosstown Traffic and the Future of Monitoring
How To View Always Encrypted Data in SQL Server Management Studio
8 Ways To Be Successful With Microsoft Azure SQL Database
How To Survive A Database Disaster
SQL Server Trace Flags
HOW TO: Restore the Master Database in SQL Server 2016
SQL Server 2016: It Just Runs Faster
Deconstructing Silos
The Server Draft
Why You're Wrong: The Data Professional’s Guide To Contentious Issues
Advanced Accidental Database Design
Microsoft MVP For Eight Straight
SQL Server 2016: What Time Is It?
SQL Server Linked Server Connection Test
Migrating Data From a TDE Enabled SQL Server Database Without a Key
The Top 5 Most Common Problems With SQL Server
Pause SQL Server Service Before Restarting
SQL 2016 Perform Volume Maintenance Task
HOW TO: Change the Compatibility Level of an Azure SQL Database
15 Things That Didn't Happen To Me In 2015
SQL Server Identity Values Check
The DBA Plate for 2016
#datahug
Notes From the PASS Summit Keynote
PASS Summit 2015 Preview
HOW TO: Improve Database Performance Without Changing Code
HOW TO: Recreate SQL Server Statistics In a Different Environment
101 Things I Wish You Knew About SQL Server
SQL Server Backup Audit
Get All Endpoints for VMs in an Azure Subscription
Microsoft Ignite Recap
Troubleshooting Azure Connectivity: Ports and Endpoints
Enterprise Data World 2015 Recap
Presenting This Week: Enterprise Data World
HOW TO: Find When SQL Server Wait Stats Were Last Cleared
Changing Default Database File Locations in SQL Server 2014
Using Templates With SQL Server Management Studio
HOW TO: Recycle the SQL Server Analysis Services msmdsrv.log File
5 Things You Didn’t Know About SQL Agent
SQL MVP
Microsoft Fabric is the New Office
Microsoft Data Platform MVP - Fifteen Years
Stop Using Production Data For Development
Microsoft Data Platform MVP – A Baker's Dozen
SET NOCOUNT For SQL Server
You Can’t Marry Your Database, But You Can Have Relations
Book Review: Calling Bullshit
Tune Workloads, Not Queries
101 Ways to Say NO to SysAdmin Requests
Microsoft Data Platform MVP - Still Crazy After All 12 Years
SQL Plan Warnings
Use SQLMap to Connect Directly to Azure SQL Database
Modify SQL Audit for Azure SQL Database
20 Things You Need to Stop Doing in 2020
Black Hat London
Your Dashboards Still Suck
Using SQL Server Performance Objects
Microsoft Professional Program Is Ending
Microsoft MVP - These Go To Eleven
SQL Injection Protection
Updated Analytics and Big Data Comparison: AWS vs. Azure
Updated Data Services Comparison: AWS vs. Azure
Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
Happy Data Privacy Day!
Three Ways to Become Data-Centric
Yes, SQL Server Standard Edition is NUMA Aware
Fact Checking Some Statements from the AWS re:Invent Keynote
Quantum Computing Will Put Your Data at Risk
Why I’m Not Worried About Skynet
Cloud Vampires
No, You Don’t Need a Blockchain
Life is dirty. So is your data. Get used to it.
The Cause of Every Deadlock in SQL Server
Designing a Database: 7 Things You Don't Want To Do
Achievement Unlocked: Certified in Artificial Intelligence
Microsoft MVP - Ten Years and Counting
Databases 101
The Future Isn’t In Databases, But In the Data
Adding Python Packages to SQL Server 2017
Unpacking the Language of GDPR
Azure Cosmos DB Pricing Compared to DynamoDB and NeptuneDB
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
Analyzing Stack Overflow Data Directly and with PowerBI
SQL Audit Not Showing Full SQL Statement
I'm Certified in Big Data
The Generous DBA
Azure SQL Data Warehouse Costs vs AWS Redshift
Azure vs. AWS Analytics and Big Data Services Comparison
You Are Not Data-Driven
Azure Cosmos DB Costs vs Dynamo DB and Neptune
We Need To Talk About Dashboards
GDPR Violations Are Hiding In Your Database - Here's How To Find Them
Is SQL Server 2017 Stable?
The SQL Server Tiger Team Bookmarks
The 7 Data Migration Mistakes You're Probably Making
SQL Data Discovery and Classification
Schema Compare for SQL Server
Auditing Linked Servers
Data Migration Assistant Custom Configuration
The Seven Samurai of SQL Server Data Protection
A Few Words about GDPR, Data Privacy, and this Blog
Microsoft Azure Threat Detection Types
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
Data Migration Assistant Error During Assessment of SQL Server 2017
SQL Server Guidance to Protect Against Meltdown and Spectre Attacks
17 Things That Didn't Happen To Me in 2017
Microsoft Connect: Resolved (Won't Fix)
SQL Vulnerability Assessment Available in SSMS
What's In Your Database?
Restoring SQL Server Database on Linux Using SQL Operations Studio
Hacking Speaker Idol
Becoming a Query Performance Troubleshooting Expert
On Speaking
Using sqlmap to Test For SQL Injection Vulnerabilities
Audit SQL Server Jobs
SQL Vulnerability Assessment
The Stack
How To Reset Your OneDrive
Killing the "SQL Server is a Memory Hog" Myth
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
Speaking at SQL Server Live!
Data Analysis ToolPack in Excel
Book Review: Code Warriors
Why I'm Learning Data Science
Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings
Microsoft MVP For the Ninth Time
Changing Default Database File Locations in SQL Server 2016
12 Ways Smart Data Professionals Act Stupid
The Future For Database Transaction Units
Security is a Shared Responsibility
SQL Profiler Will Never Die
Book Review: The Death of Expertise
Upgrading to SQL Server 2016: Post-upgrade tasks
Upgrading to SQL Server 2016: Upgrade tasks
Upgrading to SQL Server 2016: Pre-upgrade tasks
Upgrading to SQL Server 2016: Reasons for upgrading
View BACPAC Files Using This One Weird Trick
Install-Module dbatools
SQL Server 2016 Updated Privacy Statement
KPIs For DBAs to Show Their CIOs
HOW TO: Solve General SQL Server Connectivity Issues
SQL Slammer Is Back. Here's What You Need to Know
What Does a DBA Do All Day?
How Safe Is Your Data From Theft?
The 5 Deadly Data Management Sins
Join Me at SQL Konferenz 2017
6 Ways To Treat Your Data Right
SQL Server Identity Values Check on GitHub
Using Non-default Ports for SQL Server
The Future of the DBA
Installing SQL Server vNext on Red Hat Enterprise Linux in Azure
2016 Microsoft MVP Summit Preview
Crosstown Traffic and the Future of Monitoring
How To View Always Encrypted Data in SQL Server Management Studio
The Future of Monitoring
More General and Less SQL
Everything Old Is New Again: 5 IT Headaches That Never Go Away
8 Ways To Be Successful With Microsoft Azure SQL Database
How To Survive A Database Disaster
SQL Server Trace Flags
HOW TO: Restore the Master Database in SQL Server 2016
SQL Server 2016: It Just Runs Faster
Deconstructing Silos
Why You're Wrong: The Data Professional’s Guide To Contentious Issues
Microsoft MVP For Eight Straight
SQL Server 2016: What Time Is It?
SQL Server Linked Server Connection Test
Migrating Data From a TDE Enabled SQL Server Database Without a Key
The Top 5 Most Common Problems With SQL Server
Pause SQL Server Service Before Restarting
SQL 2016 Perform Volume Maintenance Task
HOW TO: Change the Compatibility Level of an Azure SQL Database
15 Things That Didn't Happen To Me In 2015
SQL Server Identity Values Check
The DBA Plate for 2016
Notes From the PASS Summit Keynote
Help Keep PASS Summit Awesome for Everyone
HOW TO: Improve Database Performance Without Changing Code
Lost Data
HOW TO: Recreate SQL Server Statistics In a Different Environment
101 Things I Wish You Knew About SQL Server
SQL Server Backup Audit
On Friction
Get All Endpoints for VMs in an Azure Subscription
Troubleshooting Azure Connectivity: Ports and Endpoints
Enterprise Data World 2015 Recap
Presenting This Week: Enterprise Data World
HOW TO: Find When SQL Server Wait Stats Were Last Cleared
Changing Default Database File Locations in SQL Server 2014
Using Templates With SQL Server Management Studio
HOW TO: Recycle the SQL Server Analysis Services msmdsrv.log File
5 Things You Didn’t Know About SQL Agent
Database Design
You Can’t Marry Your Database, But You Can Have Relations
Tune Workloads, Not Queries
SQL Plan Warnings
SQL Injection Protection
Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
No, You Don’t Need a Blockchain
Life is dirty. So is your data. Get used to it.
The Cause of Every Deadlock in SQL Server
Designing a Database: 7 Things You Don't Want To Do
Databases 101
SQL Audit Not Showing Full SQL Statement
Announcing the Launch of SQL Server Buzzfeed!
Schema Compare for SQL Server
When to Use Row or Page Compression in SQL Server
The Seven Samurai of SQL Server Data Protection
What's In Your Database?
Killing the "SQL Server is a Memory Hog" Myth
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
Changing Default Database File Locations in SQL Server 2016
View BACPAC Files Using This One Weird Trick
The 5 Deadly Data Management Sins
SQL Server Identity Values Check on GitHub
How To View Always Encrypted Data in SQL Server Management Studio
How To Survive A Database Disaster
The Server Draft
Why You're Wrong: The Data Professional’s Guide To Contentious Issues
Advanced Accidental Database Design
SQL Server 2016: What Time Is It?
Migrating Data From a TDE Enabled SQL Server Database Without a Key
15 Things That Didn't Happen To Me In 2015
SQL Server Identity Values Check
HOW TO: Improve Database Performance Without Changing Code
Enterprise Data World 2015 Recap
Presenting This Week: Enterprise Data World
Using Templates With SQL Server Management Studio
SQL Server Performance
Pro SQL Server 2022 Wait Statistics Book
You Can’t Marry Your Database, But You Can Have Relations
Tune Workloads, Not Queries
SQL Plan Warnings
Why AWS and Azure Benchmarks Don't Matter to Me
Reviewing the GigaOM SQL Transactional Processing Price-Performance Testing
Using SQL Server Performance Objects
Yes, SQL Server Standard Edition is NUMA Aware
Cloud Vampires
The Cause of Every Deadlock in SQL Server
Is SQL Server 2017 Stable?
The SQL Server Tiger Team Bookmarks
When to Use Row or Page Compression in SQL Server
The Seven Samurai of SQL Server Data Protection
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
SQL Server Guidance to Protect Against Meltdown and Spectre Attacks
SQL Vulnerability Assessment Available in SSMS
What's In Your Database?
Becoming a Query Performance Troubleshooting Expert
Killing the "SQL Server is a Memory Hog" Myth
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
The Future For Database Transaction Units
Upgrading to SQL Server 2016: Post-upgrade tasks
Upgrading to SQL Server 2016: Upgrade tasks
Upgrading to SQL Server 2016: Pre-upgrade tasks
Upgrading to SQL Server 2016: Reasons for upgrading
View BACPAC Files Using This One Weird Trick
HOW TO: Solve General SQL Server Connectivity Issues
What Does a DBA Do All Day?
The 5 Deadly Data Management Sins
SQL Server Identity Values Check on GitHub
Crosstown Traffic and the Future of Monitoring
8 Ways To Be Successful With Microsoft Azure SQL Database
SQL Server Trace Flags
HOW TO: Restore the Master Database in SQL Server 2016
SQL Server 2016: It Just Runs Faster
The Server Draft
Advanced Accidental Database Design
The Top 5 Most Common Problems With SQL Server
SQL 2016 Perform Volume Maintenance Task
HOW TO: Change the Compatibility Level of an Azure SQL Database
SQL Server Identity Values Check
The DBA Plate for 2016
HOW TO: Improve Database Performance Without Changing Code
HOW TO: Recreate SQL Server Statistics In a Different Environment
Changing Default Database File Locations in SQL Server 2014
SQL MCM
The Generous DBA
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
Upgrading to SQL Server 2016: Post-upgrade tasks
Upgrading to SQL Server 2016: Upgrade tasks
Upgrading to SQL Server 2016: Pre-upgrade tasks
Upgrading to SQL Server 2016: Reasons for upgrading
HOW TO: Restore the Master Database in SQL Server 2016
HOW TO: Find When SQL Server Wait Stats Were Last Cleared
Professional Development
Book Review: The AI Playbook
Twenty Years
The Most Important Feature in Microsoft Teams You Aren't Using
Achievement Unlocked: Certified in Artificial Intelligence
I'm Certified in Big Data
The Generous DBA
20 Ways to Get The Most Out of Your Data Platform
Hacking Speaker Idol
Becoming a Query Performance Troubleshooting Expert
On Speaking
The Stack
Speaking at SQL Server Live!
Why I'm Learning Data Science
Microsoft MVP For the Ninth Time
12 Ways Smart Data Professionals Act Stupid
Security is a Shared Responsibility
Book Review: The Death of Expertise
Relationships Matter More Than Money
On Leadership
What Does a DBA Do All Day?
Join Me at SQL Konferenz 2017
The Future of the DBA
2016 Microsoft MVP Summit Preview
More General and Less SQL
Everything Old Is New Again: 5 IT Headaches That Never Go Away
Deconstructing Silos
14 Things Sysadmins Can Learn From an Elf
The DBA Plate for 2016
Notes From the PASS Summit Keynote
Help Keep PASS Summit Awesome for Everyone
PASS Summit 2015 Preview
Blogging Update
On Friction
I Do Not Choose To Run
Enterprise Data World 2015 Recap
Presenting This Week: Enterprise Data World
PASS
The Generous DBA
Hacking Speaker Idol
Becoming a Query Performance Troubleshooting Expert
On Speaking
Using sqlmap to Test For SQL Injection Vulnerabilities
Join Me at SQL Konferenz 2017
#datahug
Notes From the PASS Summit Keynote
Help Keep PASS Summit Awesome for Everyone
PASS Summit 2015 Preview
I Do Not Choose To Run
Enterprise Data World 2015 Recap
Travel
Black Hat London
Speaking at SQL Server Live!
Join Me at SQL Konferenz 2017
Advanced Accidental Database Design
PASS Summit 2015 Preview
Microsoft Ignite Recap
Enterprise Data World 2015 Recap
SQL Azure
SQL Plan Warnings
Use SQLMap to Connect Directly to Azure SQL Database
Reviewing the GigaOM SQL Transactional Processing Price-Performance Testing
No, You Don’t Need a Blockchain
The Future Isn’t In Databases, But In the Data
Azure Cosmos DB Pricing Compared to DynamoDB and NeptuneDB
Azure vs. AWS Data Services Comparison
Is SQL Server 2017 Stable?
Microsoft Azure Threat Detection Types
Microsoft Connect: Resolved (Won't Fix)
What's In Your Database?
Using sqlmap to Test For SQL Injection Vulnerabilities
Audit SQL Server Jobs
SQL Vulnerability Assessment
Why I'm Learning Data Science
Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings
The Future For Database Transaction Units
View BACPAC Files Using This One Weird Trick
SQL Server 2016 Updated Privacy Statement
The 5 Deadly Data Management Sins
The Future of the DBA
Installing SQL Server vNext on Red Hat Enterprise Linux in Azure
8 Ways To Be Successful With Microsoft Azure SQL Database
SQL Server 2016: It Just Runs Faster
SQL Server 2016: What Time Is It?
HOW TO: Change the Compatibility Level of an Azure SQL Database
SQL Server Backup Audit
Get All Endpoints for VMs in an Azure Subscription
Troubleshooting Azure Connectivity: Ports and Endpoints
Virtualization
What's In Your Database?
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
HOW TO: Improve Database Performance Without Changing Code
Get All Endpoints for VMs in an Azure Subscription
Troubleshooting Azure Connectivity: Ports and Endpoints
Asides
Why I'm Leaving Slack Communities
Book Review: The Death of Expertise
Relationships Matter More Than Money
More General and Less SQL
Everything Old Is New Again: 5 IT Headaches That Never Go Away
Blogging Update
42 Things You Should Never, Ever Say To a DBA
Musings
Twenty Years
I Lost 50 pounds in 5 Months, Here’s How
Hey Cortana
17 Things That Didn't Happen To Me in 2017
Relationships Matter More Than Money
16 Things That Didn't Happen to Me in 2016
The Future of Monitoring
More General and Less SQL
Why You're Wrong: The Data Professional’s Guide To Contentious Issues
15 Things That Didn't Happen To Me In 2015
14 Things Sysadmins Can Learn From an Elf
Blogging Update
42 Things You Should Never, Ever Say To a DBA
Blogging
20 Things You Need to Stop Doing in 2020
Pingdom Made Me Stop Using Disqus for Blog Comments
More General and Less SQL
Announcing the IS [NOT] NULL Newsletter
Blogging Update
Featured
Upgrading to SQL Server 2016: Upgrade tasks
Upgrading to SQL Server 2016: Reasons for upgrading
SQL Server 2016 Updated Privacy Statement
The Top 5 Most Common Problems With SQL Server
Cloud Computing
Why AWS and Azure Benchmarks Don't Matter to Me
Updated Analytics and Big Data Comparison: AWS vs. Azure
Updated Data Services Comparison: AWS vs. Azure
Quantum Computing Will Put Your Data at Risk
Why I’m Not Worried About Skynet
Cloud Vampires
No, You Don’t Need a Blockchain
Quantum Computing: What you need (and don’t need) to know
I'm Certified in Big Data
Azure SQL Data Warehouse Costs vs AWS Redshift
Azure vs. AWS Analytics and Big Data Services Comparison
Azure vs. AWS Data Services Comparison
Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings
The Future For Database Transaction Units
The Future of the DBA
The Future of Monitoring
8 Ways To Be Successful With Microsoft Azure SQL Database
Data Security and Privacy
Stop Using Production Data For Development
Create and Use an Email Alias
Use SQLMap to Connect Directly to Azure SQL Database
Modify SQL Audit for Azure SQL Database
Black Hat London
SQL Injection Protection
Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
Happy Data Privacy Day!
No, You Don’t Need a Blockchain
Unpacking the Language of GDPR
SQL Audit Not Showing Full SQL Statement
Data Collection: How To Gather Meaningful Data
How To Hide an Instance of SQL Server
GDPR Violations Are Hiding In Your Database - Here's How To Find Them
SQL Data Discovery and Classification
Auditing Linked Servers
The Seven Samurai of SQL Server Data Protection
A Few Words about GDPR, Data Privacy, and this Blog
Microsoft Azure Threat Detection Types
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
SQL Server Guidance to Protect Against Meltdown and Spectre Attacks
SQL Vulnerability Assessment Available in SSMS
What's In Your Database?
Using sqlmap to Test For SQL Injection Vulnerabilities
Audit SQL Server Jobs
SQL Vulnerability Assessment
Book Review: Code Warriors
Security is a Shared Responsibility
SQL Server 2016 Updated Privacy Statement
SQL Slammer Is Back. Here's What You Need to Know
How Safe Is Your Data From Theft?
The 5 Deadly Data Management Sins
6 Ways To Treat Your Data Right
Using Non-default Ports for SQL Server
Book Reviews
Book Review: The AI Playbook
Book Review: Calling Bullshit
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
Book Review: Code Warriors
Book Review: The Death of Expertise
Data Analytics
Fail Better, Then Finish 21st
Microsoft Fabric is the New Office
Book Review: The AI Playbook
Export to CSV in Azure ML Studio
You Can’t Marry Your Database, But You Can Have Relations
Book Review: Calling Bullshit
Your Dashboards Still Suck
Three Ways to Become Data-Centric
Life is dirty. So is your data. Get used to it.
Achievement Unlocked: Certified in Artificial Intelligence
The Future Isn’t In Databases, But In the Data
Adding Python Packages to SQL Server 2017
Analyzing Stack Overflow Data Directly and with PowerBI
Data Collection: How To Gather Meaningful Data
I'm Certified in Big Data
You Are Not Data-Driven
We Need To Talk About Dashboards
Data Analysis ToolPack in Excel
Why I'm Learning Data Science
SQL Profiler Will Never Die
SQL Server 2016
Yes, SQL Server Standard Edition is NUMA Aware
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
Auditing Linked Servers
Data Migration Assistant Custom Configuration
The Seven Samurai of SQL Server Data Protection
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
Data Migration Assistant Error During Assessment of SQL Server 2017
SQL Server Guidance to Protect Against Meltdown and Spectre Attacks
SQL Server 2017
Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
Yes, SQL Server Standard Edition is NUMA Aware
The Cause of Every Deadlock in SQL Server
Adding Python Packages to SQL Server 2017
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
Analyzing Stack Overflow Data Directly and with PowerBI
SQL Audit Not Showing Full SQL Statement
Data Collection: How To Gather Meaningful Data
How To Hide an Instance of SQL Server
GDPR Violations Are Hiding In Your Database - Here's How To Find Them
Is SQL Server 2017 Stable?
SQL Data Discovery and Classification
Auditing Linked Servers
Data Migration Assistant Custom Configuration
When to Use Row or Page Compression in SQL Server
The Seven Samurai of SQL Server Data Protection
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
Data Migration Assistant Error During Assessment of SQL Server 2017
SQL Server Guidance to Protect Against Meltdown and Spectre Attacks
Social Networking
Why I'm Leaving Slack Communities
AWS
SQL Plan Warnings
Why AWS and Azure Benchmarks Don't Matter to Me
Reviewing the GigaOM SQL Transactional Processing Price-Performance Testing
SQL Injection Protection
Updated Analytics and Big Data Comparison: AWS vs. Azure
Updated Data Services Comparison: AWS vs. Azure
Fact Checking Some Statements from the AWS re:Invent Keynote
Why I’m Not Worried About Skynet
Cloud Vampires
The Future Isn’t In Databases, But In the Data
Azure Cosmos DB Pricing Compared to DynamoDB and NeptuneDB
Announcing the Launch of SQL Server Buzzfeed!
Azure SQL Data Warehouse Costs vs AWS Redshift
Azure vs. AWS Analytics and Big Data Services Comparison
Azure Cosmos DB Costs vs Dynamo DB and Neptune
Azure vs. AWS Data Services Comparison
Azure
Microsoft Fabric is the New Office
Export to CSV in Azure ML Studio
Azure ML Studio Sample Data
Microsoft Data Platform MVP - Fifteen Years
Pro SQL Server 2022 Wait Statistics Book
Microsoft Data Platform MVP – A Baker's Dozen
Microsoft Data Platform MVP - Still Crazy After All 12 Years
SQL Plan Warnings
Use SQLMap to Connect Directly to Azure SQL Database
Modify SQL Audit for Azure SQL Database
Why AWS and Azure Benchmarks Don't Matter to Me
Reviewing the GigaOM SQL Transactional Processing Price-Performance Testing
SQL Injection Protection
Updated Analytics and Big Data Comparison: AWS vs. Azure
Updated Data Services Comparison: AWS vs. Azure
Fact Checking Some Statements from the AWS re:Invent Keynote
Why I’m Not Worried About Skynet
Cloud Vampires
Hey Cortana
The Future Isn’t In Databases, But In the Data
Azure Cosmos DB Pricing Compared to DynamoDB and NeptuneDB
I'm Certified in Big Data
Announcing the Launch of SQL Server Buzzfeed!
Azure SQL Data Warehouse Costs vs AWS Redshift
Azure vs. AWS Analytics and Big Data Services Comparison
Azure Cosmos DB Costs vs Dynamo DB and Neptune
Azure vs. AWS Data Services Comparison
Running
I Lost 50 pounds in 5 Months, Here’s How
Raw Data
Raw Data Podcast Available!
SQL Server 2022
Pro SQL Server 2022 Wait Statistics Book
personal
The Long Way 'Round
education
The Long Way 'Round
analytics
The Long Way 'Round