I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. Can you provide an example of how to use this in a report?
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
Would you want to be part of a Strike Force or "A-Team" in IT? Steve Jones thinks most of us would rather just do a good job and go home.
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
Today we have a guest editorial from Andy Warren that asks you to look forward to the next year and think about your future.
This article shows how to slipstream the SP and CU during the SQL Server setup process.
This week Steve Jones talks about the need for people working in technology to be professional students. Get a few ideas of what you can learn this week from Database Weekly.
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
Frequently I find myself in situations where I need to insert records into a table in a set-based operation wrapped inside of a transaction where secondarily, and within the same transaction, I spawn-off subsequent inserts into related tables where I need to pass-in key values that were the outcome of the initial INSERT command. Thanks to a Transact/SQL enhancement in SQL Server, this just became much easier and can be done in a single statement... WITHOUT A TRIGGER!
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item 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