Viewing 15 posts - 616 through 630 (of 6,032 total)
Proceeds from collected fines could go toward public awareness campaigns. Also, rather than simply establishing regulations and proscribing periodic audits, the government could hire a team to perform network penetration,...
January 30, 2019 at 9:23 am
I am skeptical about how far the government will go to enforce data privacy and protection regulations on big data companies, considering that the government actually leverages these same companies...
January 29, 2019 at 9:27 am
Also, before you drop the database, take it offline and leave in place for a few days just to see if someone or something complains.
January 28, 2019 at 11:11 am
The DMV dm_db_index_usage_stats can be used to query reads and writes on indexes.
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-2017
The columns you'll find useful are these:
last_user_seek datetime Time of last user seek
January 28, 2019 at 6:23 am
January 25, 2019 at 9:53 am
Most enterprise database environments have a hub and spoke or snowflake architecture. There is a central transactional database server, and then there are data marts and other line of business...
January 25, 2019 at 7:07 am
January 25, 2019 at 6:52 am
In addition to the firewall, you can secure access to your Azure resources using VPN, Azure AD authentication, and access tokens. For hackers, the low hanging fruit are unpatched servers,...
January 24, 2019 at 12:55 pm
January 24, 2019 at 12:25 pm
The database engine chosen for an application needs to match the expected data access patterns. RDMS are excellent for scenarios where you need to query, insert, and update manageable subsets...
January 24, 2019 at 6:56 am
Here you can estimate the costs for compute and storage.
https://azure.microsoft.com/en-us/pricing/details/sql-data-warehouse/gen2/
Also, iIf you're considering a hybrid scenario, where your source systems and applications are on-prem and your...
January 23, 2019 at 1:41 pm
In the past, I've used schemas to isolate different versions of the same object within the same database. I used this typically in development or for parallel testing in QA....
January 23, 2019 at 12:21 pm
Provide some context about how this view fits into the overall data warehouse design, and how it will be used. From a data warehousing perspective, assuming this discussion is in...
January 23, 2019 at 7:06 am
January 22, 2019 at 7:19 am
The article describes the business analyst in question using the past tense, so it makes me wonder if she was a contractor or consultant. If so, then I can see...
January 21, 2019 at 11:57 am
Viewing 15 posts - 616 through 630 (of 6,032 total)