Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Ben Kubicek

SQLServerCentral.com profile

   Items 1 to 17 of 17   
 

You know what we really need? Better interpersonal communication

Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.   Read more...
By Ben Kubicek 2016/09/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 91 reads

An object lesson about what is really important

A story I heard a long time ago reminds us to choose what is really important.  Read more...
By Ben Kubicek 2016/08/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

How do you know when it is time to leave a job?

Today we have a guest editorial from Ben Kubicek as Steve is traveling out of town. I discovered I had stayed at a job about two years too long. Why was that?  Read more...
By Ben Kubicek 2016/07/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 189 reads

An example of how networking netted a new job

Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network. This is a story of how my network helped me get a new job.  Read more...
By Ben Kubicek 2016/07/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Don’t Miss Out on an Opportunity to Connect

There are people in our lives that we want to connect with, so why don't we?  Read more...
By Ben Kubicek 2016/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

A Sad Story about Upgrading to Windows 10

This is a story about a guy that didn't do backups.  Read more...
By Ben Kubicek 2016/03/14 | Source: SQLServerCentral.com | Category: windows 10
Rating: |  Discuss |   Briefcase | 84 reads

Two Things I Would Change in SSISDB Setup

I suggest these two changes to the SSISDB setup to prevent issues down the road.  Read more...
By Ben Kubicek 2016/03/29 | Source: SQLServerCentral.com | Category: ssisdb
Rating: |  Discuss |   Briefcase | 2,490 reads

Where should middle tier business logic be stored?

The age old question of where should business logic be stored  Read more...
By Ben Kubicek 2015/10/16 | Source: SQLServerCentral.com | Category: middle tier
Rating: |  Discuss |   Briefcase | 185 reads

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias  Read more...
By Ben Kubicek 2015/01/26 | Source: SQLServerCentral.com | Category: sub-queries
Rating: |  Discuss |   Briefcase | 11,971 reads

Never give up

When facing a problem you aren't sure you can solve, keep working on it and believe in yourself.  Read more...
By Ben Kubicek 2014/07/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 221 reads

Why Primary Keys can be important on large tables

I inherited a database that was getting large and not performing well. After adding primary keys life got better.  Read more...
By Ben Kubicek 2014/06/30 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 12,174 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 14,705 reads

Try to focus on the positive

When we focus on negative things we get more negative. Be thankful for something positive.  Read more...
By Ben Kubicek 2014/06/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 156 reads

The Last Line of Defense

How do you deal with being the last line of defense at your company?  Read more...
By Ben Kubicek 2014/06/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 209 reads

What is your default database set to?

Some people set their default database to the database they use most often. This can cause issues when a restore fails.  Read more...
By Ben Kubicek 2013/11/14 | Source: SQLServerCentral.com | Category: default database
Rating: |  Discuss |   Briefcase | 7,374 reads

A simple math expression solver

Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.  Read more...
By Ben Kubicek 2011/11/21 | Source: SQLServerCentral.com | Category: recursive function
Rating: |  Discuss |   Briefcase | 5,517 reads

A Search and Replace Script when Moving Objects from Prod to Test

Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.   Read more...
By Ben Kubicek 2010/02/03 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 7,298 reads
   Items 1 to 17 of 17