Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all entities. Seth Delconte shows how to use them.
Free training in New York. Come learn about SQL Server, meet other pros, and then enjoy a night in the city.
Today Steve Jones talks about how you can find a really good job. And how you can make changes in your life to get you there.
Red Gate Software is looking to offer a new monitoring service and is looking for opinions and ideas in making it happen.
We’ve all heard about Extended Events and how they can help troubleshoot SQL Server performance, connectivity, and locking problems, but they seem so difficult to implement using T-SQL. Isn’t there a better way to implement SQL Server Extended Events?
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.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Tlp/Wa_Cs:0817-866-887 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal Sudirman...
WhatsApp:0817-866-887 Jl. Dr Ir H Soekarno, Ruko promenade. 8 Surabaya 60298, Kedung Baruk, Kec....
WhatsApp:0817866887 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers