Kalen Delaney at the Denver SQL Users Group
Sponsored by Dell, Kalen Delaney is coming to the Denver Marriot Tech Center on June 9.
Sins of SQL: The Time Table
Steve Gray discusses one of the oldest OLAP techiques for representing the time dimension - and shows why it's a lot easier to stick to DATETIME values.
TCA
SQL Server has a lower TCA, total cost of administration, than Oracle. Steve Jones comments today on a few of the reasons.
Statistical Sampling for Verifying Database Backups
A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to bear to minimize the risk of failure of an emergency database restore.
A Google-like Full Text Search
Implementing searching in your database is always a challenge and MVP Michael Coles brings us a method of building a Google-like search for SQL Server.
Getting the Message
Regardless of the speed of your SQL routines there comes a time, for any server-based system, when you need to think "parallel" and "asynchronous". So why, Phil Factor wonders, does there seem to be so little interest in Service Broker?
Free e-book: Introducing Microsoft SQL Server 2008 R2
For a limited time, you can download this 10-chapter e-book: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.
Running SQL Server Jobs using a Proxy Account
Proxy accounts are a useful tool to enable teams to work independently allow users who do not have administrative access to SQL Server to run jobs.
TSQL Challenge 31 - Managing multiple overlapping date intervals.
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers