Window Functions in SQL Server
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
First Impressions
Today we have a guest editorial from Andy Warren that examines the first impressions that you create when you meet someone.
Organizational Approaches to Master Data Management
This series of technical articles describes organizational approaches to master data management.
Using and Creating Mount Points in SQL Server
This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them.
Resource Governor
If you suffer from runaway queries, if you have several database applications with unpredictable fluctuation in workload, or if you need to ensure that workloads get the memory or CPU they need according to certain priorities, then you need Resource Governer, and you need Roy Ernest's clear explanation of the technology.
License By Core
Microsoft recently announced changes in the licensing for SQL Server 2012 and Steve Jones has a few thoughts on the topic.
Create a Monitoring Server for SQL Server with PowerShell
At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.
SQL Server Professionals Survey – Win $50 Amazon voucher!
Take part in a simple 5-minute survey for SQL Server Professionals and win one of two $50 Amazon vouchers.
Field Level Auditing using Change Data Capture – Part 2
Second part of two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports. I uploaded the entire Word document that includes the images.
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers