Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer
In this tip we look at how to use the SQL Server Maintenance Designer to build maintenance plans for your databases and instance.
What you need to consider for your monitoring strategy in 2020
Are you ready for growth in 2020? Whether that means wider business growth which you and your team will be expected to support, expansion of your SQL Server estate, or even your own professional development. Join Redgate in this free webinar on November 20th and be prepared for the coming year.
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”.
SQL Productivity with SQL Prompt
There is an old joke that upgrading to the latest SQL Server is wasted on some DBAs, because they will still stick mainly to what worked in SQL Server 2005. This type of DBA is becoming rare, in my experience, but there is still some truth in the idea that many of us don’t get the ‘full power’ from our SQL Server tools. We work with them as they come, ‘out of the box’, and use only a fraction of their features. The time to explore ‘new stuff’, at least as much as we’d like to, remains elusive.
Falling Behind and Digital Bankruptcy
The challenges of information overload can weigh on technology workers.
Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL
In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.
Splitting a SQL Server Table Over Multiple Files
In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.
Oops, I deleted that data
We all have these days as a DBA, hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of our tables and got it wrong. OK, […]
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