Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

SQL Server management, tutorials, scripts, coding, programming and tips for database administrators

MS SQL

Implementing Azure SQL Database Virtual Network Service Endpoints and Rules 12/07/2017

In previous articles, we’ve described the main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. In this article, we focus on the details of implementing this functionality.

How to Turn on Instant File Initialization 12/04/2017

Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages. Read on to learn more...

Quickly Restricting Database Access 12/04/2017

There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed.  You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.  Read on to learn how.

Understanding Migration from SQL Server to SQL Server 2017 using Data Migration Assistant 11/27/2017

You can use the Data Migration Assistant (DMA) tool to migrate your SQL Server instance to an on-premise SQL Server 2017 or to Azure SQL Database. DMA analyzes data migration issues and provides recommendations to resolve them. Read on learn about the features of DMA and how DMA eases your SQL Server instance migration as well as reduces overall risks, allowing you to complete the migration successfully.

Azure SQL Database Virtual Network Service Endpoints and Rules 11/06/2017

One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. A recently announced public preview of Azure SQL Database and Data Warehouse VNET service endpoints and rules promises to address this limitation.

How Much Data Has Changed Since Your Last Full Backup 11/02/2017

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.

What to Do When You Get a “Cache is Out of Date” Error Message 11/02/2017

Learn how to fix the “cache is out of date” error message when SQL Server Management Studio starts up.

Dynamic Data Masking on Azure SQL Database 10/23/2017

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application. Read on to learn more.

Azure SQL Database Long-Term Backup Retention 10/05/2017

Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. In addition to Point-in-Time Restore as well as Geo-Restore and Active Geo-Replication, you have the option of implementing long-term backup retention of Azure SQL Database.

9 New Features with SQL Server 2017 10/02/2017

Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.

Overview of Azure Data Lake 09/21/2017

Azure Data Lake stores petabytes of data and analyzes trillions of objects in one place with no constraints. Data Lake Store can store any type of data including massive data like high-resolution video, medical data, and data from a wide variety of industries. Data Lake Store scales throughput to support any size of analytic workload with low latency. Read on to learn more.

Network Configuration of SQL Server Always On Availability Groups in Azure 09/04/2017

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, we will focus on the networking aspects of clustered deployments of SQL Server 2016 in Azure.

Understanding Azure Data Factory – A Cloud Based Integration Service 08/28/2017

Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.

Implementing SQL Server Failover Clustering in Azure 08/07/2017

Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.

Purging Old Database Mail Items 08/03/2017

Are you purging the old database mail items stored in msdb?  In this tip, Greg Larsen shows you how to purge database mail.

MS SQL Archives




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM