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.
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.
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.
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.
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...
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another opti
I recently had a task to move SQL Reporting Services to a new server. While researching I found two methods to accomplish this task. One used a scripting tool which I wrote an article about and the other method is the one recommended by Microsoft. This me
Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.
Thus far in this tips series on Access and SQL Server we have created an ODBC Data Source Name (DSN) using the OLEDB driver, created a System DSN for the new SNAC (SQL Native Client) driver and created linked tables in Access by using the SNAC DSN. At th
When using Database Mirroring and if you have not placed your database files for your principle database and mirrored database on an identical path then adding a database file to the principle database is quite different than the normal process. In this c
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.
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.
