Killing FTS
Steve wonders today if the Full-Text Search system in SQL Server is due for a replacement, perhaps with other technologies.
Database provisioning and containers – can you help?
If you work with SQL Server, Redgate would love to talk to you about how you’re using (or thinking of using) containers, how you see databases fitting into your workflows involving them, and any challenges you’ve hit so far.
Free Webinar: The State of SQL Server Monitoring 2019
With a line up like this, it's a webinar not to be missed! Join Grant Fritchey, Chris Yates, Annette Allen, and Tony Maddonna on Tuesday June 25th as they discuss the key findings of Redgate’s 2019 State of SQL Server Monitoring survey.
The BI Journey: The Journey Begins
Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after the initial success, plans are made to sustain and grow the project.
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
Group Managed Service Accounts (gMSAs) in SQL2016
Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON
Practice Those Scripts
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
What’s Better, CTEs or Temp Tables?
Brent get's asked this question a lot, so here he has set up an example with the Stack Overflow database. His query’s goal is to find the top 5 Locations, and list the users who live in those top 5 Locations, alphabetized by their DisplayName.
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
Using VMware VMDKs for SQL Server Database Cloning
Learn how you can clone a database with a VMDK virtual disk to store your data.
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers