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
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The Backup File Extension
Comments posted to this topic are about the item The Backup File Extension
Ingest and Retrieve data from an ADX Cluster Using Python
Comments posted to this topic are about the item Ingest and Retrieve data from...
The DBAccountant
Comments posted to this topic are about the item The DBAccountant
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers