Import Data from PDF to SQL Server
In this article we look at how we can use R and SQL Server to import lottery numbers from a PDF document into a SQL Server table.
2021-01-11
SQL Server
SQL Server Error Log
The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. In this article, Greg Larsen explains the details and how to configure the SQL Server error log.
2021-01-08
Import Excel Data into SQL Server with PowerShell
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
SQL Server Management Studio Database Diagram Support Objects Cannot be Installed
In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner.
2021-01-01
SQL Server MSDB Database Tutorial
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database...
2020-12-29
SQL Server REPLACE
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
2020-12-28
How To Install SSAS 2019
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
2020-12-22
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
Export SQL Server Data to Multiple Excel Worksheets with C#
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
2020-12-07
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers