Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-20
Windows Azure SQL Database
System Stored Procedures for SQL Azure Linked Servers
Microsoft released the preview version of Azure SQL Database V12 in December of 2014. As a database administrator, you might wonder about the schema and security of these new data marts. Microsoft has supplied system stored procedures for the database developer to query the Linked Servers for this type of meta data, as John Miner explains.
2015-06-05
2,288 reads
Introduction to Azure SQL Database Scalability
One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.
2014-12-17
8,467 reads
Management of Windows Azure SQL Databases via PowerShell with REST APIs
Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.
2014-08-22
8,728 reads
Microsoft Azure SQL Database Security - Firewall Configuration
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.
2014-04-22
3,521 reads
Windows Azure SQL Database - Uploading Data by Using the bcp Utility
Instead of using a custom SSIS-based project to upload content from an on-premise SQL Server database to Azure PaaS-based SQL Database, Marcin Policht presents an alternative approach. Using the bcp utility not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
2014-03-17
3,582 reads
Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services
Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).
2014-02-18
3,765 reads
Migrating SQL Server Database to Windows Azure - Deploying SQL Database
There are a few challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. In this article we turn our attention to an actual deployment and migration of locally stored data to SQL Database.
2013-12-30
3,822 reads
Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues
In this series on implementing data services in Azure, Marcin Policht turns his attention to the remediation of incompatibilities resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, which will need to be addressed as part of the migration process.
2013-11-21
3,052 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers