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.
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 performance-related best...
The best free SQL Server downloads to help you do your job....
Question: I’ve been wondering about record storage in indexes and how SQL Server maintains the ordering. At what point do records get moved around on the index pages so that they’re stored in the...
Some T-SQL best practices include thinking in a relational way, always remembering NULLs and the three-valued-logic, realizing the full implications of using the NOLOCK hint and therefore avoiding...
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....
Recently I was shown a whitepaper from EMC titled "Backup and Recovery for Microsoft SQL Server Using EMC Data Domain Deduplication Storage Systems". Over all the whitepaper isn't bad giving...
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 ...
Microsoft recently launched Trust Services for Windows Azure, an application-level encryption framework that can be used to protect sensitive data stored on the Windows Azure ...
by Mark Kromer This is a follow-up from my blog post last month here on SQL Server Pro about utilizing common traditional reporting tools like Excel and Report Builder with the ...
I recommend that you set your SQL Server to use the startup traceflag DBCC TRACEON (3226) to disable backup success message...
An attendee at a recent performance tuning session wanted ideas to more flexibly react to locks on blocks than using the WITH (NOLOCK) hint.
Question: I came across a weird case recently where we had a server that was running at 100% across all CPUs for a time but when I used the DMVs to look at wait statistics I ...
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.
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