2019-09-14
299 reads
Database Weekly
Your chance to speak at PASS Summit
When I decided to switch careers about 25 years ago, I had no idea how far I would go in tech. I just wanted to leave the profession for which I had trained and become a developer. My goal was to make the switch by the end of 1998. It actually happened in the summer […]
2019-09-07
138 reads
Always Check on the Basics
The basics are important, especially with regards to backup and restore in SQL Server.
2019-08-31
355 reads
Best Practices and Band Plans
Grant Fritchey explains how database best practices should be followed more like those in Ham radio.
2019-08-03
452 reads
SQL Server 2019 CTP 3.2 Available
Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]
2019-07-27
731 reads
Do You Have the Gifts to Be a DBA?
This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]
2024-08-21 (first published: 2019-07-13)
609 reads
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2025-05-26 (first published: 2019-07-06)
355 reads
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
405 reads
Microsoft and Oracle Cloud Partnership
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
213 reads
Building or Buying Analytics
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
231 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers