SQL Server 2005 Paging – The Holy Grail
Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.
Getting Colorful
This Friday we have a fun poll. What interesting descriptions do you use when trying to talk about code with your peers?
Configure Surface Area Configuration for SQL Server 2008 Analysis Services Using Policy Based Management
I have installed a new instance of SQL Server 2008 Analysis Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Analysis Services features in SQL Server 2008?
Training for Managers
Here's one that you might want to pass along to those managers that approve training. Steve Jones gives you the reasons why you ought to consider paying for training.
Version Control your Stored Procedures
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
SQL Server Management Features vs Oracle Database Management Features
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.
Finding Jobs
This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.
Good Enough
When is it worth making an investment to learn a new technology? Steve Jones comments on Powershell as one of those technologies that he has been slow to begin using.
SQL Saturday #38 - Jacksonville
Come attend this great one day free event on the Florida coast on May 8, 2010. There are a number of great speakers that make this worth attending.
SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.
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