Kalen Delaney has been working with SQL Server for over 26 years and provides SQL Server training and consulting to clients around the world. Her most recent book is SQL Server 2012 Internals (Microsoft Press).
If you have a large OLTP database, it might make sense to move less frequently accessed data onto cheaper storage with less frequent backups. Learn how to use table partitions to archive old data in an OLTP environment.
A new release of SQL Server is due out this year, and if you follow blogs or tweets or check Microsoft’s SQL Server website, you might have seen mention of the new version, code-named “Denali” (in keeping with the US National Park theme). Unofficial word is that this release will be called SQL Server 2011 when it’s launched.
The revised Microsoft Certified Master (MCM) in SQL Server requirements offer more opportunities for SQL Server professionals to become MCM certified. But will the new exams ensure that only qualified SQL Server professionals become MCMs?
Ask Kalen anything about SQL Server internals and working with current versions of SQL Server. She's more interested in technical deep dives and less interested in predicting the future of database administration.
So how might working in the cloud change your practices? What would you do differently if you had no access to the physical storage mechanisms and no ability to do any kind of system configuration, monitoring, or tuning?
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More