Write more compact SQL Server code using new features
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
2018-12-06
3,690 reads
Articles
Transferring Data with JSON in SQL Server
JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.
2018-12-05
3,025 reads
2018-12-04
540 reads
Overview of Azure SQL Database Information Protection
Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this functionality.
2018-12-04
1,981 reads
Cost estimation for SQL Server Azure VMs
This article provides pricing guidance for SQL Server virtual machines in Azure.
2018-12-03
3,340 reads
Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package
In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.
2018-12-03
2,109 reads
The Curse of Cursor Options
Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.
2018-11-30
3,017 reads
T-SQL Decommenter Part IV
Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.
2018-11-29
646 reads
Meeting Preparation for SQL Server Projects
Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.
2018-11-29
2,515 reads
SQL Server on Amazon Web Services (AWS)
Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).
2018-11-28
2,382 reads
Blogs
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Forums
Create filegroups in partition
I have a table with partition on create_timestamp field. Though we're storing all data...
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers