When Times are Tough, Do You Rise to the Occasion?
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
251 reads
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
251 reads
Brad worries that with the advent and growth of social media, has come an increasing concern that today's private conversation may turn into tomorrow's world-wide Tweet.
2010-09-06
154 reads
Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.
2010-07-05
269 reads
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
2010-04-12
513 reads
How many of you are taking full advantage of SQL Server tools? Brad McGehee thinks the answer is "Surprisingly few", and suggests you take the time to learn, and eventually master, the tools which already come with SQL Server.
2010-03-08
472 reads
A guest editorial from Brad McGeHee today talks about maintenance plans and his new book.
2010-02-04
574 reads
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
632 reads
The SSMS maintenance plan wizard is shunned by many DBAs, but Brad McGehee has come to view it as a perfectly valid and viable tool, especially for part-time or accidental DBAs, or those just finding their feet in the role.
2010-01-11
238 reads
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
59 reads
Brad suggests some tips on how to maximize your professional development in 2010. Get a plan together now, and you'll make your life a lot easier.
2009-11-23
206 reads
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
By John
In a recent video, I took a hands-on look at the Next Gen General...
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
We are in the process of upgrading to SQL Server 2022 and would like...
Comments posted to this topic are about the item How to Choose the Right...
Comments posted to this topic are about the item Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers