T-SQL Tuesday: Giving back to the community
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
403 reads
Blog Posts
Automating Automatic Indexing in Azure SQL Database
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,939 reads
Day 7 Configuration – Environmental Variable
On day 6 we discussed about Programs. today is very important day, we will discussing about Configuration options or parameters. All...
2018-05-07
243 reads
Is It Possible To Conditionally Index JSON Data?
Check out this week’s episode on YouTube.
Recently I received a great question from an attendee to one of my sessions...
2018-05-07 (first published: 2018-05-01)
1,970 reads
Know About SQL Server Error 6401
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when...
2018-05-07
2,613 reads
Know About SQL Server Error 6401
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when the database has to be modified by using one...
2018-05-07
15 reads
Notes from SQLSaturday Jacksonville 2018
Notes:
Great attendance, easily 400+Lunch was smooth this year due to changing to boxed lunchesRooms were in 2 different buildings. Sometimes...
2018-05-07
277 reads
SQL Server Why Isn't My Transaction Log Truncating
The Transaction log growing is completely normal however there are situations where a transaction log can get to a state...
2018-05-07
59 reads
Which are the queries using a particular index or table?
The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
1,070 reads
Day 6: MySQL Programs
On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation...
2018-05-06
206 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers