#1: You don't need a login page. You can grant access to a Windows domain group or groups, and any users not in the group(s) will not be able to...

I wonder if a .BACPAC export would be a possibility? According to https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/dac-support-for-sql-server-objects-and-versions?view=sql-server-2017 there are limitations on data types etc. The page says "A DAC package or export file...

• This reply was modified 4 years, 9 months ago by  Nice Marmot.

Hi,

I have not implemented encryption for client/server connections, though I did look into it in the past. These comments might or might not help (or at least bring the post...

'Both failed and successful logins' is recorded in the SQL Server error log. It doesn't record logoffs though. Personally I like to enable it, but others don't like it because...

If I recall correctly, DBCC CHECKDB uses a snapshot, and pages that change while it is running are copied to tempdb. If you are seeing abnormal growth of tempdb while...

I think this requires the In-Memory option, which is an additional license.

HTH

Oracle has a performance reporting tool called the Automated Workload Repository (AWR). It collects all kinds of stats, including file and object I/O. The tool needs Enterprise Edition plus a...

You can't do a full backup on a secondary replica, just a copy only backup: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-backup-on-secondary-replicas-always-on-availability-groups?view=sql-server-2016

My experience (using the same scripts) was that the full backups were taken on...

Thanks very much for your quick and helpful response. I will do that. (^_^)

I came across this comment today by HarshDeep_Singh at the foot of http://blogs.msdn.com/b/sqljourney/archive/2012/04/06/sharepoint-and-the-windows-internal-database-an-interesting-saga.aspx:

Patches for the windows internal database are released by the windows team, and should show up as...

AFAIK a SQL Server backup of all the databases means nothing would be lost. (All of SharePoint is in the databases.) I read this somewhere in the documentation - see...

Nice signature, Lowell. 😀

IMHO This is pretty ugly code. I cannot write C#, but all it is doing is selecting element N from a delimited list. You could replace it with something like...

What do you get in the SID column of master.sys.server_principals for 'NT AUTHORITY\SYSTEM'? I get:

0x010100000000000512000000

There is a trick in http://security.fnal.gov/cookbook/LocalSystem.html for becoming the NT AUTHORITY\SYSTEM account. You could try...

Probably JDBC is the way to go, as Mac OS X is a Unix variant under the hood. Apple is picky about packaging JDKs with the OS though. For query...