Tag Info

New answers tagged

4

Sorry, SQL Server does not track database use. People have come up with not-so-clever ideas like a logon trigger that checks the default database of the login and/or ORIGINAL_DB_NAME(). But this misses all kinds of things like contained users, people who later issue a USE command, cross-database queries, etc. My recommendation is SQL Server Audit if you ...


0

When I created admin users against mongos, I also created admin users for replication Set. Now I can administrate shards, config server, and mongos now. Different shards can have different users in their admin databases. If keyfile is uique, new shard (running with auth and keyfile enabled) can be added to the running cluster.


1

Since the production portion of this question hasn't been answered, I have an example of where it would be useful. I'm backing up a production table to my userspace. This table contains a lot of data (~850GB compressed) and backing up through normal means isn't possible because the log file it generates (over 18GB prior to me killing the insert) cause ...


0

If you need best practices, not minimum required values, this is how to proceed : plan a meeting between the OS main administrator and the DB main administrator, and bring along the list of minumum requirements. If those people can't figure out "best practices", nobody can.


1

The amount of memory specified in innodb_buffer_pool_size is allocated when the MySQL Server daemon starts up, and if the system doesn't have that much memory free at that moment, MySQL won't start. The amount of memory you specify is what the buffer pool gets, and it neither grows nor shrinks. InnoDB reads pages from disk into the pool as they are ...


0

I have achieved this without any SSIS. I used a linked server instead. It took me some time, but I still believe it is the best way of backing up SSAS databases. You can see how I did it on this link. I also delete old backup files, as you can see on this link.


0

The installation guide contains minimum (or recommended) values for each kernel parameter. On Metalink you can find at least one article (including formula) per each kernel parameter.


0

Determine if "Disallow adhoc access" is enabled for your provider. This can be found in SQL Management Studio via the following navigation path: Server Objects/Linked Servers/Providers/Microsoft.ACE.OLEDB.12.0 Right click the "Microsoft.ACE.OLEDB.12.0" provider and select "Properties" from the context menu. In the pop-up window, make sure that the ...


0

I have achieved this(How to delete the remote files older than N days on schedule from SQL Server 2012 (with SqlServerAgent job). I have been running backups of SSAS databases, and needed to delete the old backup files, on a different server. Please see run-a-powershell-script-on-a-different-server-from-inside-a-sql-server-job


6

I think as a DBA you will inevitably lose the fight to keep hands out of your database. Having said that I think we owe it to our customers to try and provide a product that they can use. There are dangers and pitfalls of even read-only access that any DBA should be aware of: You admitted that you are working with large record counts in your tables. What ...


1

Be happy that your users seem to be going to use SQL to do the analysis, instead of pumping to excel. Make sure you have separated tasks and don't give privs to update the source data. Resource manager is your friend to prevent runaway queries. give them resources that they need, make sure other users don't get pushed out.


1

I think there is no problem, but you need to take care about data. For example, you can grant them privileges to create tables and procedures for their needs in theirs schemas, and privileges to select data from another schemas, but not to grant privileges on insert/update/delete. If they don't have privileges on update and delete data in main tables, ...



Top 50 recent answers are included