The Smart Guide to Building World-Class Applications
Delivering practical database advice for DBAs, developers, and BI analysts
Discover insights, techniques, and resources for troubleshooting performance, connectivity, and other types of problems commonly encountered in SQL Server environments.
In part 9 of this series on SQL Server database corruption I defined a list of key things to do when responding to database corruption. And in that list of options and operations was the mention that...
SQL Server professionals still forget to put indexes on tables and still forget to test their backups. Do other professions do a better job of training newbies so that certain basic mistakes tend to...
Question: I’ve been working through some disaster recovery scenario testing and sometimes I see databases marked SUSPECT and sometimes RECOVERY_PENDING. Why are there two different database states...
The best free SQL Server downloads to help you do your job....
SQL Server logs can make troubleshooting problems simpler—if you know where to look. Here are 5 SQL Server 2005 log files that might come in handy....
Database mirroring can be a great way to improve database availability because it’s fairly easy to deploy, administer, and maintain....
Every SQL table and index has at least one Index Allocation Map (IAM). Learn more about IAMs and how much space is actually allocated to a SQL Server table....
I recommend that you set your SQL Server to use the startup traceflag DBCC TRACEON (3226) to disable backup success message......
Ensuring a proper understanding of core concepts and avoiding common pitfalls are the keys to protecting against SQL injection.
This change-auditing solution lets you monitor, track, and report changes occurring on multiple SQL Server instances across a company.
Power View is an easy-to-use business intelligence (BI) tool that helps people make sense of their data.
The Registered Servers tool in SQL Server Management Studio lets you easily save the connection information for multiple SQL Server instances.
Performance tuning is half science and half art form. Learn about the science half of the tuning process.
Itzik continues his discussion of T-SQL best practices; he discusses cloud compatibility, date and time best practices, the importance of writing in a standard way, and ...
Microsoft SQL Server 2012 has major new features, such as the new Business Intelligence edition, as well as smaller changes to licensing and a new LocalDB edition.
In my previous post in my ongoing series on SQL Server database corruption I covered a list of best practices for responding to database corruption when it happens. In that post I ...
advertisement
DATES: 5/23/2012-5/23/2012
LOCATION: Your Computer
EVENT TYPE: Virtual Events
SUMMARY: Join SharePoint Pro for Migrating to SharePoint 2010, a free online one-day conference for developers and administrators of SharePoint products and technologies. This conference brings industry experts straight to your computer, offering free, technical SharePoint 2010 migration training.
More Events