Kathi Kellenberger 15 October 2018

Do You Have a Career or a Job?

0

2

Editorials

Recently, I thought about the difference between a career and a job. Technically, a job is one employment agreement out of many that span a career. A career could be database administration, while a job could be the time employed at one company. The difference between these could be considered in another way, however. If … Read more

0

2

Editorials

Kathi Kellenberger 23 September 2018

Is Certification Worth It?

15

3

Editorials

I was recently asked if I thought getting a Microsoft certification was valuable. I see quite a few benefits. Certifications might help your company become a Microsoft Gold Partner, and certification may be a selling point when assigning consultants to engagements. For me, the big benefits have been about learning new features and getting to … Read more

15

3

Editorials

Kathi Kellenberger 21 August 2018

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

6

35

Database Administration

Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.… Read more

6

35

Database Administration

Kathi Kellenberger 20 August 2018

Giving Back to the Tech Community

6

14

Editorials

Most of us haven’t learned everything we know about technology from books or classes. Instead, when things go wrong, a quick search on Google or Bing typically brings up possible solutions from others who have experienced the same problem. I often wonder about that unfortunate guy who is the first to tackle a difficult issue. … Read more

6

14

Editorials

Kathi Kellenberger 08 August 2018

Why Everyone Developing T-SQL Needs to Learn About Graphical Execution Plans

5

6

Editorials

Just recently, my local .NET user group asked me to present at their meeting on the topic of graphical execution plans. I love presenting for developers on SQL Server topics. I’m often describing something well known by database administrators, but completely new to the devs. I think the group learned a lot from me that … Read more

5

6

Editorials

Kathi Kellenberger 23 July 2018

Automation and Work

11

3

Editorials

I recently took two of my grandchildren to a McDonald’s restaurant for some lunch. We were greeted by a young woman with a big smile on her face asking if she could show us how to use the new kiosk to place our order. My first thought is that she must have been instructed by … Read more

11

3

Editorials

Kathi Kellenberger 14 July 2018

The Top Five Things That DBAs Need to Monitor

1

8

Blogs

Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are the top five things to monitor when you are a SQL Server DBA: … Read more

1

8

Blogs

Kathi Kellenberger 13 July 2018

Star Trek’s Vision of the Future

15

4

Editorials

St. Louis, MO, has a wonderful museum called The St. Louis Science Center. If you are ever in the area, it’s worth a visit. I’m lucky enough to live less than an hour’s drive away and visit once a month or so. My favourite event at the Science Center is called First Friday, an evening … Read more

15

4

Editorials

Kathi Kellenberger 27 June 2018

T-SQL Window Functions and Performance

0

20

T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.… Read more

0

20

Kathi Kellenberger 20 June 2018

Taking Time Away from Work

11

5

Editorials

As I write this, my mind is focused on my big holiday trip, just two days away. It’s a trip I’ve been planning for five years, and it includes our children, their spouses, and our grandchildren – eleven people in all. I’m still debating on whether to take a laptop along, but I’m leaning towards … Read more

11

5

Editorials

Kathi Kellenberger 13 June 2018

Introduction to T-SQL Window Functions

0

26

T-SQL Programming

T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.… Read more

0

26

T-SQL Programming

Kathi Kellenberger 05 June 2018

SQL in the City Streamed: The June 2018 Edition

0

1

Blogs

I often joke that I wish cloning was perfected so that I could be two places at once. Sometimes, it is hard to decide which opportunity is more important, for example, my niece’s graduation party ended on up the same day as a concert with my favourite band. My ticket included a meet and greet … Read more

0

1

Blogs

Kathi Kellenberger 01 June 2018

Do We Really Care About Privacy?

5

7

Editorials

You may have noticed a recent flurry of activity in your email inbox as many companies sent out new privacy policies and, in some cases, asked you to opt-in to continue to receive communications from them. This coincides with the deadline to comply with the GDPR (General Data Protection Regulation). This regulation is meant to … Read more

5

7

Editorials

Kathi Kellenberger 17 May 2018

One Space or Two?

12

4

Editorials

Typewriters have become rare over the past twenty years or so as we began to use computers more often at home and in the workplace. Correction tape, whiteout, and those typing erasers with a brush on the end have been replaced by the backspace and delete keys. Most people welcome this progress or have never … Read more

12

4

Editorials

Kathi Kellenberger 02 May 2018

Why Database Administrators Need Monitoring Tools

1

4

Editorials

I was recently asked about which tools I used back when I was a full-time SQL Server database administrator. I had a tool to compress backups and a monitoring tool with licenses for just a fraction of the servers I was responsible for. Over time, I figured out ways to gather information or automate processes … Read more

1

4

Editorials

Kathi Kellenberger 08 April 2018

The Facebook Fiasco

15

4

Editorials

About ten years ago, my friends and family were abandoning their Myspace accounts and heading to Facebook. I fought it for a while but eventually assimilated and ended up with over 650 Facebook “friends” at last count. Even my mother embraced the platform, very happy that she could see frequently updated photos of her many … Read more

15

4

Editorials

Kathi Kellenberger 20 March 2018

Be Prepared when Disaster Strikes

2

1

Editorials

It was a rough winter for flying in and out of Heathrow as the UK experienced unusually cold and snowy weather. Unfortunately, one of my colleagues and I landed at Heathrow on 10 December during one of these storms. There was just a small amount of snow on the ground, but thousands of passengers were … Read more

2

1

Editorials

Kathi Kellenberger 09 March 2018

Supporting Women in Technology

6

Editorials

We make a special effort in March to acknowledge the accomplishments of women. Women have been making gains in many professions over the past several decades but are still underrepresented in technology. There are several hypotheses about why this is the case, but often women find they are not welcome in the “brogrammer” cultures of … Read more

6

Editorials

Kathi Kellenberger 07 February 2018

Working from Home

15

6

Editorials

I’ve been fortunate enough to work from my home office for the past six years. My commute is about twelve steps, or, occasionally, a 45-minute drive to the nearest airport. It may not be for everyone, but I think that more employers should let their workers take advantage of an arrangement like this. Since I … Read more

15

6

Editorials

Kathi Kellenberger 09 January 2018

Time Off

13

7

Editorials

Time is a precious commodity, and so much of our time is dedicated to working. IT professionals often have jobs with good benefits, including generous paid time off. It’s very important to get away from work to relax and recharge, but, sometimes, it’s difficult to take those days that belong to us. Even when we … Read more

13

7

Editorials

Compliant Database DevOps

By need

By role

Kathi Kellenberger