Generating Missing Dates and Numbers
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
Regular Expression Transformation
The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. If all columns selected pass their tests then rows are passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output.
The Baker's Dozen: 13 Comparisons Between Crystal Reports and SQL Server Reporting Services
Explore how the rich reporting functionality in Crystal Reports XI and SQL Server Reporting Services 2005 works with common reporting requirements.
A Look at Log Explorer
Have you ever wanted to read your transaction log? Wonder what information is inside there? New author S. Srivathsani takes a look at one of the log tools out on the market, Lumigent's Log Explorer.
Compensation
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
Feedback - iPod
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
Feedback - MP3
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
Feedback - WMV
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
Principles of ROI Development for Data Quality Projects
This article outlines 15 principles of ROI development for data quality (DQ) projects that can be leveraged across any industry.
Which is Faster: SAN or Directly-Attached Storage?
Or should I place my database files on SAN or directly-attached storage? This is a frequently asked question. It comes up repeatedly in public newsgroups, email discussion lists, and private meetings with customers who are concerned with database performance.
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