Most T-SQL Queries Don’t Even Try to Handle Errors.
David Tovee asked a great question in yesterday’s Mastering Query Tuning class. He asked his fellow students, “How many of you actually use TRY/CATCH?” I turned it into a Twitter poll because I wanted to check a wider audience: When t …
Testing SQL Server Databases Using SQL Test
The post Testing SQL Server Databases Using SQL Test appeared first on SQLServerCentral.
SQL Compilations/sec is not what you think it is
The post SQL Compilations/sec is not what you think it is appeared first on SQLServerCentral.
Working with Get Metadata Activity in Azure Data Factory
Introduction While working in Azure Data Factory, sometimes we need to retrieve metadata information, like the file name, file size, file existence, etc. We can use the Get Metadata activity to retrieve metadata information from the data set and then w …
You Probably Shouldn’t Index Your Temp Tables.
When you’ve got a process that uses temp tables, and you want to speed it up, it can be tempting to index the temp table to help work get done more quickly. However, in most cases – not all, but most – that’s a bad idea. To expl …
Connect to MySQL Through SSH Using the CData MySQL Driver
There are two major options for securely exposing access to your MySQL database over an unsecured network: an SSL connection or an SSH tunnel. The CData MySQL Driver provides a secure, live data connection to MyS …
Microsoft at PASS Data Community Summit 2021
The post Microsoft at PASS Data Community Summit 2021 appeared first on SQLServerCentral.
Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists
SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes …
Mark Your Calendars: Free Live SQL Server Training Classes in October & November.
This fall, I’m going to teach you the fundamentals of Microsoft database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fa …
Using Coalesce to Clean Up Reports
The T-SQL language is quite extensive and includes many functions that are useful for various purposes. One of the lesser used ones I encounter is COALESCE(). Recently I found myself using this to help with a report recently. I decided to include a few …
SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL
The post SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.
How to query private blob storage with SQL and Azure Synapse
The post How to query private blob storage with SQL and Azure Synapse appeared first on SQLServerCentral.
Using Multiple Azure DevOps Organizations with SQL Source Control
The post Using Multiple Azure DevOps Organizations with SQL Source Control appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About Microsoft SQL Server
We took a break from roaming around Iceland long enough to check in at our home studio. While we were here, I did a live Office Hours session, taking your questions about Microsoft SQL Server. Questions I answered in the video: 00:00 Introductions 02:3 …
[Video] Office Hours: Húsavík Harbor Edition
Today’s session comes to you from the harbor in Húsavík, the whale watching capitol of Europe. Questions I answered in the video: 00:00 Introductions 00:29 Is SQL Server 2019 ready for prime time now? 02:47 Does WITH NOLOCK cause hi …