Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Gain Space Using XML data type
This article is an attempt to explain the application of new XML support in SQL Server 2005 for efficient data storage and performance.
SQL Server Logs - SQL School Video
Did you know that SQL Server maintains a great set of text logs about events on the server? MVP Andy Warren shows you how to get information out of the error logs in this SQL School video.
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
Attribute Discretization: Using the “Clusters” Method
Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Looking for Good (and Bad) SQL Server Blogs
I was asked to do an hour presentation during the 24 Hours of PASS, which takes place on Sept 2,...
SQL Server 2008 Analysis Services Performance Guide
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers