Blogarama: The Oldest Blog Directory

The title of the blog may throw someone off a little. After all, SQL Server is not a centennial app and the error message doesn't appear to have anything to do with SQL Server. So please bea… Read More

Hi all, This blog covers the process of migrating SAP ASE databases to Microsoft SQL Server using SQL Server Migration Assistant (SSMA) tool. Sybase SAP Adaptive Server Enterprise (ASE) dat… Read More

TL;DR The short version of this blog post is that I have published a new SQL Server Always On Template. Check it out. SQL Always On Template Microsoft SQL Server has an important high availa… Read More

Microsoft Japan Data Platform Tech Sales Team     森本 信次   今回は、クラウドベース… Read More

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’ capabilities. The feature is available in the latest SQL Server Management Stu… Read More

We are happy to inform that the Azure Log Analytics (OMS) Agent is now capable of pushing SQL Server audit logs into Azure Log Analytics (OMS), supporting SQL Server both on-premises, as wel… Read More

Introduction: As a Microsoft Premier Field Engineer, I get to work with amazing colleagues who create incredible customer solutions. Patrick Keisler ( blog | | ) is a long time SQL Server p… Read More

SAP and Microsoft are continuously adding new features and functionalities to the SAP on SQL Server platform. The key objective of the SAP on Windows SQL port is to deliver the best performa… Read More

SQL Server 2008 R2 Management Studio – Darker Shades of Blue Theme SSMS 2008 R2 套用Visual Studio色彩佈景主題環境設… Read More

As part of the Azure Database Migration Service (Azure DMS) Public Preview, we have released a PowerShell library to automate bulk database migrations from SQL Server to SQL Azure Database… Read More

In this post, Senior App Dev Manager Nayan Patel introduces SQL Server PolyBase and shares some insights from a recent engagement using the technology.I was recently involved in helping my c… Read More

With SQL Server 2017 Cumulative Update 3, we introduced an improvement to SQL Server Replication wherein, changes to the Replication agent parameters can be reloaded dynamically, without hav… Read More

Microsoft Japan Data Platform Tech Sales Team 大林裕明 ご存じの方も多いと思いますが… Read More

Hello all, Recently, I had worked on an interesting Login failed error constantly getting reported in SQL Error log. In this blog, we are covering the steps taken to fix the issue. Below er… Read More

In general, there are several links available to download the ODAC components from the Oracle official site.  It varies across the Oracle versions, and the type of installer that we wou… Read More

Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah   Scheduling and Yielding Knowledge Recap  We all know that SQL server is a multi-threads and multi… Read More

高原 伸城 Support Escalation Engineer 皆さん、こんにちは。 BI Data Platform サポー… Read More

神谷 雅紀Escalation Engineer SQL Server データベースエンジンプロセス (プ… Read More

SQL Server Reporting Services failed to start Reporting Services啟動失敗 Problem 問題: The SQL Server Reporting Services (MSSQLSERVER) service failed to s… Read More

When I graduated from college, one of the first computers I ever used was a MacIntosh. I loved the Mac, the user interface, and the overall footprint of that computer. I also started my care… Read More

Guideline for SQL Server configuration, installation and database creation 1.考慮將Windows電源選項(Power Options)調整為高… Read More

A few days ago, I came across an issue where we had to change the SQL server instance collation and we were just asking the clients to rebuild the system databases to do so in the previous c… Read More

Rozhodli jste se vyvíjet ASP.NET Core nebo .NET Core aplikace na MacOS a řešíte jak rozchodit SQL Server? V tomto článku popíšu kroky jak… Read More

I have been asked several times about how to get a Performance Monitor like view on Linux.   There are lots of Linux tools available (top, iotop, Grafana, and SQL Sentry just scrat… Read More

Microsoft Japan Data Platform Tech Sales Team 岩淵 健 これまでプレビュー版としてのӕ… Read More

At the event of SQLSaturday Dallas 2018, it was a great honor to present this new feature that allows you to put Distribution database in AlwaysOn AG. The slide deck for the session can be… Read More

Olá pessoal, depois de um tempo distante estou retornando com um tópico que sempre levanta questionamentos dos clientes quando falamos sobre a automatização de ba… Read More

This post is provided by Premier Field Engineer JJ Jacob who takes a look at the benefits of SQL Server Objects as software artifacts.A recent customer engagement revealed several pain-point… Read More

This short blog discusses how to avoid overloading an on-premises or Azure Proxy server with Backup to URL. Creating a typical .Net configuration file to disable a proxy server will allow Ba… Read More

Recently, we published a PowerShell script to create memory dumps of SQL Server, SSAS, SSRS, and SSIS - called it SQLDumpHelper.ps1 . The PS script uses SQLDumper.exe and it makes it very ea… Read More

Did you know that you can execute R and Python code remotely in SQL Server from any IDE? This eliminates the need to move data around. Instead of transferring large and sensitive… Read More

Few days back, one of my clients' faced an issue with their Availability group getting into the resolving state. On checking the logs found that the issue was due to a split brain scenario a… Read More

Okay folks, we need to have a conversation about SYSTEM permissions in SQL Server. SYSTEM is constantly over-permissioned in SQL Server . Some of the reasons given for why SYSTEM is ove… Read More

As more users migrate their SAP workloads to Azure, they will discover the benefits of migrating the Microsoft SQL Server data tier as well. Storing SQL Server data files on Azure can help s… Read More

We recently released a new version of SQL Server 2016 Report Builder that contained a brand new feature – the ability to enter data directly into an RDL report as an embedded dataset… Read More

Azure Kubernetes Service (AKS) makes it simple to deploy a managed Kubernetes cluster in Azure. The sample application for this article is developed in Angular, ASP.net core and SQL Server… Read More

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model many-to-many relationships. The first implementation of SQL Graph introduced support for no… Read More

Comparing Azure Functions and AWS Lamba Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s… Read More

Hello all, While working with SQL Server, one of the common issue application teams encounter is timeouts. In this article, we are covering approach to troubleshoot SQL Command/Query timeou… Read More

What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans. One of… Read More

Two weeks ago, I found one of my clients encountering an interesting issue where he found that the SQL server management studio (SSMS) works only when it is launched as an Administrator. But… Read More

I was asked to validate  the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article.  An example of the error: The application does… Read More

Overview SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I… Read More

Changing database vendors is not an easy task, but a lot of people do it and for multiple reasons including better pricing or features. Microsoft provides a free tool called the SQL Server M… Read More

This blog takes you through the debugging journey, refreshing us on old concepts and introducing some new ones. Reported Symptoms ·         Ran… Read More

SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments.   When running on smaller environments SQL S… Read More

If you are in the process of moving an existing .NET application to Azure, it’s likely you’ll have to migrate an existing, on-prem SQL database as well. There are a few different… Read More

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schem… Read More

Learn SQL: A Practical Guide for SQL Server and Database Fundamentals' Kindle Edition for free. ...Read More Deal Posted by nick123 Read More

We find great pleasure in announcing the public CTP 2.3 of SQL Server 2019 Analysis Services. New features detailed here are planned to ship later in Power BI Premium and Azure Analysis Serv… Read More

We are excited to announce the public CTP 2.4 of SQL Server 2019 Analysis Services. This public preview includes the following enhancements for Analysis Services tabular models. Many-to-many… Read More

BELLEVUE, Wash. – December 2019 – TimeXtender, a recognized global software company enabling instant access to any type of data in the organization to support advanced… Read More

Instagram Threads, the Twitter clone launched by Meta two weeks ago, is receiving its first feature update. The update includes a follows tab, a translate button for reading text in other la… Read More

Intel reported second-quarter earnings, showing a return to profitability after two consecutive quarters of losses. The stock rose by 7% in extended trading. The company posted a net income… Read More

Kim Zolciak's estranged husband, Kroy Biermann, is urging her to sign off on the sale of their Georgia mansion. A process server attempting to deliver a lawsuit to Kim's home claimed that th… Read More

Hackers have exploited a zero-day vulnerability in Cisco's networking software, compromising tens of thousands of devices. The vulnerability, found in the IOS XE web administration interface… Read More

Review In this post we will aim at secucuring Apache and PHP on our Ubuntu Server 22.04 through various configuration directives. Let’s review what we did so far: We installed an… Read More

This blog starts here at this initial post, with a tutorial for the installation of WordPress 6.3.2 on an Ubuntu 22.04 Server (AWS EC2 instance) with its database hosted on an AWS MySQL RDS… Read More

The focus of this article is on showing how to configure your WordPress installation to improve speed using the AWS CloudFront CDN and enhance security using AWS WAF. This builds on the earl… Read More

This article will go through the basics of hardening a Ubuntu Pro 22.04 server using the CIS Benchmarks. As per Ubuntu documentation: Security Technical Implementation Guides like the C… Read More