Linked Servers: a Peek Behind the Curtain
We recently received a support call from a Gallium Data user. He was executing queries on his instance […]
Administration
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 […]
SQL Server Data Classification Comes Alive
Overview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns […]
How to Find Unused Databases in SQL Server
The post How to Find Unused Databases in SQL Server appeared first on SQLServerCentral.
Monitor SQL Server Error Logs with PowerShell
Introduction The Error Logs of your SQL instances often contain valuable information. Information that may require follow-up attention […]
Scheduling SQL Scripts Using Jenkins
Introduction There are scenarios where you need to schedule the SQL Server scripts without using SQL Server Agent, […]
Recovering Databases From a Master Backup
I ran into a very interesting thread recently, where a posted had experienced a disaster. In this case, […]
Better SQL Server Agent Job Failure Monitoring
SQL Server Agent has a built-in alerting process for when jobs fail, but the information it provides isn’t […]
Great Power(Shell)…Great Responsibility
Whenever I’m spreading PowerShell love (here with you mainly in the form of dbatools), now and then I […]
SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos
One evening I started receiving a flood of alerts from almost every single database server for one of […]
Using Recommendations for MAXDOP and Max Memory During Installation
Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings […]
Unable to connect SSIS remotely
I was working with one of my client queries and they were having issue while connecting to SSIS […]
Generate Role Member Reports using dbatools and the ImportExcel PowerShell ...
As one of dbatools’ first members, I’ve been using it for years and it’s really my goto tool. […]
Adding a Database with Polybase External Tables to Always On ...
Introduction I was asked to add a database with PolyBase External Tables to Always On Availability Group. I […]
How to Attach a SQL Server Database without a Transaction ...
The post How to Attach a SQL Server Database without a Transaction Log and with Open Transactions appeared […]
Automate your Morning Checklist
Every morning as you sit down at your desk, perhaps before you’ve even got your first cup of […]