70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
644 reads
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
644 reads
SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database...
2013-07-24
1,238 reads
The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration...
2013-07-22
565 reads
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
581 reads
Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of...
2013-07-16
649 reads
Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for...
2013-07-15
357 reads
2013-07-14
289 reads
MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out...
2013-07-12
416 reads
Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send...
2013-07-11
336 reads
Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for...
2013-07-11
350 reads
A couple of weeks ago, a developer came to me and wanted to know...
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Comments posted to this topic are about the item Baseball Everywhere
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' );See possible answers