On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season. Silver and Gold also seem to represent something of greater value. We...
2012-12-22
5 reads
Blog Posts
Tracking End of Support/Life Software
I wanted to save this link to the Microsoft Support Lifecycle page and thought I’d share as well. It’s a...
2012-12-22
1,175 reads
What Is Your Mindset?
Steve Jones sent me a link to this post about Intelligence vs Effort months ago, since then I’ve looked at...
2012-12-22
787 reads
A really simple Multiprocessing Python Example
Purpose and introduction A Python program will not be able to take advantage of more than one core or more...
2012-12-21
4,754 reads
Dude Where Did my AD Account Go? Troubleshooting Duplicate SID's.
Hello Dear Reader! I've been working on Setting up a Virtual Lab in using Virtual Box on my work laptop....
2012-12-21
1,480 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter. The recording...
2012-12-21
1,176 reads
It’s A Data Type Conversion Chart
This may not be the coolest thing in the world, but it is quite useful. From the annals of Books...
2012-12-21
661 reads
Long time no blog…
So, you may have noticed that things have been a little quiet around here of late. Sorry about that, I’ve...
2012-12-21
811 reads
On the Ninth Day…
It’s the end of the world as we know it. And as the song goes…I feel fine! But hey, we...
2012-12-21
1,234 reads
On the Ninth Day…
Creating a custom data collector can be very handy for a DBA. Especially in times of troubleshooting. These collectors are also quite useful for trending and analysis. Consider this...
2012-12-21
16 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