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.
Real Time Dangers
Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers