Writing Nearly Codeless Apps: Part 1
A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.
Scripts to use XML to insert and update rows in a SQL Server table
The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
Idera SQL Diagnostic Manager 6.2 Review
A look at Idera's Diagnostic Manager and how it can help you diagnose performance issues on your server instance.
No, I do not provide childcare at my technology events...
A guest editorial from Julie Yack looks at the difference between men and women from the perspective of one very successful woman in technology.
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1
The first in this three part series on using Microsoft Assessment and Planning (MAP) Toolkit 5.0 introduces the toolkit and gets started with install and using it.
October Question: Tell us about your favorite experience as a participant in the SQL Server community.
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
The One True Script
Phil Factor less-than-fond memories of the days of the One True Source Script. However, despite recent advances, he wonders just how much smoother team-based database development really is.
TSQL Challenge 40 - Convert string representation of numeric values fr
This challenge involves converting numeric values from binary format to hexadecimal format.
Women and Men - Same or Different?
Today we have a guest editorial from Wendy Pastick, co chair of the Women in Technology Virtual Chapter. Today Wendy takls about how men and women handle their careers.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers