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 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 mentioned that I’d...
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 Platform. Read more......
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 new SQL Server 2012...
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...
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.
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 ...
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 ...
Question: We recently tried to attach a SQL Server 2008R2 database to SQL Server 2012 and the upgrade failed because one of the filegroups in the database is set to read-only. ...
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