SQL WHERE Tutorial
In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table.
To Which Experts Should You Listen?
Many experts that speak to at events are working for vendors. Steve notes that this might mean they are making sales pitches, not not always.
How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
Monitoring: The ROI of Build vs. Buy
There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.
How to visualize Python charts in Power BI Part 2
This article continues looking at python code in Power BI to produce charts.
The Challenge of Early Tech Decisions
We often live with our early decisions on technology, which can be a challenge over time.
Things Move Fast
I have several things I’d like to say in the editorial today, but I feel I have to start off with my condolences to the family of Queen Elizabeth II. For that matter, my condolences to the people of Britain. This truly is the end of an era. Things do indeed move fast sometimes. Working […]
Fixing Impostor Syndrome
Lessons on impostor syndrome from a marketer apply to technologists as well.
Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
Data Visualizations for Excel Multi-Chart Sets with SQL Server Data
This article covers how to create multi-chart visualizations in Excel using data from SQL Server.
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
Forums
Is there a way to have dynamic table headers?
Hi everyone I have a SP which compares two tables and outputs mismatching entries:...
Learning a New Language
Comments posted to this topic are about the item Learning a New Language
is there a way to "detect" schema like changes on a server?
Hi, we have a few people who like to experiment on our prod sql...
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers