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
Additional Articles
Masking Data in Practice
Phil Factor takes a strategic look at common SQL data masking techniques, and the challenges inherent in masking certain types of sensitive and personal data, while ensuring that it still looks like the real data, and retains its referential integrity, and distribution characteristics.
2021-01-11
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
The Joy of Realistic Generated Fake Database Data
Have you ever had to demonstrate a database-driven application, and longed to have the real data to do so? To do what, precisely? Well, so you can then scroll through the customers who have used the system, demonstrate the accounting and audit, browse through the products, maybe even demo the customer tracking system with comments, complaints and so on. All this is possible, using realistic, fake data.
2021-01-08
What is a Relational Database Management System
This article covers the relational database system evolution and covers terms used in relational models such as relation, tuple, attribute, domain, schemas, and key.
2021-01-07
DBA in training: Know your server’s limits
Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.
2021-01-06
Maintaining a Database Build Script with SQL Compare
Phil Factor explores a lesser-known capability of SQL Compare, which is to help you maintain a 'traditional', well-documented, single file build script, for creating the current version of the database during development.
2021-01-06
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
What’s most important to you when dealing with database software?
Take part in this short exercise (no more than 5 minutes) by letting us know what matters most to you when considering, purchasing, or using database software. As a thank you, you can also enter our prize draw at the end for a chance to win a $150 Amazon gift voucher.
2021-01-05
Ten tips for attracting and retaining DevOps talent
To stay competitive and bring value to customers, organisations are adopting DevOps, but finding people experienced in DevOps can be challenging. Robert Sheldon has ten tips to help managers attract and retain DevOps talent.
2021-01-04
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
How to find index usage by stored procedure?
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
Odd things with Report Builder (also tried VS 2019)
This is kinda hard to explain, maybe I can make sense of it. So...
PBM policy to check empty passwords
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...
Ask SSC