Tags » SQL Server

Filegroup Restore from a Full Backup?

Can you perform a SQL Server filegroup restore using a full backup file as input?  I couldn’t find anything that specifically stated that in documentation, so I tried it.  112 more words

Administration

SQL Server 2016 FK operator bug?

I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016. One of the topics covered was a new operator for foreign key checks. 715 more words

Sql Server

Stop the over running SQL Server Agent job automatically using T - SQL based job

We setup a SQL server agent job to check if one of the intermittently over running (running forever) jobs is still running and if it is, then stop it and send email notification. 106 more words

SQL Server

Check automatically if the SQL server agent job is still running and send email notification

One of the SQL Server Agent jobs we maintain keeps running for ever and hence we decided to implement an automatic job with T-SQL which will check if the SQL server agent job is still running and send email notification. 97 more words

SQL Server

Installing and configuring SQL Server for Configuration Manager

This guide is intended to assist administration in properly configuring SQL Server prior to installing Configuration Manager.

Too many make the mistake of miss-configuring SQL Server, then need to spend a LOT of time later, correcting it. 1,309 more words

ConfigMgr

SQL or NoSQL: that is the question.

Relational database management system (RDBMS) have been a primary data storage mechanism for decades. NoSQL databases have existed since the 1960s, but have been recently gaining traction and the business faces a challenge of their efficient adoption. 549 more words