SQLServerF1 – In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions on SQL Server, SQL Server Trainings and many more
SQLServerF1 Provides Blogs on Microsoft SQL Server Technology and its internals and troubleshooting, SQL Server Conferences and Events which happen globally, Frequently asked questions on SQL Server technology, SQL Server Trainings and many more.
SQLServerF1 blog covers large number of interesting topics related to
SQL Server Database Engine – Microsoft SQL Server runs on the operating systems as a service. A service is a type of application that runs in the system background and typically run without showing a user interface on the computer desktop. The SQL Server Database Engine, SQL Server Agent, and several other SQL Server components run as services. These services typically are started when the operating system starts. This depends on what is specified during setup; some services are not started by default.
Most blogs will fall under this category and some of the topics come under this are,
SQL Server Replication – Replication is used for copying and distributing data and database objects from one database to another and then synchronizing the data to maintain consistency. Replication can be used to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet. There are different types of replication configurations like Transactional Replication, Snapshot Replication and Merge Replication.
SQL Server Log shipping – allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. An optional third server instance, known as the monitor server, records the history and status of backup and restore operations and, optionally, raises alerts if these operations fail to occur as scheduled.
SQL Server Database Mirroring – Database mirroring is a solution for increasing the availability of a SQL Server database. Database mirroring provides complete or almost complete redundancy of the data, depending on whether the operating mode is high-safety or high-performance.
SQL Server Failover Clustering – Provides high availability for SQL Server databases, it is recommended to host critical SQL Server instances on server clusters. Each node has its own memory, system disk, operating system, and subset of the resources in the cluster. Servers are configured using Cluster Service to share common data and work as a single system. Each server can operate independently of other servers in the cluster. So if one server fails, another server takes over its functions.
SQL Server Backup and Restore – SQL Server Backups are the most important in any environment having critical data. We do not know when a disaster can strike, so we should be proactive and ready to recover data based on RPO and RTO service level agreements.
SQL Server Database Snapshots – A database snapshot is a read-only, static view of a SQL Server database (the source database). The database snapshot is transactionally consistent with the source database as of the moment of the snapshot’s creation. A database snapshot always resides on the same server instance as its source database. As the source database is updated, the database snapshot is updated.
Security concepts in SQL Server There are various security configurations in SQL Server to secure critical and important data at different levels. Some of the features include Cell-Level Encryption, Transparent Data Encryption(TDE), Extensible Key Management (EKM)/Hardware Security Module (HSM), SSL Encryption, Backup Encryption.
SQL Server Analysis Services – Microsoft SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting one design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets you design, create, and visualize data mining models that are constructed from other data sources by using a wide variety of industry-standard data mining algorithms. With the SQL Server Analysis Services platform, build high performance analytical models (multidimensional and tabular) that can be used for interactive data analysis, reporting, and visualization
SQL Server Reporting Services – SQL Server Reporting Services provides a full range of ready-to-use tools and services to help one create, deploy, and manage reports for their organization. Reporting Services includes programming features that enable one to extend and customize their reporting functionality. With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. Reports can include rich data visualization, including charts, maps, and sparklines. You can publish reports, schedule report processing, or access reports on-demand. You can select from a variety of viewing formats, export reports to other applications such as Microsoft Excel, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site.
SQL Server Integration Services – Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. One can use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.
SQL Server Tools – Microsoft SQL Server provides many graphical tools and command line utilities that allow users, programmers, and administrators to increase their productivity. Some of the tools which come with complete SQL Server installation are SQL Server Management Studio(SSMS), SQL Server Profiler, Database Engine Tuning Advisor(DTA), SQLCMD utility, SQL Server Business Intelligence Studio, etc
Third-party tools – There are many third party tools which were developed to make it simple in complete different SQL Server related tasks, which otherwise requires lot of manual work. Some of the third party tools include RedGate backup tools for backup management, Oracle GoldenGate Replication, SQL Nexus to analyze performance issues with SQL Server, etc
Also, there are New and latest features of SQL Server released with SQL Server 2012 and SQL Server 2014 like
SQL Server AlwaysON AkA HADRON – Was introduced in SQL Server 2012. SQL Server AlwaysOn Availability Groups provides a high availability and disaster recovery (HADR) solution that improves upon legacy functionality previously found across disparate features. Prior to SQL Server 2012, database mirroring was used to provide local high availability within a data center, and log shipping for disaster recovery across a remote data center. With SQL Server 2012, this common design pattern can be replaced with an architecture that uses availability groups for both high availability and disaster recovery. Microsoft SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability (HA) and disaster recovery (DR) solution for your application.
In-Memory OLTP (In-Memory Optimization) – Was introduced in SQL Server 2014. In-Memory OLTP can significantly improve OLTP database application performance. In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine, optimized for OLTP. The In-Memory OLTP engine is designed for extremely high session concurrency for OLTP type of transactions driven from a highly scaled-out middle-tier. To achieve this, it uses latch-free data structures and optimistic, multi-version concurrency control. The result is predictable, sub-millisecond low latency and high throughput with linear scaling for database transactions. The actual performance gain depends on many factors though.
Cluster Shared Volumes (CSV) – Starting SQL Server 2014, Failover Cluster Instances supports Cluster Shared Volumes (CSV) in both Windows Server 2008 R2 and Windows Server 2012. Traditional failover cluster, which we already know about, allows a given disk (LUN) to be accessed by only one node at a time, meaning SQL Group will own the disk resource and that disk resource cannot be used by any other groups. Now, with CSV support in SQL Server 2014, we can have multiple groups which are owning different SQL Server Instances, can all use single LUN. Now, we can failover one instance from one node to another node, without affecting or having to failover the disk resources along.
SQL Server 2016 News, Features and other details
Other topics covered include troubleshooting various issues on day to day basis by DBA’s,
Troubleshooting SQL Server Performance Problems
Troubleshooting SQL Server or Service Pack Setup Failures
Troubleshooting SQL Server Service Startup Failures
SQL Server Cluster Resource Failures
Troubleshooting SQL Server Connectivity Failures
Database Shrinking/Growth Issues
Issues with SQL Server Maintenance Plans
Troubleshooting SQL Server Browser Problems
SQL Server Frequently Asked Question and Answers
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.