On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies while improving his/her own skill set. Today we will...
2012-12-24
4 reads
Blog Posts
On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies...
2012-12-24
1,026 reads
On the Sixth Day…
What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras? No animals have...
2012-12-24 (first published: 2012-12-18)
1,710 reads
SQL Server # Moving MASTER database in cluster environment
Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine....
2012-12-24
2,095 reads
SQL Server Database File Size and Free Space
(There is a more up to date version of this script here.
Hey folks, and welcome to my first proper blog post. One of the things that I like to...
2012-12-24
8 reads
Twas The Week After Christmas - 2012 Edition
Season's Greetings and Merry Christmas! In the spirit of the holiday, I am rerunning my original parody on "Twas the...
2012-12-24
1,015 reads
Generate MERGE Statements for Your Tables
Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply...
2012-12-23
1,562 reads
How About a PASS Holiday Ornament?
One of the simpler pleasures in life is having an idea and putting it up for discussion. Not all ideas...
2012-12-23
903 reads
How to drop all tables in a SQL Server Database whose name begins with a common value
Scenario
I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables...
2012-12-23
2,702 reads
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
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