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.
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 couldn’t see anything...
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...
There's little that's revolutionary or radically new for security in SQL Server 2012, but there are a lot of nice enhancements that continue to refine server and database security....
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....
The best free SQL Server downloads to help you do your job....
The first all-digital issue of SQL Server Pro provides a readable magazine-like experience while incorporating upgraded interactive features....
Responding to his most popular reader request, Russ provides 15 sample MDX queries that you can try out in Analysis Services' FoodMart Sales cube....
You're the one on the front lines; who better to drill your code to peak performance? Here's why and how to put stored procedures through their paces....
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. ...
Be sure to get the latest updates about Microsoft System Center with these new resources.
Here is an easy way to leverage your existing skills in traditional SQL Server reporting tools with the new Tabular Mode of SQL Server Analysis Services to get started taking ...
Question: In our new process to verify backups we’ve discovered that our master database seems to be corrupt. However, running DBCC CHECKDB on the actual master database does not ...
In both of the sessions that I covered in SQL Server Pro’s eLearning Event entitled Practical SQL Server Improvements for Businesses, I made mention of additional context, ...
DBAs and software architects may want to consider whether businesses are storing more data than actual business needs dictate.
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