Viewing 15 posts - 1 through 15 (of 64 total)
#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...
March 19, 2020 at 5:10 pm
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...
March 17, 2020 at 4:19 pm
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...
February 26, 2020 at 4:42 pm
'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...
January 17, 2020 at 2:39 pm
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...
January 17, 2020 at 10:47 am
I think this requires the In-Memory option, which is an additional license.
HTH
January 6, 2020 at 3:06 pm
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...
December 13, 2019 at 4:32 pm
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...
December 3, 2019 at 3:06 pm
Thanks very much for your quick and helpful response. I will do that. (^_^)
June 27, 2019 at 2:50 pm
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...
November 12, 2015 at 8:40 am
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...
May 4, 2012 at 9:58 am
Nice signature, Lowell. 😀
October 20, 2011 at 10:20 am
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...
October 20, 2011 at 9:31 am
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...
October 12, 2011 at 7:36 am
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...
October 4, 2011 at 7:51 am
Viewing 15 posts - 1 through 15 (of 64 total)