SQL Server v.Next - Linux Installation Step by Step
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,549 reads
Articles
Reading, Writing, and Creating SQL Server Extended Properties
There is a great gulf between wanting to document your database properly with extended properties and actually doing it. Extended Properties have many uses but they aren't easy to use. Phil Factor is on a mission to make it easier for ordinary mortals to use extended properties as intended, to aid the database development process.
2016-12-27
3,765 reads
Extended Events for Tracking Backup and Restore Progress
Microsoft has introduced new extended events in SQL server 2016 which will give us detailed information about restore and backup process.
2016-12-26
2,062 reads
Spills SQL Server Doesn’t Warn You About
Table variables get a lot of bad press, and they deserve it. They are to query performance what the TSA is to air travel. No one’s sure what they’re doing, but they’ve been taking forever to do it.
2016-12-26
3,341 reads
Managing Packages Using Windows PowerShell
Windows hasn't had a package manager in the style of the Advanced Packaging Tool (APT) of Linux distributions. Apt-get is a great way of installing packages and other software. We have Chocolatey, of course which has a growing library of software and even allows you to automatically update software. Now PowerShell has an 'official' way of using any system, such as NuGet, Chocolatey, GitHub or PSget. It is definitely useful and likely to mature into an indispensable tool for Windows users. Nicolas explains wh.
2016-12-23
3,951 reads
2016-12-22
1,832 reads
Capacity Planning Using Performance Data
Erin Stellato discusses the types of performance data needed to help with capacity planning.
2016-12-22
6,527 reads
2016-12-21
127 reads
Disconnecting SQL Server connections after query execution
One way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS.
2016-12-21
5,620 reads
What is Azure SQL Data Warehouse?
Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.
2016-12-21
3,192 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Deep Learning and Craftsmanship Matter
Comments posted to this topic are about the item Deep Learning and Craftsmanship Matter
Building a Real-Time Analytics Pipeline with Azure Stream Analytics and SQL Server
Comments posted to this topic are about the item Building a Real-Time Analytics Pipeline...
Question of the Day
Encoding Strings
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