PostgreSQL Hibernate Integration
Overview PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language while Hibernate is probably the most popular ORM tool. If you are not familiar with PostgreSQL then I suggest you to …
Why Are Linked Server Queries So Bad?
No, I don’t want to be your valentine. Remember when you were in school, and you had a crush on someone? You would write a note asking them to be your valentine, and you’d ask a mutual friend to pass the note over to them. The adult equival …
Importing a CSV into SQL Server Shouldn’t Be This Hard
Like many of you, I recently had to import some data in a CSV (comma-separated file) into SQL Server. This wasn’t a new process, or an application that needed enhancing, or even an ongoing ETL (Extract, Transform, Load) process that needed to be built. …
Mergers and acquisitions in Insurance
The post Mergers and acquisitions in Insurance appeared first on SQLServerCentral.
Autoscaling in Microsoft Azure
The post Autoscaling in Microsoft Azure appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Summer 2021
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2021 version of our SQL Const …
An Introduction to Power BI
Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be sha …
Best of Summit 2020
The post Best of Summit 2020 appeared first on SQLServerCentral.
SQL Server Restore Database Options and Examples
The post SQL Server Restore Database Options and Examples appeared first on SQLServerCentral.
The key to great database CI is disposable databases
The post The key to great database CI is disposable databases appeared first on SQLServerCentral.
How to Restore a Snapshot in AWS RDS with the Same Name?
The demand for increasingly scalable, capable, and inexpensive database, backup, and recovery solutions has never been higher than it is now, as digital transformation reaches its pinnacle. Restoring is the process of recovering data from a backup and …
Who’s Hiring in the Database Community? July 2021 Edition
Is your company hiring for a database position? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job …
But we’ve always done it this way?
The post But we’ve always done it this way? appeared first on SQLServerCentral.
More on Column Choice and Order for Multi-column Non-Clustered Indexes
In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan — Why? – SQLServerCentral. This ar …
Get Ready: SQL Server 2016 Mainstream Support Ends in One Week.
Brent Ozar, bearer of bad news Who am I kidding? You’re not really going to get ready, but let’s talk about this anyway. SQL Server 2016 mainstream support ends Tuesday, July 13, 2021. According to Microsoft’s SQL Server support polic …