Here Are The Results of the 2022 Data Professional Salary Survey.
Every year, I run a salary survey for folks in the database industry. This year, I was especially curious to see the results to find out whether salaries went up. Anecdotally, I’ve seen a lot of people jumping ship to new companies due to the Gre …
How to (Somewhat) Increase SQL Server Security
Problem Some time ago Argenis Fernandez(@DBArgenis) found and described a vulnerability that allows you to get into SQL Server with ‘sa’ rights. This method does not require a restart of the SQL Server service or the whole machine, the condition is a l …
Adding Users to Azure SQL Databases
The post Adding Users to Azure SQL Databases appeared first on SQLServerCentral.
How to Create a FOR Loop in SQL Server
The post How to Create a FOR Loop in SQL Server appeared first on SQLServerCentral.
Run Queries Across Many Data Sources at Once with the CData Query Federation Driver
The CData Query Federation Driver, allows you to federate and aggregate data across drivers as a single database connection. You can combine the Query Federation Driver with other CData JDBC Drivers or CData ADO.NET Providers t …
Dealing with Failed SQL Migrations in MariaDB or MySQL
The post Dealing with Failed SQL Migrations in MariaDB or MySQL appeared first on SQLServerCentral.
A Day in the Life of a SQL Server Data Architect
The post A Day in the Life of a SQL Server Data Architect appeared first on SQLServerCentral.
DBAs at work #3: The finance company Manager DBA
The post DBAs at work #3: The finance company Manager DBA appeared first on SQLServerCentral.
Learn about SQL Joins on Multiple Columns
The post Learn about SQL Joins on Multiple Columns appeared first on SQLServerCentral.
Flyway with MariaDB for Those of a Nervous Disposition
The post Flyway with MariaDB for Those of a Nervous Disposition appeared first on SQLServerCentral.
Views in SQL Server 2019 with SSMS
In SQL Server, a view is a virtual table with contents that you define by means of a query. The structure of a view is similar to a table. The contents of a view comprise a set of named columns and rows of data, that are generated dynamically whenever …
CData Connect: Derived Views and Query Federation
Enterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently explore and analyze data at large-scale. CData Connect solves the challenge of data exploration and discovery through vi …
Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow
The post Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow appeared first on SQLServerCentral.
Bulk Loading Data via a PowerShell Script in Flyway
The post Bulk Loading Data via a PowerShell Script in Flyway appeared first on SQLServerCentral.
The SQL Server Posts You Read the Most in 2021
I think of my blog posts in a few different categories: Posts that will only be read at the moment they’re published (like upcoming webcasts, humorous stuff, and career advice) Posts that will show up in search history over time and continue to b …