Meme Monday: 11 Words or Less
Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:
Community is nice, but displaces work if...
2011-04-04
733 reads
SQL Saturday #63 – Dallas: Wrap-up
SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...
2011-04-04
789 reads
SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
643 reads
Change SQL Startup Parameters with PowerShell
Backups Abound
The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-03-31
14,349 reads
NOLOCK for Developers
What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...
2011-03-25
1,748 reads
SQLskills Immersion Event on Internals and Performance – Day 5
Overview
Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not...
2011-02-26
1,782 reads
SQLskills Immersion Event on Internals and Performance – Day 4
Overview
We just finished the fourth day of SQLskills learning. Today was all on indexes and statistics. We learned about choosing...
2011-02-25
1,394 reads
SQLskills Immersion Event on Internals and Performance – Day 3
Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...
2011-02-24
474 reads
PowerShell Script for Paul’s Survey: how is your tempdb configured?
Paul Randal (b | t) posted a survey how is your tempdb configured? Since I just happen to be at a...
2011-02-23
745 reads
SQLskills Immersion Event on Internals and Performance – Day 2
Overview
Day two of the SQLskills Immersion Event is over and I have listed the interesting parts below. The food, again,...
2011-02-23
706 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