Cross Tab Report in SSRS
The post Cross Tab Report in SSRS appeared first on SQLServerCentral.
Hidden treasures of SQL Prompt
The post Hidden treasures of SQL Prompt appeared first on SQLServerCentral.
Editor Tips and Tricks for Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Da …
Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask
The post Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask appeared first on SQLServerCentral.
Announcing a New Class: Fundamentals of Columnstore
Your report queries are too slow. Will columnstore indexes help? You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your g …
Running Container Workloads in Microsoft Azure
The post Running Container Workloads in Microsoft Azure appeared first on SQLServerCentral.
How SQL Prompt Improves SQL Server Database Development
The post How SQL Prompt Improves SQL Server Database Development appeared first on SQLServerCentral.
When one of your DBA colleagues leaves the company, what is your checklist?
Whether it’s in our personal lives our professional one, we do have checklists for certain tasks. On the professional level, these checklists can be purely technical, like steps for a SQL Server installation, configuration, or even uninstall …
Why choose Oracle?
As an applications development professional, my career objectives are to do work that is fulfilling in the sense that it challenges my capabilities, keeps me on the cutting edge of technology, and pays me decently. I have established my career as an Or …
Building SQL ConstantCare®: Warning You About New Large Tables & Indexes
When I’m doing a SQL Server health check, one of the things I like showing clients is a list of their top tables by size. Inevitably, there are a bunch of tables that: Tables whose names start with “temp” or “backup” or …
Solving the Provisioning Problem in Database Development using Clones
The post Solving the Provisioning Problem in Database Development using Clones appeared first on SQLServerCentral.
A Getting Started PostgreSQL Tutorial
Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various plat …
Database Development with GitHub
The post Database Development with GitHub appeared first on SQLServerCentral.
Searching and Finding a String Value in all Columns in a SQL Server Table
The post Searching and Finding a String Value in all Columns in a SQL Server Table appeared first on SQLServerCentral.
The 4 Presentations I’m Proudest Of, and What Inspired Them
I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are some of the free public presentations I’m the most proud of, and the stories o …