Understanding SQL Query Optimization – (Part 1)
Most of the activity of the database server is related to queries. Because of this, query optimization is often a...
2013-09-17
992 reads
PowerShell – Script to Monitor a Service on a Group of servers – HTML Formatted Email Output
This post explains how to monitor a given service on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets...
2013-09-19 (first published: 2013-09-17)
3,258 reads
Guide to SQL Server Table Indexes – (Part 4)
Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-09-17
522 reads
Great Idea: Tribal SQL
Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...
2013-09-17
844 reads
Planning for Recovery
A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...
2013-09-17
430 reads
Understanding SSIS Package Configurations
Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages....
2013-09-17
768 reads
Understanding SQL Server Full-text Indexing – (Part 2)
Checkout the final part of this two part article series here, in which I discussed how to create full-text index...
2013-09-17
551 reads
Understanding SQL Server Full-text Indexing – (Part 1)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-09-17
641 reads
Geometry in the Cloud - where geospatial data meets the cloud.
Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...
2013-09-17
1,561 reads
Introduction to Integrity: Chain Linkage Problems
We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings...
2013-09-17
1,146 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers