Adding Map Callout Boxes in Reporting Services
A callout text box outside the map area would help to enhance the visual effect of presenting data in reporting services.
The Cloud
This editorial was originally published on Sept 11, 2007. It is being re-run as Steve is on holiday. This is an interesting look at the cloud from 2007.
SQL View: Beyond the Basics
Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.
Canceling Customers
Today's editorial was originally published on Sept 4, 2007. It is being re-run as Steve is on holiday. Today Steve talks about the problems with customer service, and how some companies respond.
Simple Steps to Prepare Mirror Database for Mirroring in SQL Server
To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server.
In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.
The Cult of Mediocrity
This guest editorial from Michael Coles was originally published on Aug 1, 2007. It is being re-run as Steve is on vacation. Today Michael talks about the potential for reward for taking risk.
PASS Data Architecture VC presents Neil Hambly on Improve Data Quality & Integrity using Constraints
On Tuesday June 19th 12PM noon Central, Neil Hambly will discuss "Leveraging the power of constraints to improve both data quality and performance of your databases."
The Strategic Value of Monitoring SQL Servers
Why would you ever need to automatically monitor the SQL Servers in your care? What is the business value of doing so? What are the important features that a DBA should look for in a performance-monitoring tool? Rodney Landrum gives answers based on long experience.
Change Tracking - 2008
Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.
The Certification Debate
Today's editorial was originally published on Aug 7, 2007. It is being re-run as Steve is on holiday. Is it worth getting certificated? Steve raises the question today.
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers