Blogs

Technical Article

Challenging the Tyranny of Third-Party Vendors: A DBA’s Manifesto

  • Article

Over the years, I have dealt with a lot of third-party applications (and their vendors) that use SQL Server as their back-end databases. It has often been an uneasy relationship, fraught with pain and tribulation. The overriding feeling I have gotten...

You rated this post out of 5. Change rating

2009-02-12

1,514 reads

Technical Article

Ways To Build Your Brand

  • Article

This is in the presentation I've given a few times, but I thought it made some sense to put these things out here as well. I see there are a few major ways for you to build your brand and raise your profile in the modern world that is highly interconnected...

You rated this post out of 5. Change rating

2009-02-11

811 reads

Technical Article

Who Do We Choose to Follow?

  • Article

Think about your career and the managers, and potentially leaders, that you’ve had in your life. Think about life in general and who do you admire, who have you modeled yourself after or who you wanted to follow in sports, in a hobby, in life, etc.

You rated this post out of 5. Change rating

2009-02-06

1,353 reads

Technical Article

All the Aggregates you crave with Grouping Sets in SQL Server 2008

  • Article

As reporting requirements increase, it seems that aggregate functionalities have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples Canada’s best vendor, BaldGorilla, where I’m currently consulting, has been able...

You rated this post out of 5. Change rating

2009-02-05

2,050 reads

Technical Article

Ruthless Focus - A Different Type of Time Management Philosophy

  • Article

If you could list all the reasons I work, the number one reason would be to support my family. My definition of support includes spending an appropriate amount of time with family, not just working to support it. I suspect most of you would agree with that as a goal.

You rated this post out of 5. Change rating

2009-02-04

1,886 reads

Technical Article

PASS Update #3

  • Article

It's been busy since my last update, lots of stuff to work on! I probably won't get it all in one post, but I'll try to hit the highlights. The main event over the past two weeks was my first board meeting in Seattle. I arrived Monday afternoon

You rated this post out of 5. Change rating

2009-02-02

1,001 reads

Blogs

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Why use XACT_ABORT?

By

This came up one day at my work when a developer was using it....

Using AI for Data Conversion

By

I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...

Read the latest Blogs

Forums

sp_lock memory leak

By TheRedneckDBA

I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...

Migration related issue

By LearningDBA

I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...

How Much AI Code Would You Use?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Much AI Code Would...

Visit the forum

Question of the Day

Browsing for Instances

I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?

See possible answers