Introducing the MySQL UPDATE statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working with MySQL stored procedures Working with MySQL stored functions Introducing the MySQL SELECT s …
Expert-led PASS Data Community Summit Pre-cons
The post Expert-led PASS Data Community Summit Pre-cons appeared first on SQLServerCentral.
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit! SQL Server engineering tasks can be challenging in many ways, and some tasks just seem harder than really necessary. You can make those tasks mu …
SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more
The post SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more appeared first on SQLServerCentral.
[Video] Office Hours: Answering Your Microsoft Data Platform Questions
Ask questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 00:59 neil: is it dangerous/risky to expand a drive in azure with SQL data files on it? sql on azure …
[Video] Office Hours: Nine Minutes of Answers
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:0 …
Oracle optimizer Or Expansion Transformations
Jonathan Lewis’ continuing series on the Oracle optimizer and how it transforms queries into execution plans: Transformations by the Oracle Optimizer The effects of NULL with NOT IN on Oracle transformations Oracle subquery caching and subquery pushing …
5 Database DevOps Trends Landing on your Shoulders
The post 5 Database DevOps Trends Landing on your Shoulders appeared first on SQLServerCentral.
Bringing SQL Server Data Quality Tools to Your Company
The post Bringing SQL Server Data Quality Tools to Your Company appeared first on SQLServerCentral.
10 Considerations for a Database Migration to AWS RDS
Introduction Amazon Relational Database Service (RDS) allows us quickly deploy databases without worrying about underlying infrastructure. These pleasant words that have thrilled the business world and trickled through the industry. AWS, Azure, OCI and …
Learn the Fundamentals of TempDB for Free This Week.
Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. For this week’s TempDB class, you don’t have hands-on …
Assert Transformations in Azure Data Factory
Introduction I was recently working on a data pipeline project where I had to check data quality for the source data stream. Azure Data Factory provides Assert transformation to perform data quality and data validation checks. You can add expressions t …
DevOps 101 Webinar: Key Concepts and Terminologies
The post DevOps 101 Webinar: Key Concepts and Terminologies appeared first on SQLServerCentral.
Raising Exceptions and Error Handling with SQL Server THROW
The post Raising Exceptions and Error Handling with SQL Server THROW appeared first on SQLServerCentral.
The Basics of Updating Data in a SQL Server Table
Entry in Greg Larsen’s series on Learning T-SQL. The series so far: The basic T-SQL Select Statement Ordering a result set in SQL Server The ins and outs of joining tables in SQL Server Summarizing data using GROUP BY and HAVING The Basics of Inserting …