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 local administrator account on the server. Reminder SQL Server until 2008R2: Until SQL 2008R2, […]
2022-01-03
8,443 reads
Learn about the options to add users to Azure SQL Databases including SQL authentication logins, contained SQL users, contained Azure Active Directory users, mapped logins to users - including code examples you can copy and use immediately.
2022-01-03
A migration to Azure is stuck because of an encryption change in SQL Server. Learn how to get around this by using a certificate for encryption.
2021-12-31 (first published: 2019-12-05)
1,792 reads
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 to access all your SaaS, Big Data, and NoSQL sources as if they were one database. You can query or update data from a single […]
2021-12-31
714 reads
This article explains the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
2021-12-31
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
2021-12-31
This article looks at what an average day of a SQL Server Data Architect looks like and some of the things you would need to as a Data Architect.
2021-12-29
Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.
2021-12-29
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
7,090 reads
This article will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
2021-12-27
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers