Kalen Delaney


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).

Using Table Partitions to Archive Old Data in OLTP Environments 1
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.
pile of logs in the mountains
How Simple Is Logging?
A look at SQL Server's three recovery models (i.e., SIMPLE recovery, BULK_LOGGED recovery, and Full recovery) and how each of them logs data.
Welcome to (SQL Server) 2011 5

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.

Measuring Expertise: The New SQL Server MCM Program 4
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?
SQL Server Terms: What's in a Name?
When talking about relational databases, does it matter which terms you use to describe an object as long as the meaning is fully understood?
How Much Social Networking Is Too Much? 3
Kalen explores the best place to post technical information on social media networks.
Is Failure an Option? 2
Kalen explores whether a version of SQL Server can be considered a failure if its missing features that were supposed to be in it.
Disseminating SQL Server Information 8
How can we ensure that everyone can find the SQL Server information they need?
Why Learn About SQL Server Internals? 2
Should you learn SQL Server internals? If you're interested in how SQL Server really works, you should.
Do You Have a Free Saturday? 5
Kalen explores the popularity of attending and speaking at the SQL Saturday events.
Ask Me About What I Know 1
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.
How Will Cloud Computing Affect Your Programming and Management Practices? 4
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?
Could Piracy Limit Sources of SQL Server Help? 10
Kalen addresses the consequences that come with people referencing pirated electronic copies of SQL Server books rather than purchasing the books.
The Value of an MVP 7
Kalen looks at the Microsoft MVP Summit and discusses what makes an MVP valuable, as well as what's valuable to an MVP.
How Did We Get Here?
Kalen looks back at the three events and decisions that impacted the course of her professional life.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×