#SQLCareer 2/4 July 25th 2018
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-08-13 (first published: 2018-07-30)
1,501 reads
Blog Posts
Disable or Turn-off SQL Server Telemetry Service
With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It...
2018-08-13 (first published: 2018-07-30)
66,693 reads
Employee Agreements & Contracts: Anti-Patterns (31 minute video)
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
14 reads
Fastest Way to Find Row Count of All Tables From All Databases in SQL Server
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
8,229 reads
SQLSaturday Baton Rouge thank yous
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
7 reads
Database Protection in the Cloud Era
The Cloud is a fun and exciting place to be. Exciting as it may be, even in the cloud, protection...
2018-08-10
292 reads
Enable SQLCMD Mode on SSMS
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,524 reads
Money Ball: Fantasy Football Kicks Off Tonight - Jeff's Degenerates
You might think that this blog post is out of place here but I'm hoping use some of the data...
2018-08-10
296 reads
Save the Connection String Parameters in SSMS – AlwaysOn
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,584 reads
Taking the Linux plunge – Update
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
307 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers