Know Backups and Know Restores – SQL Server Restores
A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving...
2014-05-19
1,289 reads
Tim Radney
Making a Difference – #SQLFamily
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,212 reads
Using BMC Control-M to Automate Tasks
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
4,001 reads
The Primary Filegroup Cannot be Backed Up as a File Backup
File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come...
2014-03-31
2,733 reads
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,106 reads
SSIS Training class by Andy Leonard
Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class...
2014-01-30
1,793 reads
How to reset the SA password in SQL Server
Getting locked out of a SQL Server can happen in a number of ways. You could inherit a server that...
2013-11-28 (first published: 2013-11-21)
6,066 reads
Children at Technical Conferences
I have had the pleasure of taking my son with me on a number of trips where I was a...
2013-10-22
829 reads
Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the...
2013-10-02
1,287 reads
Why I am not an MVP
On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to...
2013-10-02
762 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
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
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 n;See possible answers