2020-01-11
275 reads
Database Weekly
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
2020-01-04
275 reads
The New Year: A Chance to Start Over
January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]
2019-12-28
109 reads
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
150 reads
Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
2019-12-07
309 reads
How SQL Server Can Just Go Faster
It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
2019-11-30
558 reads
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
222 reads
A Faster tempdb
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,089 reads
Become a Technological Historian
This week Grant muses on how history can impact our decisions moving forward, and having a little empathy can be useful when re-examining the past.
2019-10-26
128 reads
2019-10-12
206 reads
Blogs
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
Full-Text Search in SQL Server: A Comprehensive Guide
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
Reading JSON Data with Python
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Forums
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Script to Merger duplicate indexes
Hello, I am trying to firgure out how to merge duplicate indexes using a...
using Openrowset to access delta files in ADLG2
Dears, I was told that I cannot access delta files in SQL Server Managed...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers