Whether you are facing GDPR, HIPAA, PCI, etc. regulations, encrypting your SQL Server databases is a critical component to be compliant. SQL Server offers a few different options, but you should be aware of alternative solutions to be compliant.
I have a SQL Server that was installed as Enterprise Edition. I do not need the Enterprise features and I do not want to pay for the licensing. What is the best way to downgrade to Standard Edition? In this tip we walk through the steps.
In this tip we look at how to query SQL Server temporal tables and history tables using FOR SYSTEM_TIME including AS OF, ALL, FROM, BETWEEN and CONTAINED IN.
Whether you are facing GDPR, HIPAA, PCI, etc. regulations, encrypting your SQL Server databases is a critical component to be compliant. SQL Server offers a few different options, but you should be aware of alternative solutions to be compliant.
In this tip we look at how we can automatically build scripts based on SQL Server backup file contents to automate the restore process for SQL Server running on Linux servers.
Attend this webcast to learn tips on how to work with your system administrators to achieve a higher level of ability for your critical SQL Servers in the cloud.
To gain insight into the evolving challenges for DBAs, a study was performed to survey DBAs and those responsible for the management of the corporate data management infrastructure. The more than 200 respondents came from a wide range of industries...
Moving SQL Server from an on-premises data center to a public cloud such as AWS can enable your business to be more agile and more responsive to changing market requirements and customer needs.
Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.
Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.
