New Year’s Resolution: Lose Weight in Your Database
Made a New Year’s resolution to lose weight this year? Forget taking it off your waistline – take it off your database instead with: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘size’ Or: sp_BlitzIndex @GetAllDat …
Exploring Auto-fix in SQL Code Analysis
The post Exploring Auto-fix in SQL Code Analysis appeared first on SQLServerCentral.
How to return multiple sequence numbers with sp_sequence_get_range
The post How to return multiple sequence numbers with sp_sequence_get_range appeared first on SQLServerCentral.
Who’s Hiring in the Database Community? January 2022 Edition
Last year, I started this series of “who’s hiring” blog posts because The Great Resignation was clearly a real thing. The pandemic is causing so many folks to rethink what they do for a living, where they do it, who they do it for, an …
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 …