On Thursday July 26th 12PM noon Central, Ami Levin will revisit some of the fundamental principles of relational databases – normalization rules, key selection and some controversies surrounding these rules.
Today Steve Jones talks about the ability of cloud services to level the field when it comes to software, especially for small companies.
This article demonstrated the steps which you must follow to gracefully truncate the publisher database transaction log file by resetting replication.
Wednesday July 25 2012, 6:00pm BST: Learn how you can use SQL Monitor to gather information and alert on extra performance data for your servers and applications, making this tool vital for keeping an eye on your business. In this free webinar David Bick, Product Manager at Red Gate, will give you an overview of SQL Monitor including the new custom metric functionality in v3.
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
BBQ and SQL Server. Come to a free day of training in Kansas City on Aug 4.
Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.
Today Steve Jones notes that security is improving at many web sites. It's not great, but it's improving. That's a good sign, or is it?
A Job interview for a database Developer is, or should be, a two-way process. They are sussing you out, and you are sussing them out.
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers