Professional Goals for 2009
Every time management / professional development book out there tells one to not only develop goals but actually write them down. That's...
2009-02-06
1,229 reads
Blog Posts
Speaking / Teaching Engagements
I should have put this out earlier, before going to the SQL Server Innovators Guild, but I got too busy....
2009-02-06
692 reads
PASS Update #4
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my...
2009-02-05
402 reads
SQL Server security bulletin due on Tuesday
As part of its advance notification, Microsoft has released the list of security bulletins that should be coming our way...
2009-02-05
829 reads
SQLSaturday #13 in Atlanta on April 25, 2009
I've been busy with other projects and haven't had time to focus as much as I'd like on my SQLSaturday...
2009-02-05
487 reads
Ways To Build Your Brand
This is in the presentation I've given a few times, but I thought it made some sense to put these...
2009-02-05
1,818 reads
Business Budgets at the Department Level
If you're thinking about taking a job as a manager there are two questions that will help you quickly understand...
2009-02-04
946 reads
Call for Speakers for European PASS Ends February 7th, 2009
There are only a few more days before the call for speaker for European PASS ends, on Saturday, February 7th,...
2009-02-04
460 reads
Kindle Review - Font Sizes
One of the neat things about the Kindle is that you can change font sizes. It's mentioned in many reviews,...
2009-02-04
671 reads
Reminder: South Florida Code Camp is February 7, 2009
The fifth annual South Florida Code Camp is coming up this Saturday, Feb 7, 2009, at Devry University, 2300 SW...
2009-02-04
282 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers