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.
The Redmond Agenda
Is there an agenda in Redmond that looks to the cloud first for new versions of the platforms? Steve Jones thinks if there is, it might be a good thing.
Using ASCMD to run command line scripts for SQL Server Analysis Services
Sometimes it would be helpful to run scripts from a command line for Analysis Services. This would be useful for things like creating backups, processing data or running other tasks. Is there a command line tool like sqlcmd for multidimensional databases and Data Mining?
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCU KEDIRI Telp:08218154393
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Alamat Kantor Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers