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,357 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,733 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
697 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
6,827 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
I was chatting with a customer recently and they wanted to know which host...
Yeah, yeah, second AI post in a row. I promise not to make a...
By Chris Yates
In the intricate world of business, where precision and efficiency are paramount, managing database...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Comments posted to this topic are about the item Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers