Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.
2018-10-15
13,800 reads
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.
2018-10-15
2,216 reads
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,317 reads
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
2018-10-12
3,200 reads
2018-10-11
21,525 reads
In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.
2018-10-11
2,818 reads
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.
2018-10-11
2,871 reads
Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.
2018-10-10 (first published: 2005-07-21)
78,888 reads
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
2018-10-10
3,405 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
Comments posted to this topic are about the item AI Steals Joy
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers