sqlserverisv

42 Topics

Fundamentals: Cloning a production database to a test server
First published on TECHNET on Apr 22, 2011 Recently I had a conversation with someone who maintains an ISV offering.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
12KViews
1like
0Comments
How To: Clean up old database backup history
First published on TECHNET on Oct 26, 2010 The MSDB database is a system database that stores important configuration and historical information relating to SQL Server system functionality like:JobsLog ShippingAlerts and NotificationsOperatorsPoliciesDatabase MailMainteance PlansData CollectorBackup and Restore operationsDepending on how you perform certain operations orphaned data can exist that will remain in your MSDB database until it is manually removed.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
11KViews
0likes
0Comments
SQL Server Drive Configurations
First published on TECHNET on Nov 11, 2010 How and where you place your database files is a critical part in ensuring the performance and availability of your SQL Server database.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
8.2KViews
0likes
0Comments
Change Data Capture - What is it and how do I use it?
First published on TECHNET on Dec 02, 2010 In the All Good Things Come to an End - Why You Should Upgrade article we discussed some of the new features that applications can take advantage of by upgrading to SQL Server 2008.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
3.4KViews
0likes
0Comments
Adding enhanced password constraints to SQL Server
First published on TECHNET on Mar 29, 2011 [Prior Post in Series] [Next Post in Series]In my prior posts on applying PCIDSS standards to protect your company’s data I showed now a DDL trigger (FOR LOGON) may be used to enhance logon security.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
3.3KViews
0likes
0Comments
Temenos T24 - Trace Flag 834 and When to Use It
First published on TECHNET on Nov 30, 2010 TEMENOS T24 (T24) is a complete banking solution designed to meet the challenges faced by financial institutions in today’s competitive market.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
3.1KViews
0likes
0Comments
Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes
First published on TECHNET on Apr 15, 2011 [Prior Post in Series] [Next Post in Series]In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
2.6KViews
0likes
0Comments
Index Fragmentation–“If it isn’t broken, don’t fix it”
First published on TECHNET on Oct 18, 2010 Indexes get fragmented.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
2.1KViews
0likes
0Comments
Data Compression for SQL Server 2008
First published on TECHNET on Nov 10, 2010 SQL Server 2008 Enterprise Edition includes the ability to natively compress selected data on disk.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
2.1KViews
0likes
0Comments
Using Read-Committed Snapshot Isolation - Mini-Lab
First published on TECHNET on Dec 21, 2010 Dassault ENOVIA requires the use of read-committed snapshot isolation.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
2.1KViews
0likes
0Comments