Configuring geo-replication for an Azure SQL Database
This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.
2016-06-27
1,394 reads
Microsoft Azure
Migrating an on premise SQL Server Database to Azure
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
2016-04-21
1,571 reads
Hello Azure: Azure IaaS - Getting Started
A new series to take you through the basics of how to get started using Azure as your own personal lab.
2015-11-03
2,914 reads
Creating SQL databases on Azure Blob storage
Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.
2015-09-17
3,436 reads
Notify user using trigger
On one of our databases we have a table on which data in appended whenever we have a problem in that database. Normally we check the table from time to time to look for addition of data. But I would like to create a trigger to notify a user (net send operator) on our network […]
2004-10-21
1 reads
RE: Importing a CSV file using a DTS
Hi,I am sorry to post my answer accidentally before I am done:(Continued) . delete the temporary tableAll of the 4 steps above can be in one stored procedure. If you want, you can even:-modify step #2, replace any comma by ~-create a macro in excel to convert all '~' to ',' then set it up to […]
2004-10-15
RE: Slow performance on large inserts
Yes, SQL Profiler is the right tool to use next. The easiest way to use is start with the default options and add bits and pieces to it until you get the effect that you want. Then set run the trace for a while. If you get a lot of data or you want to keep it, […]
2004-10-06
RE: Not an OLAP Admin on my own machine?
Had the same problem. Reinstalling service pack 3a fixed the issue.
2004-10-05
RE: Microsoft XP SP2 blocks SQL Server
Those are the major ones people are screaming about. I think the general consensus is the XP firewall is a good step in the right direction, but grab another one and turn XP's off. It's not as feature-rich and user-friendly as the ones which are commercial but free to home users.
2004-08-19
RE: ODBC connection
IPSec policy as well. You can set a policy on the SQL Server to specifically block that IP. Defense in depth. That way if a configuration change happens on the firewall and suddenly allows connections inbound, you've still got the IP blocked at the server.
2004-08-04
Blogs
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers