As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!
Redgate have assembled a small development team to research and build a capability that not only records your deployments over time, but provides a window into past trends and insights. To achieve the best results we need to understand from you what deployment value should be recorded and displayed. Please help us by completing our short two-page survey.
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
The workplace is certainly changing with the COVID-19 pandemic. Steve shares a few learnings from Microsoft's work from home experiment.
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.
By Steve Jones
Over the years I’ve had this blog, I’ve added lots of tags. In 15...
The moment you decide you want to monitor your SQL Server instance for query...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I am trying to automate SSAS cube processing by having an SQL Server...
We are looking for SQL developers as beta users for our SaaS solution (...
Comments posted to this topic are about the item Offline Files
Ask SSC