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.
2019-11-01
2019-10-31
10,121 reads
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”.
2019-10-31
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.
2019-10-31
In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.
2019-10-30
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, […]
2019-10-29
9,193 reads
Learn about the factors that should be taken into account if you are considering hosting SAP HANA in a public cloud.
2019-10-29
Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials.
2019-10-29
Make your comment blocks much more useful, in a surprising number of ways
2019-10-28 (first published: 2013-07-08)
45,512 reads
2019-10-28
7,217 reads
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
The word is finally out that Microsoft is no longer supporting SSRS. I just...
I'm running a group MSA for the database engine and SQL Agent in a...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers