The Joy of Realistic Generated Fake Database Data
The post The Joy of Realistic Generated Fake Database Data appeared first on SQLServerCentral.
What is a Relational Database Management System
The post What is a Relational Database Management System appeared first on SQLServerCentral.
PostgreSQL DML Statements
DML, or Data Manipulation Language, statements are used to manipulate the data present in a database. The most important DML statements are INSERT, UPDATE & DELETE. This tutorial covers the various PostgreSQL DML statements and how we can use …
Want to Avoid Deployment Downtime? Replication Probably Isn’t the Answer.
You’re tired of taking outages to deploy changes to your database schema. Wouldn’t it be cool to have two different SQL Servers so that you could: Point your customer traffic at ServerA Apply your deployment scripts to ServerB (which isn …
Database version control: Getting started with Flyway
“Database migrations made easy” and “Version control for your database” are a couple of headlines you will find on Flyway’s official website. And let me tell you this, those statements are absolutely correct. Flyway is a m …
Maintaining a Database Build Script with SQL Compare
The post Maintaining a Database Build Script with SQL Compare appeared first on SQLServerCentral.
SQL Server interview questions for experienced developers
This article defines ten SQL Server tech interview questions for senior SQL server developers and provides answers and examples. While there are hundreds of articles and blog posts related to SQL server interviews on the Internet, I have decided to sha …
Heaps in SQL Server: Part 4 PFS contention
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps in SQL Server: Part 3 Nonclustered Indexes Heaps in SQL Server: Part 4 PFS contention After looking at the internal structures and the se …
Spoofing Data Convincingly: Text Data
The most difficult data to fake or generate is convincing text. To mimic any commercial business process for an application that you are developing, you need to be able to generate text that looks right. Why would you need lots of data? Most experience …
What’s most important to you when dealing with database software?
The post What’s most important to you when dealing with database software? appeared first on SQLServerCentral.
Import Excel Data into SQL Server with PowerShell
The post Import Excel Data into SQL Server with PowerShell appeared first on SQLServerCentral.
DAX financial functions: Depreciation calculations
The series so far: DAX financial functions: Loan calculations DAX financial functions: Depreciation calculations This article continues the introduction to the DAX financial functions begun in DAX financial functions: Loan calculations. As noted there, …
Are You Underpaid? Find Out in the Data Professional Salary Survey Results.
We asked what you make, and 1,747 of you in 69 countries answered. Altogether, you made $171,879,034 this year. Hubba hubba, there’s some earning power in this audience. Download the Data Professional Salary Survey results (XLSX). A few things to …
Do *not* place TEMPDB on a local disk in a SQL failover cluster
The Feature As of SQL Server 2012, using local disks for TEMPDB on a failover cluster is a fully supported feature. In the light of fast storage solutions (SSD / NVME) directly plugged into the mainboard of a system, this is a big step forward because …
SQL Server Management Studio Database Diagram Support Objects Cannot be Installed
The post SQL Server Management Studio Database Diagram Support Objects Cannot be Installed appeared first on SQLServerCentral.