Encrypt Everything
Yahoo recently announced they are encrypting their traffic between data centers. Steve Jones thinks we should encrypt all traffic.
Regrets of the Last Decade
After Steve Ballmer shares some of his thoughts on his time as CEO, Steve Jones decided to give a few of his own thoughts.
Import UTF-8 Unicode Special Characters with SQL Server Integration Services
If you work with large scale SSIS ETL processes and sequences, you are bound to have to work with UTF-8 encoded text files. Without proper handling, UTF-8 / Unicode characters can cause havoc with your SSIS load tasks. Here are some ideas for handling the UTF-8 file formats with SSIS.
Webinar: T-SQL Tips and Tricks
Nigel Sammy will be presenting this PASS Data Architecture VC webinar on December 19 at 12PM CST. The webinar will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries.
DAX Query - Part 2
A more detailed look at the DAX language and some of its more frequently used functions
DAX Query Basics
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
Model Based Testing at Red Gate
Phil Scrace, a test engineer at Red Gate, talks about adopting Model Based Testing (MBT), a technique that combines graph theory and code writing to help keep pace with frequently changing functionality.
SQL Saturday #274 - Slovenia
SQL Saturday is coming to Slovenia on December 21, 2013. This is a free all-day training and networking event for SQL Server professionals.
PVPs
Today Steve Jones talks about those PVPs, private virtual properties, that your company may own. There are challenges with maintaining these items that show the technology field's immaturity.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers